DBA Data[Home] [Help]

APPS.RCI_ORG_CERT_ETL_PKG dependencies on ENG_ENGINEERING_CHANGES

Line 297: from eng_engineering_changes eec

293: (select pk1_value from eng_change_subjects ecs where ecs.entity_name='CERTIFICATION' and ecs.change_id=eec.change_id) certification_id,
294: (select pk1_value from eng_change_subjects ecs where ecs.entity_name='ORGANIZATION' and ecs.change_id=eec.change_id) as organization_id,
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,