APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_ST_DEPT_RES_INSTANCES

Line 2684: FROM MSC_ST_DEPT_RES_INSTANCES msdri,

2680: msdri.EFFECTIVE_START_DATE,
2681: msdri.EFFECTIVE_END_DATE,
2682: msdri.LAST_KNOWN_SETUP,
2683: msdri.DELETED_FLAG
2684: FROM MSC_ST_DEPT_RES_INSTANCES msdri,
2685: MSC_ITEM_ID_LID t1
2686: WHERE msdri.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2687: AND t1.sr_instance_id (+) = msdri.sr_instance_id
2688: AND t1.sr_inventory_item_id (+) = msdri.equipment_item_id;