eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ST_OPERATION_COMPONENTS

Line 800: FROM MSC_ST_OPERATION_COMPONENTS msoc

796: COMPONENT_SEQUENCE_ID,
797: BILL_SEQUENCE_ID,
798: ROUTING_SEQUENCE_ID,
799: SR_INSTANCE_ID
800: FROM MSC_ST_OPERATION_COMPONENTS msoc
801: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
802: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;
803:
804: CURSOR c9_d IS

Line 812: FROM MSC_ST_OPERATION_COMPONENTS msoc

808: BILL_SEQUENCE_ID,
809: ROUTING_SEQUENCE_ID,
810: SR_INSTANCE_ID,
811: ORGANIZATION_ID
812: FROM MSC_ST_OPERATION_COMPONENTS msoc
813: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
814: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_YES
815: UNION ALL
816: SELECT DISTINCT

Line 824: MSC_ST_OPERATION_COMPONENTS msoc

820: moc.ROUTING_SEQUENCE_ID,
821: moc.SR_INSTANCE_ID,
822: moc.ORGANIZATION_ID
823: FROM MSC_OPERATION_COMPONENTS moc,
824: MSC_ST_OPERATION_COMPONENTS msoc
825: WHERE msoc.Bill_Sequence_ID= moc.Bill_Sequence_ID
826: AND msoc.Routing_Sequence_ID <> moc.Routing_Sequence_ID
827: AND msoc.Organization_ID= moc.Organization_ID
828: AND msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 882: FROM MSC_ST_OPERATION_COMPONENTS msoc

878: MSC_CL_COLLECTION.v_current_date,
879: MSC_CL_COLLECTION.v_current_user,
880: MSC_CL_COLLECTION.v_current_date,
881: MSC_CL_COLLECTION.v_current_user
882: FROM MSC_ST_OPERATION_COMPONENTS msoc
883: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
884: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;
885:
886: COMMIT;