APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_ITEM_ID_LID

Line 19: FROM MSC_ITEM_ID_LID t1,

15: msss.PROJECT_ID,
16: msss.TASK_ID,
17: msss.PLANNING_GROUP,
18: msss.SR_INSTANCE_ID
19: FROM MSC_ITEM_ID_LID t1,
20: MSC_ST_SAFETY_STOCKS msss
21: WHERE t1.SR_INVENTORY_ITEM_ID= msss.inventory_item_id
22: AND t1.sr_instance_id= msss.sr_instance_id
23: AND msss.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line 231: FROM MSC_ITEM_ID_LID miil,

227: mssa.ORGANIZATION_ID,
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,

Line 257: select 1 from msc_item_id_lid miil1

253: AND
254: (
255: EXISTS
256: (
257: select 1 from msc_item_id_lid miil1
258: where miil1.SR_INVENTORY_ITEM_ID=mssa.INVENTORY_ITEM_ID AND
259: miil1.SR_INSTANCE_ID=mssa.SR_ASSIGNMENT_INSTANCE_ID AND
260: mssa.assignment_type in (3,6)
261: )

Line 910: FROM MSC_ITEM_ID_LID miil,

906: MSC_CL_COLLECTION.v_current_date,
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,

Line 936: select 1 from msc_item_id_lid miil1

932: AND
933: (
934: EXISTS
935: (
936: select 1 from msc_item_id_lid miil1
937: where miil1.SR_INVENTORY_ITEM_ID=mssa.INVENTORY_ITEM_ID AND
938: miil1.SR_INSTANCE_ID=mssa.SR_ASSIGNMENT_INSTANCE_ID AND
939: mssa.assignment_type in (3,6)
940: )

Line 2110: FROM MSC_ITEM_ID_LID t1,

2106: t1.INVENTORY_ITEM_ID END_ITEM_ID,
2107: msun.MASTER_ORGANIZATION_ID,
2108: msun.COMMENTS,
2109: msun.SR_INSTANCE_ID
2110: FROM MSC_ITEM_ID_LID t1,
2111: MSC_ST_Unit_Numbers msun
2112: WHERE t1.SR_INVENTORY_ITEM_ID= msun.end_item_id
2113: AND t1.sr_instance_id= msun.sr_instance_id
2114: AND msun.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;