VIEW: OKL.OKL_TRX_AR_INVOICES_B#

Source

View Text - Preformatted

select ID ID, TRX_STATUS_CODE TRX_STATUS_CODE, CURRENCY_CODE CURRENCY_CODE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, TRY_ID TRY_ID, IBT_ID IBT_ID, IXX_ID IXX_ID, KHR_ID KHR_ID, IRM_ID IRM_ID, IRT_ID IRT_ID, CRA_ID CRA_ID, CLG_ID CLG_ID, SVF_ID SVF_ID, CPY_ID CPY_ID, TAP_ID TAP_ID, QTE_ID QTE_ID, TCN_ID TCN_ID, IPY_ID IPY_ID, TAI_ID_REVERSES TAI_ID_REVERSES, TRX_NUMBER TRX_NUMBER, DATE_ENTERED DATE_ENTERED, DATE_INVOICED DATE_INVOICED, AMOUNT AMOUNT, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AMOUNT_APPLIED AMOUNT_APPLIED, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORG_ID ORG_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, 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, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, POX_ID POX_ID, SOURCE_TABLE SOURCE_TABLE, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, INF_ID INF_ID, INVOICE_PULL_YN INVOICE_PULL_YN, DUE_DATE DUE_DATE, ISI_ID ISI_ID, RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, REFERENCE_LINE_ID REFERENCE_LINE_ID, PRIVATE_LABEL PRIVATE_LABEL, CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER, OKL_SOURCE_BILLING_TRX OKL_SOURCE_BILLING_TRX, INVESTOR_AGREEMENT_NUMBER INVESTOR_AGREEMENT_NUMBER, INVESTOR_NAME INVESTOR_NAME, TRANSACTION_DATE TRANSACTION_DATE from "OKL"."OKL_TRX_AR_INVOICES_B"

View Text - HTML Formatted

SELECT ID ID
, TRX_STATUS_CODE TRX_STATUS_CODE
, CURRENCY_CODE CURRENCY_CODE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TRY_ID TRY_ID
, IBT_ID IBT_ID
, IXX_ID IXX_ID
, KHR_ID KHR_ID
, IRM_ID IRM_ID
, IRT_ID IRT_ID
, CRA_ID CRA_ID
, CLG_ID CLG_ID
, SVF_ID SVF_ID
, CPY_ID CPY_ID
, TAP_ID TAP_ID
, QTE_ID QTE_ID
, TCN_ID TCN_ID
, IPY_ID IPY_ID
, TAI_ID_REVERSES TAI_ID_REVERSES
, TRX_NUMBER TRX_NUMBER
, DATE_ENTERED DATE_ENTERED
, DATE_INVOICED DATE_INVOICED
, AMOUNT AMOUNT
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AMOUNT_APPLIED AMOUNT_APPLIED
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORG_ID ORG_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, 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
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, POX_ID POX_ID
, SOURCE_TABLE SOURCE_TABLE
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, INF_ID INF_ID
, INVOICE_PULL_YN INVOICE_PULL_YN
, DUE_DATE DUE_DATE
, ISI_ID ISI_ID
, RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID
, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, REFERENCE_LINE_ID REFERENCE_LINE_ID
, PRIVATE_LABEL PRIVATE_LABEL
, CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER
, OKL_SOURCE_BILLING_TRX OKL_SOURCE_BILLING_TRX
, INVESTOR_AGREEMENT_NUMBER INVESTOR_AGREEMENT_NUMBER
, INVESTOR_NAME INVESTOR_NAME
, TRANSACTION_DATE TRANSACTION_DATE
FROM "OKL"."OKL_TRX_AR_INVOICES_B"