DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCHES_PKG dependencies on ENG_CHANGE_STATUSES_VL

Line 515: eng_change_statuses_vl ecs

511: SELECT change_notice
512: FROM (SELECT DISTINCT eec.change_notice, eec.CHANGE_MGMT_TYPE_CODE
513: FROM eng_engineering_changes eec,
514: eng_lifecycle_statuses els,
515: eng_change_statuses_vl ecs
516: WHERE els.entity_name(+) = 'ENG_CHANGE'
517: AND els.entity_id1(+) = eec.change_id
518: AND els.status_code(+) = eec.status_code
519: AND els.active_flag(+) = 'Y'