DBA Data[Home] [Help]

APPS.RCI_ORG_CERT_ETL_PKG dependencies on ENG_CHANGE_ORDER_TYPES

Line 299: from eng_change_order_types

295: (select pk1_value from eng_change_subjects ecs where ecs.entity_name='PROCESS' and ecs.change_id=eec.change_id) as process_id,
296: decode(status_code, 0, 0, 11, 0, 1) as open
297: from eng_engineering_changes eec
298: where change_order_type_id in (select change_order_type_id
299: from eng_change_order_types
300: where type_classification='HEADER'
301: and change_mgmt_type_code='AMW_PROC_CERT_ISSUES')) open_issues,
302: amw_audit_units_v aauv,
303: amw_certification_vl acv