VIEW: AR.JG_ZZ_AR_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, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, POSTED_TO_GL_FLAG POSTED_TO_GL_FLAG, CREATED_BY CREATED_BY, DATE_CREATED DATE_CREATED, CONTRA_HEADER_ID CONTRA_HEADER_ID, ACCOUNT_CLASS ACCOUNT_CLASS, TRANSACTION_ID TRANSACTION_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, PURCHASE_ORDER PURCHASE_ORDER, AGREEMENT_NAME AGREEMENT_NAME from "AR"."JG_ZZ_AR_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
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, POSTED_TO_GL_FLAG POSTED_TO_GL_FLAG
, CREATED_BY CREATED_BY
, DATE_CREATED DATE_CREATED
, CONTRA_HEADER_ID CONTRA_HEADER_ID
, ACCOUNT_CLASS ACCOUNT_CLASS
, TRANSACTION_ID TRANSACTION_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
, PURCHASE_ORDER PURCHASE_ORDER
, AGREEMENT_NAME AGREEMENT_NAME
FROM "AR"."JG_ZZ_AR_TMP_DETAIL"