DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCHES_PKG dependencies on ENG_LIFECYCLE_STATUSES

Line 514: eng_lifecycle_statuses els,

510: Cursor Change_Order_Notice_Csr(v_change_mgmt_type_code IN VARCHAR2, v_change_notice IN VARCHAR2, v_master_org_id IN NUMBER) IS
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