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 415: MSC_ST_SUPPLIES x

411: MSC_TP_ID_LID tp,
412: MSC_ITEM_ID_LID t1,
413: MSC_ITEM_ID_LID t2,
414: MSC_ITEM_ID_LID t3,
415: MSC_ST_SUPPLIES x
416: WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID
417: AND t1.SR_INSTANCE_ID= x.SR_INSTANCE_ID
418: AND t2.SR_INVENTORY_ITEM_ID(+) = x.BY_PRODUCT_USING_ASSY_ID
419: AND t2.SR_INSTANCE_ID(+) = x.SR_INSTANCE_ID

Line 467: MSC_ST_SUPPLIES x,

463: x.PLANNING_TP_TYPE,
464: DECODE(x.OWNING_TP_TYPE,1,tps2.TP_SITE_ID,x.OWNING_PARTNER_SITE_ID) OWNING_PARTNER_SITE_ID,
465: x.OWNING_TP_TYPE
466: FROM MSC_ITEM_ID_LID t1,
467: MSC_ST_SUPPLIES x,
468: MSC_TP_SITE_ID_LID tps1,
469: MSC_TP_SITE_ID_LID tps2
470: WHERE x.DELETED_FLAG= MSC_UTIL.SYS_YES
471: AND x.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 487: FROM MSC_ST_SUPPLIES mshr,

483: mshr.DISPOSITION_ID,
484: t1.INVENTORY_ITEM_ID,
485: mshr.ORGANIZATION_ID,
486: mshr.ORDER_TYPE
487: FROM MSC_ST_SUPPLIES mshr,
488: MSC_ITEM_ID_LID t1
489: WHERE mshr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
490: AND mshr.RO_STATUS_CODE= 'C'
491: AND mshr.ORDER_TYPE=75

Line 2461: MSC_ST_SUPPLIES x

2457: MSC_TP_ID_LID tp,
2458: MSC_ITEM_ID_LID t1,
2459: MSC_ITEM_ID_LID t2,
2460: MSC_ITEM_ID_LID t3,
2461: MSC_ST_SUPPLIES x
2462: WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID
2463: AND t1.SR_INSTANCE_ID= x.SR_INSTANCE_ID
2464: AND t2.SR_INVENTORY_ITEM_ID(+) = x.BY_PRODUCT_USING_ASSY_ID
2465: AND t2.SR_INSTANCE_ID(+) = x.SR_INSTANCE_ID

Line 2495: FROM MSC_ST_SUPPLIES x

2491:
2492: /* PREPLACE START */ -- Could this be performance intensive
2493: CURSOR c2 IS
2494: SELECT x.INVENTORY_ITEM_ID
2495: FROM MSC_ST_SUPPLIES x
2496: WHERE x.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2497: MINUS
2498: SELECT SR_INVENTORY_ITEM_ID INVENTORY_ITEM_ID
2499: FROM MSC_ITEM_ID_LID

Line 3307: || ' MSC_ST_SUPPLIES x'

3303: || ' MSC_TP_ID_LID tp,'
3304: || ' MSC_ITEM_ID_LID t1,'
3305: || ' MSC_ITEM_ID_LID t2,'
3306: || ' MSC_ITEM_ID_LID t3,'
3307: || ' MSC_ST_SUPPLIES x'
3308: || ' WHERE t1.SR_INVENTORY_ITEM_ID= x.INVENTORY_ITEM_ID'
3309: || ' AND t1.SR_INSTANCE_ID= x.SR_INSTANCE_ID'
3310: || ' AND t2.SR_INVENTORY_ITEM_ID(+) = x.BY_PRODUCT_USING_ASSY_ID'
3311: || ' AND t2.SR_INSTANCE_ID(+) = x.SR_INSTANCE_ID'