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_BOM_COMPONENTS

Line 1945: MSC_ST_BOM_COMPONENTS msbc

1941: msbc.OLD_COMPONENT_SEQUENCE_ID
1942: FROM MSC_ITEM_ID_LID t1,
1943: MSC_ITEM_ID_LID t2,
1944: MSC_ITEM_ID_LID t3,
1945: MSC_ST_BOM_COMPONENTS msbc
1946: WHERE t1.SR_INVENTORY_ITEM_ID= msbc.inventory_item_id
1947: AND t1.sr_instance_id= msbc.sr_instance_id
1948: AND t2.SR_INVENTORY_ITEM_ID= msbc.using_assembly_id
1949: AND t2.sr_instance_id= msbc.sr_instance_id

Line 1960: FROM MSC_ST_BOM_COMPONENTS msbc

1956: SELECT
1957: msbc.COMPONENT_SEQUENCE_ID,
1958: msbc.BILL_SEQUENCE_ID,
1959: msbc.SR_INSTANCE_ID
1960: FROM MSC_ST_BOM_COMPONENTS msbc
1961: WHERE msbc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1962: AND msbc.DELETED_FLAG= MSC_UTIL.SYS_YES;
1963:
1964:

Line 2206: ||' MSC_ST_BOM_COMPONENTS msbc'

2202: ||' :v_current_user '
2203: ||' FROM MSC_ITEM_ID_LID t1,'
2204: ||' MSC_ITEM_ID_LID t2,'
2205: ||' MSC_ITEM_ID_LID t3,'
2206: ||' MSC_ST_BOM_COMPONENTS msbc'
2207: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msbc.inventory_item_id'
2208: ||' AND t1.sr_instance_id = msbc.sr_instance_id'
2209: ||' AND t2.SR_INVENTORY_ITEM_ID = msbc.using_assembly_id'
2210: ||' AND t2.sr_instance_id = msbc.sr_instance_id'