VIEW: PN.PN_AE_HEADERS_ALL#

Source

View Text - Preformatted

select AE_HEADER_ID AE_HEADER_ID, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, AE_CATEGORY AE_CATEGORY, CROSS_CURRENCY_FLAG CROSS_CURRENCY_FLAG, PERIOD_NAME PERIOD_NAME, ACCOUNTING_DATE ACCOUNTING_DATE, GL_TRANSFER_FLAG GL_TRANSFER_FLAG, GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID, DESCRIPTION DESCRIPTION, ORG_ID ORG_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID, ACCOUNTING_ERROR_CODE ACCOUNTING_ERROR_CODE, GL_TRANSFER_ERROR_CODE GL_TRANSFER_ERROR_CODE, GL_REVERSAL_FLAG GL_REVERSAL_FLAG, TRIAL_BALANCE_FLAG TRIAL_BALANCE_FLAG from "PN"."PN_AE_HEADERS_ALL"

View Text - HTML Formatted

SELECT AE_HEADER_ID AE_HEADER_ID
, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AE_CATEGORY AE_CATEGORY
, CROSS_CURRENCY_FLAG CROSS_CURRENCY_FLAG
, PERIOD_NAME PERIOD_NAME
, ACCOUNTING_DATE ACCOUNTING_DATE
, GL_TRANSFER_FLAG GL_TRANSFER_FLAG
, GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID
, DESCRIPTION DESCRIPTION
, ORG_ID ORG_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
, ACCOUNTING_ERROR_CODE ACCOUNTING_ERROR_CODE
, GL_TRANSFER_ERROR_CODE GL_TRANSFER_ERROR_CODE
, GL_REVERSAL_FLAG GL_REVERSAL_FLAG
, TRIAL_BALANCE_FLAG TRIAL_BALANCE_FLAG
FROM "PN"."PN_AE_HEADERS_ALL"