APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_TP_SITE_ID_LID

Line 1108: MSC_TP_SITE_ID_LID mtsila,

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

Line 1109: MSC_TP_SITE_ID_LID mtsilb

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

Line 1397: MSC_TP_SITE_ID_LID mtsil,

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,
1398: MSC_ST_DEMANDS msd
1399: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
1400: AND t1.sr_instance_id= msd.sr_instance_id
1401: AND t2.SR_INVENTORY_ITEM_ID= msd.using_assembly_item_id

Line 2305: MSC_TP_SITE_ID_LID mtsila,

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

Line 2306: MSC_TP_SITE_ID_LID mtsilb

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