APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_TP_SITE_ID_LID

Line 233: MSC_TP_SITE_ID_LID mtsil,

229: mssa.CATEGORY_NAME,
230: mssa.SR_ASSIGNMENT_INSTANCE_ID
231: FROM MSC_ITEM_ID_LID miil,
232: MSC_TP_ID_LID mtil,
233: MSC_TP_SITE_ID_LID mtsil,
234: MSC_CATEGORY_SET_ID_LID mcsil,
235: MSC_Assignment_SETS mas,
236: MSC_Sourcing_Rules msr,
237: MSC_ST_SR_ASSIGNMENTS mssa

Line 306: MSC_TP_SITE_ID_LID mtsil,

302: mssso.SR_INSTANCE_ID,
303: mssso.SHIP_METHOD,
304: mssso.SOURCE_TYPE
305: FROM MSC_TP_ID_LID mtil,
306: MSC_TP_SITE_ID_LID mtsil,
307: MSC_SR_Receipt_Org msro,
308: MSC_ST_SR_SOURCE_ORG mssso
309: WHERE msro.SR_SR_RECEIPT_ID= mssso.SR_RECEIPT_ID
310: AND msro.SR_Instance_ID= mssso.SR_Instance_ID

Line 430: MSC_TP_SITE_ID_LID mtsil

426: msrs.ZONE_LEVEL,
427: msrs.SR_INSTANCE_ID,
428: msrs.REFRESH_ID
429: FROM MSC_ST_REGION_SITES msrs,
430: MSC_TP_SITE_ID_LID mtsil
431: WHERE msrs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
432: AND mtsil.SR_TP_SITE_ID = msrs.VENDOR_SITE_ID
433: AND mtsil.SR_Instance_ID = msrs.SR_INSTANCE_ID
434: AND mtsil.Partner_Type = 1;

Line 912: MSC_TP_SITE_ID_LID mtsil,

908: MSC_CL_COLLECTION.v_current_date,
909: MSC_CL_COLLECTION.v_current_user
910: FROM MSC_ITEM_ID_LID miil,
911: MSC_TP_ID_LID mtil,
912: MSC_TP_SITE_ID_LID mtsil,
913: MSC_CATEGORY_SET_ID_LID mcsil,
914: MSC_Assignment_SETS mas,
915: MSC_Sourcing_Rules msr,
916: MSC_ST_SR_ASSIGNMENTS mssa

Line 1824: ||' MSC_TP_SITE_ID_LID mtsil '

1820: ||' :v_current_user, '
1821: ||' :v_current_date, '
1822: ||' :v_current_user '
1823: ||' FROM MSC_ST_REGION_SITES msrs, '
1824: ||' MSC_TP_SITE_ID_LID mtsil '
1825: ||' WHERE msrs.SR_INSTANCE_ID= :v_instance_id '
1826: ||' AND mtsil.SR_TP_SITE_ID = msrs.VENDOR_SITE_ID '
1827: ||' AND mtsil.SR_Instance_ID = msrs.SR_INSTANCE_ID '
1828: ||' AND mtsil.Partner_Type = 1 '