APPS.MSC_CL_EAM_ODS_LOAD dependencies on MSC_ST_EAM_ASSET_EQUIP_DTLS

Line 25: FROM MSC_ST_EAM_ASSET_EQUIP_DTLS mseaa

21: mseaa.ORGANIZATION_ID,
22: mseaa.ASSET_ACTIVITY_ID,
23: mseaa.EQUIPMENT_ITEM_ID,
24: mseaa.SR_INSTANCE_ID
25: FROM MSC_ST_EAM_ASSET_EQUIP_DTLS mseaa
26: WHERE mseaa.deleted_flag = MSC_UTIL.SYS_YES
27: AND mseaa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
28: lv_errbuf VARCHAR2(240);
29: lv_retcode NUMBER;

Line 419: ||' FROM MSC_ST_EAM_ASSET_EQUIP_DTLS mse,'

415: ||' mse.DEPARTMENT_ID,'
416: ||' mse.RESOURCE_CODE,'
417: ||' mse.SCHEDULE_TO_INSTANCE,'
418: ||' mse.SR_INSTANCE_ID'
419: ||' FROM MSC_ST_EAM_ASSET_EQUIP_DTLS mse,'
420: ||' MSC_ITEM_ID_LID m1,'
421: ||' MSC_ITEM_ID_LID m2,'
422: ||' MSC_ITEM_ID_LID m3'
423: ||' WHERE mse.SR_INSTANCE_ID= '

Line 512: ||' FROM MSC_ST_EAM_ASSET_EQUIP_DTLS mse,'

508: ||' :v_current_date, '
509: ||' :v_current_user, '
510: ||' :v_current_date, '
511: ||' :v_current_user '
512: ||' FROM MSC_ST_EAM_ASSET_EQUIP_DTLS mse,'
513: ||' MSC_ITEM_ID_LID m1,'
514: ||' MSC_ITEM_ID_LID m2,'
515: ||' MSC_ITEM_ID_LID m3'
516: ||' WHERE mse.SR_INSTANCE_ID= '