EGO_RELEASED_CO_LIST_V

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
CHANGE_NOTICE_LIST CHANGE_LIST STATUS_LIST ORGANIZATION_ID PK1_VALUE

Query

SQL_Statement

SELECT RTRIM( XMLAGG(xmlelement( e, change_notice, ',' ).extract('//text()') ORDER BY co.change_id ).getclobval(), ',' ) change_notice_list, RTRIM( XMLAGG(xmlelement( e, co.change_id, ',' ).extract('//text()') ORDER BY co.change_id ).getclobval(), ',' ) change_list , RTRIM( XMLAGG(xmlelement( e, linestatus.meaning, ',' ).extract('//text()') ORDER BY co.change_id ).getclobval(), ',' ) status_list, coline.organization_id, coline.pk1_value FROM (SELECT * FROM EGO_CHANGE_LINES_B b WHERE EXISTS (SELECT 1 FROM ACA_STRUCTURE_EXPL_STAGING a WHERE a.component_item_org_id = b.organization_id AND a.component_item_id = b.pk1_value ) ) coline, EGO_ENGINEERING_CHANGES_B co, FND_LOOKUP_VALUES_TL linestatus WHERE coline.change_id = co.change_id AND coline.status_code = linestatus.lookup_code AND lookup_type = 'EGO_LINE_ITEM_STATUSES' AND language = USERENV('LANG') AND linestatus.meaning = 'Completed' GROUP BY coline.organization_id, coline.pk1_value ORDER BY coline.organization_id, coline.pk1_value