VIEW: GL.GL_JOURNAL_REPORTS_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, BATCH_ID BATCH_ID, HEADER_ID HEADER_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, JE_LINE_NUM JE_LINE_NUM, ORGANIZATION_NAME ORGANIZATION_NAME, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, BATCH_STATUS BATCH_STATUS, BATCH_TYPE BATCH_TYPE, BATCH_JOURNAL_TYPE BATCH_JOURNAL_TYPE, BATCH_APPROVAL_STATUS BATCH_APPROVAL_STATUS, BATCH_BUDGET_CONTROL_STATUS BATCH_BUDGET_CONTROL_STATUS, EXCHANGE_TYPE EXCHANGE_TYPE, DOC_SEQUENCE_NAME DOC_SEQUENCE_NAME, TAX_STATUS TAX_STATUS, HEADER_ENCUMBRANCE_TYPE HEADER_ENCUMBRANCE_TYPE, HEADER_BUDGET_NAME HEADER_BUDGET_NAME, SUBLEDGER_DOC_SEQ_NAME SUBLEDGER_DOC_SEQ_NAME, TAX_CODE TAX_CODE, TAX_TYPE TAX_TYPE, JE_ACCOUNT JE_ACCOUNT, JE_ACCOUNT_DESC JE_ACCOUNT_DESC, JE_BALANCE JE_BALANCE, JE_BALANCE_DESC JE_BALANCE_DESC, JE_NATACCT JE_NATACCT, JE_NATACCT_DESC JE_NATACCT_DESC, JE_CC JE_CC, JE_CC_DESC JE_CC_DESC, JE_SECONDARY_SEG JE_SECONDARY_SEG, JE_SECONDARY_DESC JE_SECONDARY_DESC, JE_CONTRA_ACCT JE_CONTRA_ACCT, JE_CONTRA_ACCT_DESC JE_CONTRA_ACCT_DESC from "GL"."GL_JOURNAL_REPORTS_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, BATCH_ID BATCH_ID
, HEADER_ID HEADER_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JE_LINE_NUM JE_LINE_NUM
, ORGANIZATION_NAME ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, BATCH_STATUS BATCH_STATUS
, BATCH_TYPE BATCH_TYPE
, BATCH_JOURNAL_TYPE BATCH_JOURNAL_TYPE
, BATCH_APPROVAL_STATUS BATCH_APPROVAL_STATUS
, BATCH_BUDGET_CONTROL_STATUS BATCH_BUDGET_CONTROL_STATUS
, EXCHANGE_TYPE EXCHANGE_TYPE
, DOC_SEQUENCE_NAME DOC_SEQUENCE_NAME
, TAX_STATUS TAX_STATUS
, HEADER_ENCUMBRANCE_TYPE HEADER_ENCUMBRANCE_TYPE
, HEADER_BUDGET_NAME HEADER_BUDGET_NAME
, SUBLEDGER_DOC_SEQ_NAME SUBLEDGER_DOC_SEQ_NAME
, TAX_CODE TAX_CODE
, TAX_TYPE TAX_TYPE
, JE_ACCOUNT JE_ACCOUNT
, JE_ACCOUNT_DESC JE_ACCOUNT_DESC
, JE_BALANCE JE_BALANCE
, JE_BALANCE_DESC JE_BALANCE_DESC
, JE_NATACCT JE_NATACCT
, JE_NATACCT_DESC JE_NATACCT_DESC
, JE_CC JE_CC
, JE_CC_DESC JE_CC_DESC
, JE_SECONDARY_SEG JE_SECONDARY_SEG
, JE_SECONDARY_DESC JE_SECONDARY_DESC
, JE_CONTRA_ACCT JE_CONTRA_ACCT
, JE_CONTRA_ACCT_DESC JE_CONTRA_ACCT_DESC
FROM "GL"."GL_JOURNAL_REPORTS_ITF"