VIEW: AP.JG_ZZ_AP_TMP_DETAIL#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ACCOUNTING_DATE ACCOUNTING_DATE, SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID, SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE, CURRENCY_CODE CURRENCY_CODE, CODE_COMBINATION_ID CODE_COMBINATION_ID, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, TRANS_TYPE TRANS_TYPE, TRANS_NUMBER TRANS_NUMBER, TRANS_DESCRIPTION TRANS_DESCRIPTION, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, POSTED_TO_GL_FLAG POSTED_TO_GL_FLAG, CREATED_BY CREATED_BY, DATE_CREATED DATE_CREATED, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID, ACCT_FLEX_FIELD ACCT_FLEX_FIELD, ACCT_FLEX_DESC ACCT_FLEX_DESC, BALANCE BALANCE, BALANCE_DESC BALANCE_DESC, ACCOUNT ACCOUNT, ACCOUNT_DESC ACCOUNT_DESC from "AP"."JG_ZZ_AP_TMP_DETAIL"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ACCOUNTING_DATE ACCOUNTING_DATE
, SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID
, SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE
, CURRENCY_CODE CURRENCY_CODE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, TRANS_TYPE TRANS_TYPE
, TRANS_NUMBER TRANS_NUMBER
, TRANS_DESCRIPTION TRANS_DESCRIPTION
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, POSTED_TO_GL_FLAG POSTED_TO_GL_FLAG
, CREATED_BY CREATED_BY
, DATE_CREATED DATE_CREATED
, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID
, ACCT_FLEX_FIELD ACCT_FLEX_FIELD
, ACCT_FLEX_DESC ACCT_FLEX_DESC
, BALANCE BALANCE
, BALANCE_DESC BALANCE_DESC
, ACCOUNT ACCOUNT
, ACCOUNT_DESC ACCOUNT_DESC
FROM "AP"."JG_ZZ_AP_TMP_DETAIL"