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 412: MSC_ITEM_ID_LID t1,

408: MSC_TP_SITE_ID_LID tps,
409: MSC_TP_SITE_ID_LID tps1,
410: MSC_TP_SITE_ID_LID tps2,
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

Line 413: MSC_ITEM_ID_LID t2,

409: MSC_TP_SITE_ID_LID tps1,
410: MSC_TP_SITE_ID_LID tps2,
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

Line 414: MSC_ITEM_ID_LID t3,

410: MSC_TP_SITE_ID_LID tps2,
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

Line 466: FROM MSC_ITEM_ID_LID t1,

462: DECODE(x.PLANNING_TP_TYPE,1,tps1.TP_SITE_ID,x.PLANNING_PARTNER_SITE_ID) PLANNING_PARTNER_SITE_ID,
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

Line 488: MSC_ITEM_ID_LID t1

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
492: AND t1.SR_INVENTORY_ITEM_ID(+)= mshr.inventory_item_id

Line 2458: MSC_ITEM_ID_LID t1,

2454: MSC_TP_SITE_ID_LID tps,
2455: MSC_TP_SITE_ID_LID tps1,
2456: MSC_TP_SITE_ID_LID tps2,
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

Line 2459: MSC_ITEM_ID_LID t2,

2455: MSC_TP_SITE_ID_LID tps1,
2456: MSC_TP_SITE_ID_LID tps2,
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

Line 2460: MSC_ITEM_ID_LID t3,

2456: MSC_TP_SITE_ID_LID tps2,
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

Line 2499: FROM MSC_ITEM_ID_LID

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
2500: WHERE SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;
2501:
2502: c_count NUMBER;
2503:

Line 3304: || ' MSC_ITEM_ID_LID t1,'

3300: || ' MSC_TP_SITE_ID_LID tps,'
3301: || ' MSC_TP_SITE_ID_LID tps1,'
3302: || ' MSC_TP_SITE_ID_LID tps2,'
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'

Line 3305: || ' MSC_ITEM_ID_LID t2,'

3301: || ' MSC_TP_SITE_ID_LID tps1,'
3302: || ' MSC_TP_SITE_ID_LID tps2,'
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'

Line 3306: || ' MSC_ITEM_ID_LID t3,'

3302: || ' MSC_TP_SITE_ID_LID tps2,'
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'

Line 4101: FROM MSC_ST_OPEN_PAYBACKS MOP, MSC_ITEM_ID_LID MIIL

4097: :v_current_date ,
4098: :v_current_user,
4099: :v_current_date,
4100: :v_current_user
4101: FROM MSC_ST_OPEN_PAYBACKS MOP, MSC_ITEM_ID_LID MIIL
4102: WHERE MIIL.SR_INVENTORY_ITEM_ID = MOP.inventory_item_id
4103: AND MIIL.sr_instance_id = MOP.sr_instance_id
4104: AND MOP.sr_instance_id = :v_instance_id';
4105: