APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_TP_ID_LID

Line 721: -- msc_tp_id_lid c1,

717: md.ship_id SHIP_TO_SITE_ID,
718: msd.REVISED_DMD_DATE,
719: msd.REVISED_DMD_PRIORITY
720: FROM
721: -- msc_tp_id_lid c1,
722: MSC_ITEM_ID_LID t1,
723: MSC_ITEM_ID_LID t2,
724: MSC_DESIGNATORS md,
725: MSC_ST_DEMANDS msd

Line 1169: MSC_TP_ID_LID mtil,

1165: msd.SR_INSTANCE_ID,
1166: msd.DESIGNATOR_TYPE,
1167: null forecast_Set_id
1168: FROM MSC_ST_DESIGNATORS msd,
1169: MSC_TP_ID_LID mtil,
1170: MSC_TP_SITE_ID_LID mtsila,
1171: MSC_TP_SITE_ID_LID mtsilb
1172: WHERE msd.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
1173: and msd.designator_type = 6

Line 1662: msc_tp_id_lid c1,

1658: msd.LATEST_ACCEPTABLE_DATE,
1659: msd.SHIPPING_METHOD_CODE,
1660: mtsil.location_id ship_to_location_id
1661: FROM
1662: msc_tp_id_lid c1,
1663: MSC_ITEM_ID_LID t1,
1664: MSC_ITEM_ID_LID t2,
1665: MSC_DESIGNATORS md,
1666: MSC_TP_SITE_ID_LID mtsil,

Line 2613: MSC_TP_ID_LID mtil,

2609: FROM MSC_ITEM_ID_LID t1,
2610: MSC_ITEM_ID_LID t2,
2611: MSC_ITEM_ID_LID t3,
2612: MSC_ST_SALES_ORDERS so,
2613: MSC_TP_ID_LID mtil,
2614: MSC_TP_SITE_ID_LID mtsila,
2615: MSC_TP_SITE_ID_LID mtsilb
2616: WHERE t1.SR_INVENTORY_ITEM_ID= so.INVENTORY_ITEM_ID
2617: AND t1.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id||'