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_BOM_ODS_LOAD dependencies on MSC_ST_PROCESS_EFFECTIVITY

Line 1221: MSC_ST_PROCESS_EFFECTIVITY msor

1217: msor.ITEM_PROCESS_COST,
1218: msor.SR_INSTANCE_ID,
1219: msor.RECIPE
1220: FROM MSC_ITEM_ID_LID miil,
1221: MSC_ST_PROCESS_EFFECTIVITY msor
1222: WHERE miil.SR_INVENTORY_ITEM_ID= msor.ITEM_ID
1223: AND miil.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1224: AND msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1225: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO;

Line 1236: MSC_ST_PROCESS_EFFECTIVITY msor

1232: msor.BILL_SEQUENCE_ID,
1233: msor.LINE_ID,
1234: msor.SR_INSTANCE_ID
1235: FROM MSC_ITEM_ID_LID miil,
1236: MSC_ST_PROCESS_EFFECTIVITY msor
1237: WHERE miil.SR_INVENTORY_ITEM_ID(+)= msor.ITEM_ID
1238: AND miil.SR_INSTANCE_ID(+)= MSC_CL_COLLECTION.v_instance_id
1239: AND msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1240: AND msor.DELETED_FLAG= MSC_UTIL.SYS_YES

Line 1250: MSC_ST_PROCESS_EFFECTIVITY mspe

1246: mpe.BILL_SEQUENCE_ID,
1247: TO_NUMBER(NULL),
1248: mpe.SR_INSTANCE_ID
1249: FROM MSC_PROCESS_EFFECTIVITY mpe,
1250: MSC_ST_PROCESS_EFFECTIVITY mspe
1251: WHERE mspe.Bill_Sequence_ID= mpe.Bill_Sequence_ID
1252: AND mspe.Routing_Sequence_ID <> mpe.Routing_Sequence_ID
1253: AND mspe.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1254: AND mpe.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id