PO_XLA_HEADERS_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name
PO_HEADER_ID PO_VERSION_ID DOCUMENT_NUMBER EVENT_ID BUDGET_DATE

Query

SQL_Statement

SELECT PO_BCEA_DATA.PO_HEADER_ID PO_HEADER_ID, decode(PO_BCEA_DATA.reservation_backout_flag,'Y', -1 ,1) * PO_BCEA_DATA.PO_VERSION_ID PO_VERSION_ID, PO_BCEA_DATA.DOCUMENT_NUMBER DOCUMENT_NUMBER, PO_BCEA_DATA.EVENT_ID EVENT_ID, PO_BCEA_DATA.BUDGET_DATE BUDGET_DATE FROM PO_BCEA_DATA GROUP BY PO_BCEA_DATA.PO_HEADER_ID , PO_BCEA_DATA.PO_VERSION_ID , PO_BCEA_DATA.DOCUMENT_NUMBER , PO_BCEA_DATA.EVENT_ID , PO_BCEA_DATA.BUDGET_DATE,PO_BCEA_DATA.reservation_backout_flag