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_AHL_ODS_LOAD dependencies on MSC_ST_WO_SUB_COMP

Line 1569: FROM MSC_ST_WO_SUB_COMP sub_comp

1565: sub_comp.RANK,
1566: sub_comp.OP_SEQ_NUM,
1567: sub_comp.RATIO,
1568: sub_comp.PLAN_ID
1569: FROM MSC_ST_WO_SUB_COMP sub_comp
1570: , MSC_ITEM_ID_LID MIL1
1571: , MSC_ITEM_ID_LID MIL2
1572: WHERE sub_comp.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
1573: AND MIL1.sr_instance_id = sub_comp.sr_instance_id

Line 1582: FROM MSC_ST_WO_SUB_COMP

1578: CURSOR c_del IS
1579: SELECT TRANSACTION_ID,
1580: ORGANIZATION_ID,
1581: SR_INSTANCE_ID
1582: FROM MSC_ST_WO_SUB_COMP
1583: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1584: lv_supplies_tbl VARCHAR2(30);
1585: BEGIN
1586:

Line 1655: ||' FROM MSC_ST_WO_SUB_COMP msw, '

1651: ||':v_current_date,'
1652: ||':v_current_user,'
1653: ||':v_current_date,'
1654: ||':v_current_user'
1655: ||' FROM MSC_ST_WO_SUB_COMP msw, '
1656: ||lv_supplies_tbl ||' ms, '
1657: ||' msc_item_id_lid MIL1,'
1658: ||' msc_item_id_lid MIL2 '
1659: ||'WHERE msw.SR_INSTANCE_ID= '