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_ITEM_ID_LID

Line 668: FROM MSC_ITEM_ID_LID t1,

664: mscs.ORGANIZATION_ID,
665: t1.INVENTORY_ITEM_ID SUBSTITUTE_ITEM_ID, -- mscs.SUBSTITUTE_ITEM_ID,
666: mscs.COMPONENT_SEQUENCE_ID,
667: mscs.SR_INSTANCE_ID
668: FROM MSC_ITEM_ID_LID t1,
669: MSC_ST_COMPONENT_SUBSTITUTES mscs
670: WHERE t1.SR_INVENTORY_ITEM_ID= mscs.substitute_item_id
671: AND t1.sr_instance_id= mscs.sr_instance_id
672: AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 681: FROM MSC_ITEM_ID_LID t1,

677: mscs.BILL_SEQUENCE_ID,
678: mscs.COMPONENT_SEQUENCE_ID,
679: t1.INVENTORY_ITEM_ID SUBSTITUTE_ITEM_ID, -- mscs.SUBSTITUTE_ITEM_ID,
680: mscs.SR_INSTANCE_ID
681: FROM MSC_ITEM_ID_LID t1,
682: MSC_ST_COMPONENT_SUBSTITUTES mscs
683: WHERE ((t1.SR_INVENTORY_ITEM_ID= mscs.substitute_item_id) AND (mscs.substitute_item_id
684: is NOT NULL))
685: AND t1.sr_instance_id= mscs.sr_instance_id

Line 914: FROM MSC_ITEM_ID_LID t1,

910: msbr.SR_TRANSACTION_ID,
911: t1.INVENTORY_ITEM_ID ASSEMBLY_ITEM_ID,
912: t2.INVENTORY_ITEM_ID SOURCE_ITEM_ID,
913: msbr.SR_INSTANCE_ID
914: FROM MSC_ITEM_ID_LID t1,
915: MSC_ITEM_ID_LID t2,
916: MSC_ST_BOR_REQUIREMENTS msbr
917: WHERE t1.SR_INVENTORY_ITEM_ID= msbr.assembly_item_id
918: AND t1.sr_instance_id= msbr.sr_instance_id

Line 915: MSC_ITEM_ID_LID t2,

911: t1.INVENTORY_ITEM_ID ASSEMBLY_ITEM_ID,
912: t2.INVENTORY_ITEM_ID SOURCE_ITEM_ID,
913: msbr.SR_INSTANCE_ID
914: FROM MSC_ITEM_ID_LID t1,
915: MSC_ITEM_ID_LID t2,
916: MSC_ST_BOR_REQUIREMENTS msbr
917: WHERE t1.SR_INVENTORY_ITEM_ID= msbr.assembly_item_id
918: AND t1.sr_instance_id= msbr.sr_instance_id
919: AND t2.SR_INVENTORY_ITEM_ID= msbr.source_item_id

Line 1220: FROM MSC_ITEM_ID_LID miil,

1216: msor.LOAD_DISTRIBUTION_PRIORITY,
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

Line 1235: FROM MSC_ITEM_ID_LID miil,

1231: msor.ROUTING_SEQUENCE_ID,
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

Line 1265: msc_item_id_lid t1

1261: msr.BILL_SEQUENCE_ID,
1262: t1.INVENTORY_ITEM_ID item_id,
1263: msr.organization_id
1264: FROM MSC_ST_ROUTINGS msr,
1265: msc_item_id_lid t1
1266: WHERE msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1267: AND msr.assembly_item_id = t1.SR_INVENTORY_ITEM_ID(+)
1268: AND msr.sr_instance_id = t1.sr_instance_id(+)
1269: UNION ALL

Line 1276: msc_item_id_lid t1

1272: msb.BILL_SEQUENCE_ID,
1273: t1.INVENTORY_ITEM_ID item_id,
1274: msb.organization_id
1275: FROM MSC_ST_BOMS msb,
1276: msc_item_id_lid t1
1277: WHERE msb.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1278: AND msb.assembly_item_id = t1.SR_INVENTORY_ITEM_ID(+)
1279: AND msb.sr_instance_id = t1.sr_instance_id(+) ;
1280:

Line 1584: FROM MSC_ITEM_ID_LID t1,

1580: t1.INVENTORY_ITEM_ID ASSEMBLY_ITEM_ID, -- msb.ASSEMBLY_ITEM_ID,
1581: msb.BILL_SEQUENCE_ID,
1582: msb.SR_INSTANCE_ID,
1583: msb.operation_seq_num /* ds change for opm: yielding op seq num */
1584: FROM MSC_ITEM_ID_LID t1,
1585: MSC_ST_BOMS msb
1586: WHERE t1.SR_INVENTORY_ITEM_ID= msb.assembly_item_id
1587: AND t1.sr_instance_id= msb.sr_instance_id
1588: AND msb.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 1721: ||' FROM MSC_ITEM_ID_LID t1,'

1717: ||' :v_current_date,'
1718: ||' :v_current_user,'
1719: ||' :v_current_date,'
1720: ||' :v_current_user '
1721: ||' FROM MSC_ITEM_ID_LID t1,'
1722: ||' MSC_ST_BOMS msb '
1723: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msb.assembly_item_id'
1724: ||' AND t1.sr_instance_id= msb.sr_instance_id'
1725: ||' AND msb.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

Line 1961: FROM MSC_ITEM_ID_LID t1,

1957: msbc.ROUNDING_DIRECTION,
1958: msbc.PRIMARY_FLAG,
1959: msbc.CONTRIBUTE_TO_STEP_QTY, /* ds change */
1960: msbc.OLD_COMPONENT_SEQUENCE_ID
1961: FROM MSC_ITEM_ID_LID t1,
1962: MSC_ITEM_ID_LID t2,
1963: MSC_ITEM_ID_LID t3,
1964: MSC_ST_BOM_COMPONENTS msbc
1965: WHERE t1.SR_INVENTORY_ITEM_ID= msbc.inventory_item_id

Line 1962: MSC_ITEM_ID_LID t2,

1958: msbc.PRIMARY_FLAG,
1959: msbc.CONTRIBUTE_TO_STEP_QTY, /* ds change */
1960: msbc.OLD_COMPONENT_SEQUENCE_ID
1961: FROM MSC_ITEM_ID_LID t1,
1962: MSC_ITEM_ID_LID t2,
1963: MSC_ITEM_ID_LID t3,
1964: MSC_ST_BOM_COMPONENTS msbc
1965: WHERE t1.SR_INVENTORY_ITEM_ID= msbc.inventory_item_id
1966: AND t1.sr_instance_id= msbc.sr_instance_id

Line 1963: MSC_ITEM_ID_LID t3,

1959: msbc.CONTRIBUTE_TO_STEP_QTY, /* ds change */
1960: msbc.OLD_COMPONENT_SEQUENCE_ID
1961: FROM MSC_ITEM_ID_LID t1,
1962: MSC_ITEM_ID_LID t2,
1963: MSC_ITEM_ID_LID t3,
1964: MSC_ST_BOM_COMPONENTS msbc
1965: WHERE t1.SR_INVENTORY_ITEM_ID= msbc.inventory_item_id
1966: AND t1.sr_instance_id= msbc.sr_instance_id
1967: AND t2.SR_INVENTORY_ITEM_ID= msbc.using_assembly_id

Line 2222: ||' FROM MSC_ITEM_ID_LID t1,'

2218: ||' :v_current_date , '
2219: ||' :v_current_user , '
2220: ||' :v_current_date , '
2221: ||' :v_current_user '
2222: ||' FROM MSC_ITEM_ID_LID t1,'
2223: ||' MSC_ITEM_ID_LID t2,'
2224: ||' MSC_ITEM_ID_LID t3,'
2225: ||' MSC_ST_BOM_COMPONENTS msbc'
2226: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msbc.inventory_item_id'

Line 2223: ||' MSC_ITEM_ID_LID t2,'

2219: ||' :v_current_user , '
2220: ||' :v_current_date , '
2221: ||' :v_current_user '
2222: ||' FROM MSC_ITEM_ID_LID t1,'
2223: ||' MSC_ITEM_ID_LID t2,'
2224: ||' MSC_ITEM_ID_LID t3,'
2225: ||' MSC_ST_BOM_COMPONENTS msbc'
2226: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msbc.inventory_item_id'
2227: ||' AND t1.sr_instance_id = msbc.sr_instance_id'

Line 2224: ||' MSC_ITEM_ID_LID t3,'

2220: ||' :v_current_date , '
2221: ||' :v_current_user '
2222: ||' FROM MSC_ITEM_ID_LID t1,'
2223: ||' MSC_ITEM_ID_LID t2,'
2224: ||' MSC_ITEM_ID_LID t3,'
2225: ||' MSC_ST_BOM_COMPONENTS msbc'
2226: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msbc.inventory_item_id'
2227: ||' AND t1.sr_instance_id = msbc.sr_instance_id'
2228: ||' AND t2.SR_INVENTORY_ITEM_ID = msbc.using_assembly_id'

Line 2685: MSC_ITEM_ID_LID t1

2681: msdri.EFFECTIVE_END_DATE,
2682: msdri.LAST_KNOWN_SETUP,
2683: msdri.DELETED_FLAG
2684: FROM MSC_ST_DEPT_RES_INSTANCES msdri,
2685: MSC_ITEM_ID_LID t1
2686: WHERE msdri.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2687: AND t1.sr_instance_id (+) = msdri.sr_instance_id
2688: AND t1.sr_inventory_item_id (+) = msdri.equipment_item_id;
2689: /* ds:plan: change end */