View: OKL_TXL_AP_INV_LNS_V

Product:	OKL - Leasing and Finance Management
Description:	Transaction lines to be included into Payables invoices
Implementation/DBA Data:	APPS.OKL_TXL_AP_INV_LNS_V

View Text

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
, TPLB.ERROR_MESSAGE
, TPLB.SEL_ID SEL_ID
, TPLB.KHR_ID KHR_ID
, TPLB.TAXABLE_YN TAXABLE_YN
, TPLB.REF_LINE_NUMBER REF_LINE_NUMBER
, TPLB.CNSLD_AP_INV_ID CNSLD_AP_INV_ID
, TPLB.CNSLD_LINE_NUMBER CNSLD_LINE_NUMBER
, TPLB.TLD_ID TLD_ID
FROM OKL_TXL_AP_INV_LNS_B TPLB
, OKL_TXL_AP_INV_LNS_TL TPLT
WHERE TPLB.ID = TPLT.ID
AND TPLT.LANGUAGE = USERENV('LANG')

Columns