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_ITEM_ODS_LOAD dependencies on MSC_ST_ITEM_SUBSTITUTES

Line 426: MSC_ST_ITEM_SUBSTITUTES msis

422: FROM MSC_TP_SITE_ID_LID tps,
423: MSC_TP_ID_LID tp,
424: MSC_ITEM_ID_LID t1,
425: MSC_ITEM_ID_LID t2,
426: MSC_ST_ITEM_SUBSTITUTES msis
427: WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID
428: AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID
429: AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID
430: AND t2.SR_INSTANCE_ID = msis.SR_INSTANCE_ID

Line 456: MSC_ST_ITEM_SUBSTITUTES msis

452: FROM --MSC_TP_SITE_ID_LID tps,
453: --MSC_TP_ID_LID tp,
454: MSC_ITEM_ID_LID t1,
455: MSC_ITEM_ID_LID t2,
456: MSC_ST_ITEM_SUBSTITUTES msis
457: WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID
458: AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID
459: AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID
460: AND t2.SR_INSTANCE_ID = msis.SR_INSTANCE_ID

Line 628: ||' MSC_ST_ITEM_SUBSTITUTES msis'

624: ||' FROM MSC_TP_SITE_ID_LID tps,'
625: ||' MSC_TP_ID_LID tp,'
626: ||' MSC_ITEM_ID_LID t1,'
627: ||' MSC_ITEM_ID_LID t2,'
628: ||' MSC_ST_ITEM_SUBSTITUTES msis'
629: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID'
630: ||' AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID'
631: ||' AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID'
632: ||' AND t2.SR_INSTANCE_ID = msis.SR_INSTANCE_ID'

Line 686: ||' MSC_ST_ITEM_SUBSTITUTES msis'

682: ||' :v_current_user'
683: ||' FROM '
684: ||' MSC_ITEM_ID_LID t1,'
685: ||' MSC_ITEM_ID_LID t2,'
686: ||' MSC_ST_ITEM_SUBSTITUTES msis'
687: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID'
688: ||' AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID'
689: ||' AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID'
690: ||' AND t2.SR_INSTANCE_ID = msis.SR_INSTANCE_ID'

Line 752: from MSC_ST_ITEM_SUBSTITUTES msis,

748: LOOP
749: DELETE FROM MSC_ITEM_SUBSTITUTES
750: WHERE ( HIGHER_ITEM_ID, LOWER_ITEM_ID, ORGANIZATION_ID, RELATIONSHIP_TYPE) in
751: ( select t1.INVENTORY_ITEM_ID, t2.INVENTORY_ITEM_ID, msis.ORGANIZATION_ID, msis.RELATIONSHIP_TYPE
752: from MSC_ST_ITEM_SUBSTITUTES msis,
753: MSC_ITEM_ID_LID t1,
754: MSC_ITEM_ID_LID t2
755: where
756: t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID