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_ST_SUPPLIES

Line 425: MSC_ST_SUPPLIES x

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
429: AND t2.SR_INSTANCE_ID(+) = x.SR_INSTANCE_ID

Line 493: MSC_ST_SUPPLIES x,

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
497: AND x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 513: FROM MSC_ST_SUPPLIES mshr,

509: mshr.DISPOSITION_ID,
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

Line 2587: MSC_ST_SUPPLIES x

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
2591: AND t2.SR_INSTANCE_ID(+) = x.SR_INSTANCE_ID

Line 2628: FROM MSC_ST_SUPPLIES x

2624:
2625: /* PREPLACE START */ -- Could this be performance intensive
2626: CURSOR c2 IS
2627: SELECT x.INVENTORY_ITEM_ID
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

Line 3505: || ' MSC_ST_SUPPLIES x'

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'
3509: || ' AND t2.SR_INSTANCE_ID(+) = x.SR_INSTANCE_ID'