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 408: MSC_TP_SITE_ID_LID tps,

404: -- x.PO_LINE_LOCATION_ID,
405: x.INTRANSIT_OWNING_ORG_ID,
406: x.REQ_LINE_ID
407: FROM MSC_DESIGNATORS md,
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,

Line 409: MSC_TP_SITE_ID_LID tps1,

405: x.INTRANSIT_OWNING_ORG_ID,
406: x.REQ_LINE_ID
407: FROM MSC_DESIGNATORS md,
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,

Line 410: MSC_TP_SITE_ID_LID tps2,

406: x.REQ_LINE_ID
407: FROM MSC_DESIGNATORS md,
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,

Line 468: MSC_TP_SITE_ID_LID tps1,

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
472: AND t1.SR_INVENTORY_ITEM_ID(+)= x.INVENTORY_ITEM_ID

Line 469: MSC_TP_SITE_ID_LID tps2

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
472: AND t1.SR_INVENTORY_ITEM_ID(+)= x.INVENTORY_ITEM_ID
473: AND t1.SR_INSTANCE_ID(+)= x.SR_INSTANCE_ID

Line 2454: MSC_TP_SITE_ID_LID tps,

2450: --x.PO_LINE_LOCATION_ID,
2451: x.INTRANSIT_OWNING_ORG_ID,
2452: x.REQ_LINE_ID
2453: FROM MSC_DESIGNATORS md,
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,

Line 2455: MSC_TP_SITE_ID_LID tps1,

2451: x.INTRANSIT_OWNING_ORG_ID,
2452: x.REQ_LINE_ID
2453: FROM MSC_DESIGNATORS md,
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,

Line 2456: MSC_TP_SITE_ID_LID tps2,

2452: x.REQ_LINE_ID
2453: FROM MSC_DESIGNATORS md,
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,

Line 3300: || ' MSC_TP_SITE_ID_LID tps,'

3296: || ' x.schedule_origination_type,'
3297: || ' x.req_line_id,'
3298: || ' x.intransit_owning_org_id'
3299: || ' FROM MSC_DESIGNATORS md,'
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,'

Line 3301: || ' MSC_TP_SITE_ID_LID tps1,'

3297: || ' x.req_line_id,'
3298: || ' x.intransit_owning_org_id'
3299: || ' FROM MSC_DESIGNATORS md,'
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,'

Line 3302: || ' MSC_TP_SITE_ID_LID tps2,'

3298: || ' x.intransit_owning_org_id'
3299: || ' FROM MSC_DESIGNATORS md,'
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,'