View: AP_AE_HEADERS_V

View Text

SELECT AAH.ROWID ROW_ID
, AAH.AE_HEADER_ID
, AAH.ACCOUNTING_EVENT_ID
, AAH.SET_OF_BOOKS_ID
, ALC5.DISPLAYED_FIELD DOCUMENT_TYPE
, AAH.ACCOUNTING_DATE
, AAH.PERIOD_NAME ACCOUNTING_PERIOD
, AAH.GL_TRANSFER_FLAG GL_TRANSFER_FLAG
, ALC6.DISPLAYED_FIELD GL_TRANSFER_STATUS
, ALC3.DISPLAYED_FIELD GL_TRANSFER_ERROR_CODE
, AAH.DESCRIPTION
, ALC4.DISPLAYED_FIELD ACCOUNTING_ERROR_CODE
, AAH.ORG_ID
, AAH.CREATION_DATE
, AAH.CREATED_BY
, AAH.LAST_UPDATE_DATE
, AAH.LAST_UPDATED_BY
, AAH.LAST_UPDATE_LOGIN
, AAH.PROGRAM_UPDATE_DATE
, AAH.PROGRAM_APPLICATION_ID
, AAH.PROGRAM_ID
, AAH.REQUEST_ID
, ALC1.DISPLAYED_FIELD EVENT_TYPE
, ALC2.DISPLAYED_FIELD EVENT_STATUS
, AAE.EVENT_STATUS_CODE
, AAE.EVENT_NUMBER
, AAE.SOURCE_TABLE
, AAE.SOURCE_ID
, AI.INVOICE_NUM DOCUMENT_NUMBER
, GSOB.CURRENCY_CODE
, GSOB.NAME SET_OF_BOOKS_NAME
FROM AP_AE_HEADERS AAH
, AP_ACCOUNTING_EVENTS AAE
, AP_INVOICES AI
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, AP_LOOKUP_CODES ALC3
, AP_LOOKUP_CODES ALC4
, AP_LOOKUP_CODES ALC5
, AP_LOOKUP_CODES ALC6
, GL_SETS_OF_BOOKS GSOB
WHERE AAH.ACCOUNTING_EVENT_ID = AAE.ACCOUNTING_EVENT_ID
AND AAE.SOURCE_TABLE = 'AP_INVOICES'
AND AAE.SOURCE_ID = AI.INVOICE_ID
AND ALC1.LOOKUP_TYPE = 'EVENT TYPE'
AND ALC1.LOOKUP_CODE = AAE.EVENT_TYPE_CODE
AND ALC2.LOOKUP_TYPE = 'EVENT STATUS'
AND ALC2.LOOKUP_CODE = AAE.EVENT_STATUS_CODE
AND ALC3.LOOKUP_TYPE(+) = 'POSTING EXCEPTIONS'
AND ALC3.LOOKUP_CODE(+) = AAH.GL_TRANSFER_ERROR_CODE
AND ALC4.LOOKUP_TYPE(+) = 'ACCOUNTING ERROR TYPE'
AND ALC4.LOOKUP_CODE(+) = AAH.ACCOUNTING_ERROR_CODE
AND ALC5.LOOKUP_TYPE(+) = 'POSTING CATEGORY'
AND ALC5.LOOKUP_CODE(+) = DECODE(AAH.AE_CATEGORY
, 'PURCHASE INVOICES'
, 'INVOICES'
, 'PAYMENTS')
AND ALC6.LOOKUP_TYPE(+) = 'AWT_YES_NO'
AND ALC6.LOOKUP_CODE(+) = AAH.GL_TRANSFER_FLAG
AND GSOB.SET_OF_BOOKS_ID = AAH.SET_OF_BOOKS_ID UNION SELECT AAH.ROWID ROW_ID
, AAH.AE_HEADER_ID
, AAH.ACCOUNTING_EVENT_ID
, AAH.SET_OF_BOOKS_ID
, ALC5.DISPLAYED_FIELD DOCUMENT_TYPE
, AAH.ACCOUNTING_DATE
, AAH.PERIOD_NAME ACCOUNTING_PERIOD
, AAH.GL_TRANSFER_FLAG GL_TRANSFER_FLAG
, ALC6.DISPLAYED_FIELD GL_TRANSFER_STATUS
, ALC3.DISPLAYED_FIELD GL_TRANSFER_ERROR_CODE
, AAH.DESCRIPTION
, ALC4.DISPLAYED_FIELD ACCOUNTING_ERROR_CODE
, AAH.ORG_ID
, AAH.CREATION_DATE
, AAH.CREATED_BY
, AAH.LAST_UPDATE_DATE
, AAH.LAST_UPDATED_BY
, AAH.LAST_UPDATE_LOGIN
, AAH.PROGRAM_UPDATE_DATE
, AAH.PROGRAM_APPLICATION_ID
, AAH.PROGRAM_ID
, AAH.REQUEST_ID
, ALC1.DISPLAYED_FIELD EVENT_TYPE
, ALC2.DISPLAYED_FIELD EVENT_STATUS
, AAE.EVENT_STATUS_CODE
, AAE.EVENT_NUMBER
, AAE.SOURCE_TABLE
, AAE.SOURCE_ID
, TO_CHAR(AC.CHECK_NUMBER) DOCUMENT_NUMBER
, GSOB.CURRENCY_CODE
, GSOB.NAME SET_OF_BOOKS_NAME
FROM AP_AE_HEADERS AAH
, AP_ACCOUNTING_EVENTS AAE
, AP_CHECKS AC
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, AP_LOOKUP_CODES ALC3
, AP_LOOKUP_CODES ALC4
, AP_LOOKUP_CODES ALC5
, AP_LOOKUP_CODES ALC6
, GL_SETS_OF_BOOKS GSOB
WHERE AAH.ACCOUNTING_EVENT_ID = AAE.ACCOUNTING_EVENT_ID
AND AAE.SOURCE_TABLE = 'AP_CHECKS'
AND AAE.SOURCE_ID = AC.CHECK_ID
AND ALC1.LOOKUP_TYPE = 'EVENT TYPE'
AND ALC1.LOOKUP_CODE = AAE.EVENT_TYPE_CODE
AND ALC2.LOOKUP_TYPE = 'EVENT STATUS'
AND ALC2.LOOKUP_CODE = AAE.EVENT_STATUS_CODE
AND ALC3.LOOKUP_TYPE(+) = 'POSTING EXCEPTIONS'
AND ALC3.LOOKUP_CODE(+) = AAH.GL_TRANSFER_ERROR_CODE
AND ALC4.LOOKUP_TYPE(+) = 'ACCOUNTING ERROR TYPE'
AND ALC4.LOOKUP_CODE(+) = AAH.ACCOUNTING_ERROR_CODE
AND ALC5.LOOKUP_TYPE(+) = 'POSTING CATEGORY'
AND ALC5.LOOKUP_CODE(+) = DECODE(AAH.AE_CATEGORY
, 'PURCHASE INVOICES'
, 'INVOICES'
, 'PAYMENTS')
AND ALC6.LOOKUP_TYPE(+) = 'AWT_YES_NO'
AND ALC6.LOOKUP_CODE(+) = AAH.GL_TRANSFER_FLAG
AND GSOB.SET_OF_BOOKS_ID = AAH.SET_OF_BOOKS_ID

Columns