APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_TP_ID_LID

Line 232: MSC_TP_ID_LID mtil,

228: mssa.SR_INSTANCE_ID,
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,

Line 305: FROM MSC_TP_ID_LID mtil,

301: mssso.RANK,
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

Line 445: MSC_TP_ID_LID mtil

441: mscs.MODE_OF_TRANSPORT,
442: mscs.SR_INSTANCE_ID,
443: mscs.REFRESH_ID
444: FROM MSC_ST_CARRIER_SERVICES mscs,
445: MSC_TP_ID_LID mtil
446: WHERE mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
447: AND mtil.SR_TP_ID = mscs.CARRIER_ID
448: AND mtil.SR_Instance_ID = mscs.SR_INSTANCE_ID
449: AND mtil.Partner_Type = 4;

Line 911: MSC_TP_ID_LID mtil,

907: MSC_CL_COLLECTION.v_current_user,
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,