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_SUPPLY_ODS_LOAD dependencies on MSC_TP_SITE_ID_LID

Line 417: MSC_TP_SITE_ID_LID tps,

413: x.SHUTDOWN_TYPE,
414: x.ACTIVITY_TYPE,
415: t4.INVENTORY_ITEM_ID ACTIVITY_ITEM_ID
416: FROM (select * from MSC_DESIGNATORS where DESIGNATOR_TYPE IN (2,6)) md, --for bug13979785
417: MSC_TP_SITE_ID_LID tps,
418: MSC_TP_SITE_ID_LID tps1,
419: MSC_TP_SITE_ID_LID tps2,
420: MSC_TP_ID_LID tp,
421: MSC_ITEM_ID_LID t1,

Line 418: MSC_TP_SITE_ID_LID tps1,

414: x.ACTIVITY_TYPE,
415: t4.INVENTORY_ITEM_ID ACTIVITY_ITEM_ID
416: FROM (select * from MSC_DESIGNATORS where DESIGNATOR_TYPE IN (2,6)) md, --for bug13979785
417: MSC_TP_SITE_ID_LID tps,
418: MSC_TP_SITE_ID_LID tps1,
419: MSC_TP_SITE_ID_LID tps2,
420: MSC_TP_ID_LID tp,
421: MSC_ITEM_ID_LID t1,
422: MSC_ITEM_ID_LID t2,

Line 419: MSC_TP_SITE_ID_LID tps2,

415: t4.INVENTORY_ITEM_ID ACTIVITY_ITEM_ID
416: FROM (select * from MSC_DESIGNATORS where DESIGNATOR_TYPE IN (2,6)) md, --for bug13979785
417: MSC_TP_SITE_ID_LID tps,
418: MSC_TP_SITE_ID_LID tps1,
419: MSC_TP_SITE_ID_LID tps2,
420: MSC_TP_ID_LID tp,
421: MSC_ITEM_ID_LID t1,
422: MSC_ITEM_ID_LID t2,
423: MSC_ITEM_ID_LID t3,

Line 494: MSC_TP_SITE_ID_LID tps1,

490: x.SHUTDOWN_TYPE,
491: x.ACTIVITY_TYPE
492: FROM MSC_ITEM_ID_LID t1,
493: MSC_ST_SUPPLIES x,
494: MSC_TP_SITE_ID_LID tps1,
495: MSC_TP_SITE_ID_LID tps2
496: WHERE x.DELETED_FLAG= MSC_UTIL.SYS_YES
497: AND x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
498: AND t1.SR_INVENTORY_ITEM_ID(+)= x.INVENTORY_ITEM_ID

Line 495: MSC_TP_SITE_ID_LID tps2

491: x.ACTIVITY_TYPE
492: FROM MSC_ITEM_ID_LID t1,
493: MSC_ST_SUPPLIES x,
494: MSC_TP_SITE_ID_LID tps1,
495: MSC_TP_SITE_ID_LID tps2
496: WHERE x.DELETED_FLAG= MSC_UTIL.SYS_YES
497: AND x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
498: AND t1.SR_INVENTORY_ITEM_ID(+)= x.INVENTORY_ITEM_ID
499: AND t1.SR_INSTANCE_ID(+)= x.SR_INSTANCE_ID

Line 2579: MSC_TP_SITE_ID_LID tps,

2575: x.SHUTDOWN_TYPE,
2576: x.ACTIVITY_TYPE,
2577: t4.INVENTORY_ITEM_ID ACTIVITY_ITEM_ID
2578: FROM MSC_DESIGNATORS md,
2579: MSC_TP_SITE_ID_LID tps,
2580: MSC_TP_SITE_ID_LID tps1,
2581: MSC_TP_SITE_ID_LID tps2,
2582: MSC_TP_ID_LID tp,
2583: MSC_ITEM_ID_LID t1,

Line 2580: MSC_TP_SITE_ID_LID tps1,

2576: x.ACTIVITY_TYPE,
2577: t4.INVENTORY_ITEM_ID ACTIVITY_ITEM_ID
2578: FROM MSC_DESIGNATORS md,
2579: MSC_TP_SITE_ID_LID tps,
2580: MSC_TP_SITE_ID_LID tps1,
2581: MSC_TP_SITE_ID_LID tps2,
2582: MSC_TP_ID_LID tp,
2583: MSC_ITEM_ID_LID t1,
2584: MSC_ITEM_ID_LID t2,

Line 2581: MSC_TP_SITE_ID_LID tps2,

2577: t4.INVENTORY_ITEM_ID ACTIVITY_ITEM_ID
2578: FROM MSC_DESIGNATORS md,
2579: MSC_TP_SITE_ID_LID tps,
2580: MSC_TP_SITE_ID_LID tps1,
2581: MSC_TP_SITE_ID_LID tps2,
2582: MSC_TP_ID_LID tp,
2583: MSC_ITEM_ID_LID t1,
2584: MSC_ITEM_ID_LID t2,
2585: MSC_ITEM_ID_LID t3,

Line 3497: || ' MSC_TP_SITE_ID_LID tps,'

3493: || ' x.shutdown_type,'
3494: || ' x.activity_TYPE,'
3495: || ' t4.INVENTORY_ITEM_ID ACTIVITY_ITEM_ID'
3496: || ' FROM MSC_DESIGNATORS md,'
3497: || ' MSC_TP_SITE_ID_LID tps,'
3498: || ' MSC_TP_SITE_ID_LID tps1,'
3499: || ' MSC_TP_SITE_ID_LID tps2,'
3500: || ' MSC_TP_ID_LID tp,'
3501: || ' MSC_ITEM_ID_LID t1,'

Line 3498: || ' MSC_TP_SITE_ID_LID tps1,'

3494: || ' x.activity_TYPE,'
3495: || ' t4.INVENTORY_ITEM_ID ACTIVITY_ITEM_ID'
3496: || ' FROM MSC_DESIGNATORS md,'
3497: || ' MSC_TP_SITE_ID_LID tps,'
3498: || ' MSC_TP_SITE_ID_LID tps1,'
3499: || ' MSC_TP_SITE_ID_LID tps2,'
3500: || ' MSC_TP_ID_LID tp,'
3501: || ' MSC_ITEM_ID_LID t1,'
3502: || ' MSC_ITEM_ID_LID t2,'

Line 3499: || ' MSC_TP_SITE_ID_LID tps2,'

3495: || ' t4.INVENTORY_ITEM_ID ACTIVITY_ITEM_ID'
3496: || ' FROM MSC_DESIGNATORS md,'
3497: || ' MSC_TP_SITE_ID_LID tps,'
3498: || ' MSC_TP_SITE_ID_LID tps1,'
3499: || ' MSC_TP_SITE_ID_LID tps2,'
3500: || ' MSC_TP_ID_LID tp,'
3501: || ' MSC_ITEM_ID_LID t1,'
3502: || ' MSC_ITEM_ID_LID t2,'
3503: || ' MSC_ITEM_ID_LID t3,'