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_DEMAND_ODS_LOAD dependencies on MSC_TP_ID_LID

Line 671: -- msc_tp_id_lid c1,

667: md.customer_id customer_id,
668: md.ship_id CUSTOMER_SITE_ID,
669: md.ship_id SHIP_TO_SITE_ID
670: FROM
671: -- msc_tp_id_lid c1,
672: MSC_ITEM_ID_LID t1,
673: MSC_ITEM_ID_LID t2,
674: MSC_DESIGNATORS md,
675: MSC_ST_DEMANDS msd

Line 1107: MSC_TP_ID_LID mtil,

1103: msd.SR_INSTANCE_ID,
1104: msd.DESIGNATOR_TYPE,
1105: null forecast_Set_id
1106: FROM MSC_ST_DESIGNATORS msd,
1107: MSC_TP_ID_LID mtil,
1108: MSC_TP_SITE_ID_LID mtsila,
1109: MSC_TP_SITE_ID_LID mtsilb
1110: WHERE msd.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
1111: and msd.designator_type = 6

Line 1393: msc_tp_id_lid c1,

1389: msd.LATEST_ACCEPTABLE_DATE,
1390: msd.SHIPPING_METHOD_CODE,
1391: mtsil.location_id ship_to_location_id
1392: FROM
1393: msc_tp_id_lid c1,
1394: MSC_ITEM_ID_LID t1,
1395: MSC_ITEM_ID_LID t2,
1396: MSC_DESIGNATORS md,
1397: MSC_TP_SITE_ID_LID mtsil,

Line 2304: MSC_TP_ID_LID mtil,

2300: FROM MSC_ITEM_ID_LID t1,
2301: MSC_ITEM_ID_LID t2,
2302: MSC_ITEM_ID_LID t3,
2303: MSC_ST_SALES_ORDERS so,
2304: MSC_TP_ID_LID mtil,
2305: MSC_TP_SITE_ID_LID mtsila,
2306: MSC_TP_SITE_ID_LID mtsilb
2307: WHERE t1.SR_INVENTORY_ITEM_ID= so.INVENTORY_ITEM_ID
2308: AND t1.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id||'