APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_ST_DEPT_RES_INSTANCES

Line 2665: FROM MSC_ST_DEPT_RES_INSTANCES msdri,

2661: msdri.EFFECTIVE_START_DATE,
2662: msdri.EFFECTIVE_END_DATE,
2663: msdri.LAST_KNOWN_SETUP,
2664: msdri.DELETED_FLAG
2665: FROM MSC_ST_DEPT_RES_INSTANCES msdri,
2666: MSC_ITEM_ID_LID t1
2667: WHERE msdri.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2668: AND t1.sr_instance_id (+) = msdri.sr_instance_id
2669: AND t1.sr_inventory_item_id (+) = msdri.equipment_item_id;