Product: | OKL - Lease and Finance Management |
---|---|
Description: | Collection of all OKL transaction which generate Receivables invoices |
Implementation/DBA Data: | APPS.OKL_TRX_AR_INVOICES_V |
SELECT TAIB.ROWID ROW_ID
, TAIB.ID ID
, TAIB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TAIT.SFWT_FLAG SFWT_FLAG
, TAIB.TRX_STATUS_CODE TRX_STATUS_CODE
, TAIB.TRX_NUMBER TRX_NUMBER
, TAIB.CURRENCY_CODE CURRENCY_CODE
, TAIB.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, TAIB.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, TAIB.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, TAIB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TAIB.TRY_ID TRY_ID
, TAIB.KHR_ID KHR_ID
, TAIB.CRA_ID CRA_ID
, TAIB.POX_ID POX_ID
, TAIB.TAP_ID TAP_ID
, TAIB.QTE_ID QTE_ID
, TAIB.TCN_ID TCN_ID
, TAIB.CPY_ID CPY_ID
, TAIB.TAI_ID_REVERSES TAI_ID_REVERSES
, TAIB.IBT_ID IBT_ID
, TAIB.IXX_ID IXX_ID
, TAIB.IRM_ID IRM_ID
, TAIB.IRT_ID IRT_ID
, TAIB.SVF_ID SVF_ID
, TAIB.IPY_ID IPY_ID
, TAIB.AMOUNT AMOUNT
, TAIB.CLG_ID
, TAIB.DATE_INVOICED DATE_INVOICED
, TAIB.AMOUNT_APPLIED AMOUNT_APPLIED
, TAIT.DESCRIPTION DESCRIPTION
, TAIB.SOURCE_TABLE SOURCE_TABLE
, TAIB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TAIB.ATTRIBUTE1 ATTRIBUTE1
, TAIB.ATTRIBUTE2 ATTRIBUTE2
, TAIB.ATTRIBUTE3 ATTRIBUTE3
, TAIB.ATTRIBUTE4 ATTRIBUTE4
, TAIB.ATTRIBUTE5 ATTRIBUTE5
, TAIB.ATTRIBUTE6 ATTRIBUTE6
, TAIB.ATTRIBUTE7 ATTRIBUTE7
, TAIB.ATTRIBUTE8 ATTRIBUTE8
, TAIB.ATTRIBUTE9 ATTRIBUTE9
, TAIB.ATTRIBUTE10 ATTRIBUTE10
, TAIB.ATTRIBUTE11 ATTRIBUTE11
, TAIB.ATTRIBUTE12 ATTRIBUTE12
, TAIB.ATTRIBUTE13 ATTRIBUTE13
, TAIB.ATTRIBUTE14 ATTRIBUTE14
, TAIB.ATTRIBUTE15 ATTRIBUTE15
, TAIB.DATE_ENTERED DATE_ENTERED
, TAIB.REQUEST_ID REQUEST_ID
, TAIB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TAIB.PROGRAM_ID PROGRAM_ID
, TAIB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TAIB.ORG_ID ORG_ID
, TAIB.CREATED_BY CREATED_BY
, TAIB.CREATION_DATE CREATION_DATE
, TAIB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAIB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAIB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAIB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, TAIB.INF_ID
, TAIB.INVOICE_PULL_YN
, TAIB.DUE_DATE
, TAIB.ISI_ID
, TAIB.RECEIVABLES_INVOICE_ID
, TAIB.CUST_TRX_TYPE_ID
, TAIB.CUSTOMER_BANK_ACCOUNT_ID
, TAIB.TAX_EXEMPT_FLAG
, TAIB.TAX_EXEMPT_REASON_CODE
, TAIB.REFERENCE_LINE_ID
, TAIB.PRIVATE_LABEL
, TAIB.CONSOLIDATED_INVOICE_NUMBER
, TAIB.OKL_SOURCE_BILLING_TRX
, TAIB.INVESTOR_AGREEMENT_NUMBER
, TAIB.INVESTOR_NAME
, TAIB.TRANSACTION_DATE
FROM OKL_TRX_AR_INVOICES_B TAIB
, OKL_TRX_AR_INVOICES_TL TAIT
WHERE TAIB.ID = TAIT.ID
AND TAIT.LANGUAGE = USERENV('LANG')