Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_TXL_AP_INV_LNS_UV |
SELECT TPLB.ROWID ROW_ID
, TPLB.ID ID
, TPLB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TPLT.SFWT_FLAG SFWT_FLAG
, TPLB.CODE_COMBINATION_ID CODE_COMBINATION_ID
, TPLB.ITC_ID ITC_ID
, TPLB.DISBURSEMENT_BASIS_CODE DISBURSEMENT_BASIS_CODE
, TPLB.KLE_ID KLE_ID
, TPLB.LSM_ID LSM_ID
, TPLB.TPL_ID_REVERSES TPL_ID_REVERSES
, TPLB.INV_DISTR_LINE_CODE INV_DISTR_LINE_CODE
, TPLB.STY_ID STY_ID
, TPLB.TAP_ID TAP_ID
, TPLB.DATE_ACCOUNTING DATE_ACCOUNTING
, TPLB.AMOUNT AMOUNT
, TPLB.LINE_NUMBER LINE_NUMBER
, TPLB.PAYABLES_INVOICE_ID PAYABLES_INVOICE_ID
, TPLT.DESCRIPTION DESCRIPTION
, TPLB.FUNDING_REFERENCE_TYPE_CODE FUNDING_REFERENCE_TYPE_CODE
, TPLB.FUNDING_REFERENCE_NUMBER FUNDING_REFERENCE_NUMBER
, TPLB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TPLB.ATTRIBUTE1 ATTRIBUTE1
, TPLB.ATTRIBUTE2 ATTRIBUTE2
, TPLB.ATTRIBUTE3 ATTRIBUTE3
, TPLB.ATTRIBUTE4 ATTRIBUTE4
, TPLB.ATTRIBUTE5 ATTRIBUTE5
, TPLB.ATTRIBUTE6 ATTRIBUTE6
, TPLB.ATTRIBUTE7 ATTRIBUTE7
, TPLB.ATTRIBUTE8 ATTRIBUTE8
, TPLB.ATTRIBUTE9 ATTRIBUTE9
, TPLB.ATTRIBUTE10 ATTRIBUTE10
, TPLB.ATTRIBUTE11 ATTRIBUTE11
, TPLB.ATTRIBUTE12 ATTRIBUTE12
, TPLB.ATTRIBUTE13 ATTRIBUTE13
, TPLB.ATTRIBUTE14 ATTRIBUTE14
, TPLB.ATTRIBUTE15 ATTRIBUTE15
, TPLB.REQUEST_ID REQUEST_ID
, TPLB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TPLB.PROGRAM_ID PROGRAM_ID
, TPLB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TPLB.ORG_ID ORG_ID
, TPLB.CREATED_BY CREATED_BY
, TPLB.CREATION_DATE CREATION_DATE
, TPLB.LAST_UPDATED_BY LAST_UPDATED_BY
, TPLB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TPLB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'ITEM' LINE_TYPE
, 'PRE-FUNDING' FUNDING_REFERENCE_TYPE
, KLE.LINE_NUMBER CONTRACT_LINE_NUMBER
FROM OKL_TXL_AP_INV_LNS_B TPLB
, OKL_TXL_AP_INV_LNS_TL TPLT
, OKC_K_LINES_B KLE
WHERE TPLB.ID = TPLT.ID
AND TPLT.LANGUAGE = USERENV('LANG')
AND TPLB.KLE_ID = KLE.ID(+)