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_ITEM_ID_LID

Line 421: MSC_ITEM_ID_LID t1,

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,
424: MSC_ITEM_ID_LID t4,
425: MSC_ST_SUPPLIES x

Line 422: MSC_ITEM_ID_LID t2,

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,
424: MSC_ITEM_ID_LID t4,
425: MSC_ST_SUPPLIES x
426: WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID

Line 423: MSC_ITEM_ID_LID t3,

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,
424: MSC_ITEM_ID_LID t4,
425: MSC_ST_SUPPLIES x
426: WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID
427: AND t1.SR_INSTANCE_ID= x.SR_INSTANCE_ID

Line 424: MSC_ITEM_ID_LID t4,

420: MSC_TP_ID_LID tp,
421: MSC_ITEM_ID_LID t1,
422: MSC_ITEM_ID_LID t2,
423: MSC_ITEM_ID_LID t3,
424: MSC_ITEM_ID_LID t4,
425: MSC_ST_SUPPLIES x
426: WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID
427: AND t1.SR_INSTANCE_ID= x.SR_INSTANCE_ID
428: AND t2.SR_INVENTORY_ITEM_ID(+) = x.BY_PRODUCT_USING_ASSY_ID

Line 492: FROM MSC_ITEM_ID_LID t1,

488: x.maintenance_object_type,
489: x.CLASS_CODE,
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

Line 514: MSC_ITEM_ID_LID t1

510: t1.INVENTORY_ITEM_ID,
511: mshr.ORGANIZATION_ID,
512: mshr.ORDER_TYPE
513: FROM MSC_ST_SUPPLIES mshr,
514: MSC_ITEM_ID_LID t1
515: WHERE mshr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
516: AND mshr.RO_STATUS_CODE= 'C'
517: AND mshr.ORDER_TYPE=75
518: AND t1.SR_INVENTORY_ITEM_ID(+)= mshr.inventory_item_id

Line 2583: MSC_ITEM_ID_LID t1,

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,
2586: MSC_ITEM_ID_LID t4,
2587: MSC_ST_SUPPLIES x

Line 2584: MSC_ITEM_ID_LID t2,

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,
2586: MSC_ITEM_ID_LID t4,
2587: MSC_ST_SUPPLIES x
2588: WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID

Line 2585: MSC_ITEM_ID_LID t3,

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,
2586: MSC_ITEM_ID_LID t4,
2587: MSC_ST_SUPPLIES x
2588: WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID
2589: AND t1.SR_INSTANCE_ID= x.SR_INSTANCE_ID

Line 2586: MSC_ITEM_ID_LID t4,

2582: MSC_TP_ID_LID tp,
2583: MSC_ITEM_ID_LID t1,
2584: MSC_ITEM_ID_LID t2,
2585: MSC_ITEM_ID_LID t3,
2586: MSC_ITEM_ID_LID t4,
2587: MSC_ST_SUPPLIES x
2588: WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID
2589: AND t1.SR_INSTANCE_ID= x.SR_INSTANCE_ID
2590: AND t2.SR_INVENTORY_ITEM_ID(+) = x.BY_PRODUCT_USING_ASSY_ID

Line 2632: FROM MSC_ITEM_ID_LID

2628: FROM MSC_ST_SUPPLIES x
2629: WHERE x.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2630: MINUS
2631: SELECT SR_INVENTORY_ITEM_ID INVENTORY_ITEM_ID
2632: FROM MSC_ITEM_ID_LID
2633: WHERE SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;
2634:
2635: c_count NUMBER;
2636:

Line 3501: || ' MSC_ITEM_ID_LID t1,'

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,'
3504: || ' MSC_ITEM_ID_LID t4,'
3505: || ' MSC_ST_SUPPLIES x'

Line 3502: || ' MSC_ITEM_ID_LID t2,'

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,'
3504: || ' MSC_ITEM_ID_LID t4,'
3505: || ' MSC_ST_SUPPLIES x'
3506: || ' WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID'

Line 3503: || ' MSC_ITEM_ID_LID t3,'

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,'
3504: || ' MSC_ITEM_ID_LID t4,'
3505: || ' MSC_ST_SUPPLIES x'
3506: || ' WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID'
3507: || ' AND t1.SR_INSTANCE_ID= x.SR_INSTANCE_ID'

Line 3504: || ' MSC_ITEM_ID_LID t4,'

3500: || ' MSC_TP_ID_LID tp,'
3501: || ' MSC_ITEM_ID_LID t1,'
3502: || ' MSC_ITEM_ID_LID t2,'
3503: || ' MSC_ITEM_ID_LID t3,'
3504: || ' MSC_ITEM_ID_LID t4,'
3505: || ' MSC_ST_SUPPLIES x'
3506: || ' WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID'
3507: || ' AND t1.SR_INSTANCE_ID= x.SR_INSTANCE_ID'
3508: || ' AND t2.SR_INVENTORY_ITEM_ID(+) = x.BY_PRODUCT_USING_ASSY_ID'

Line 4720: FROM MSC_ST_OPEN_PAYBACKS MOP, MSC_ITEM_ID_LID MIIL

4716: :v_current_date ,
4717: :v_current_user,
4718: :v_current_date,
4719: :v_current_user
4720: FROM MSC_ST_OPEN_PAYBACKS MOP, MSC_ITEM_ID_LID MIIL
4721: WHERE MIIL.SR_INVENTORY_ITEM_ID = MOP.inventory_item_id
4722: AND MIIL.sr_instance_id = MOP.sr_instance_id
4723: AND MOP.sr_instance_id = :v_instance_id';
4724: