APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_TP_SITE_ID_LID

Line 1170: MSC_TP_SITE_ID_LID mtsila,

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
1174: and mtil.sr_instance_id(+) = MSC_CL_COLLECTION.v_instance_id

Line 1171: MSC_TP_SITE_ID_LID mtsilb

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
1174: and mtil.sr_instance_id(+) = MSC_CL_COLLECTION.v_instance_id
1175: and mtil.sr_tp_id(+) = msd.customer_id

Line 1666: MSC_TP_SITE_ID_LID mtsil,

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,
1667: MSC_ST_DEMANDS msd
1668: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
1669: AND t1.sr_instance_id= msd.sr_instance_id
1670: AND t2.SR_INVENTORY_ITEM_ID= msd.using_assembly_item_id

Line 2614: MSC_TP_SITE_ID_LID mtsila,

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||'
2618: AND so.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id||'

Line 2615: MSC_TP_SITE_ID_LID mtsilb

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||'
2618: AND so.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id||'
2619: AND so.ROW_TYPE= xxx_ROW_TYPE