Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_TRX_AR_INVOICES_UV |
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.CURRENCY_CODE CURRENCY_CODE
, 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.TAP_ID TAP_ID
, TAIB.QTE_ID QTE_ID
, TAIB.TCN_ID TCN_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
, OKL_ACCOUNTING_UTIL.FORMAT_AMOUNT(TAIB.AMOUNT
, TAIB.CURRENCY_CODE) AMOUNT
, TAIB.DATE_INVOICED DATE_INVOICED
, OKL_ACCOUNTING_UTIL.FORMAT_AMOUNT(TAIB.AMOUNT_APPLIED
, TAIB.CURRENCY_CODE) AMOUNT_APPLIED
, TAIT.DESCRIPTION DESCRIPTION
, 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
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_STATUS'
, TAIB.TRX_STATUS_CODE) TRANSACTION_STATUS
, OKHB.CONTRACT_NUMBER CONTRACT_NUMBER
, TRYT.NAME TRANSCATION_TYPE
, ROWNUM INVOICE_NUMBER
FROM OKL_TRX_AR_INVOICES_B TAIB
, OKL_TRX_AR_INVOICES_TL TAIT
, OKC_K_HEADERS_B OKHB
, OKL_TRX_TYPES_TL TRYT
WHERE TAIB.ID = TAIT.ID
AND TAIT.LANGUAGE = USERENV('LANG')
AND OKHB.ID = TAIB.KHR_ID
AND TAIB.TRY_ID = TRYT.ID(+)
AND NVL(TRYT.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')