SELECT distinct u.name, u.updated_by, u.updateddate FROM boopUSER u, boopuser_rtyu ug, booprtyu gwhereu.id = ug.user_id and ug.rtyu_id = g.id and u.ACTIVE_FLAG='Y' and g.id not in (10,11) order by u.name
TBL_FIBER_INV_CMP_REPORT_MV JOB_PROGRESS_FLAG案例1:如果上述图像中的CMM批准长度为70公里,而从(NE.MV_SPAN@DB_LINK_NE_VIEWER的NE、UG、AR len )到NE的长度为100公里,则将(UG=80Km and AR分叉率分别为80% UG_length和20% AR_length。对于示例:70 Km