View: OKL_TXL_AR_INV_LNS_V

Product:	OKL - Lease and Finance Management
Description:	Transaction lines to be included into Receivables invoices
Implementation/DBA Data:	APPS.OKL_TXL_AR_INV_LNS_V

View Text

SELECT TILB.ROWID ROW_ID
, TILB.ID ID
, TILB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TILT.SFWT_FLAG SFWT_FLAG
, TILB.KLE_ID KLE_ID
, TILB.TPL_ID TPL_ID
, TILB.IBT_ID IBT_ID
, TILB.ISL_ID ISL_ID
, TILB.TIL_ID_REVERSES TIL_ID_REVERSES
, TILB.INV_RECEIV_LINE_CODE INV_RECEIV_LINE_CODE
, TILB.STY_ID STY_ID
, TILB.TAI_ID TAI_ID
, TILB.CLL_ID CLL_ID
, TILB.ACN_ID_COST ACN_ID_COST
, TILB.AMOUNT AMOUNT
, TILB.LINE_NUMBER LINE_NUMBER
, TILB.QUANTITY QUANTITY
, TILT.DESCRIPTION DESCRIPTION
, TILT. ERROR_MESSAGE ERROR_MESSAGE
, TILB.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID
, TILB.LATE_CHARGE_REC_ID LATE_CHARGE_REC_ID
, TILB.AMOUNT_APPLIED AMOUNT_APPLIED
, TILB.DATE_BILL_PERIOD_START DATE_BILL_PERIOD_START
, TILB.DATE_BILL_PERIOD_END DATE_BILL_PERIOD_END
, TILB.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TILB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TILB.ATTRIBUTE1 ATTRIBUTE1
, TILB.ATTRIBUTE2 ATTRIBUTE2
, TILB.ATTRIBUTE3 ATTRIBUTE3
, TILB.ATTRIBUTE4 ATTRIBUTE4
, TILB.ATTRIBUTE5 ATTRIBUTE5
, TILB.ATTRIBUTE6 ATTRIBUTE6
, TILB.ATTRIBUTE7 ATTRIBUTE7
, TILB.ATTRIBUTE8 ATTRIBUTE8
, TILB.ATTRIBUTE9 ATTRIBUTE9
, TILB.ATTRIBUTE10 ATTRIBUTE10
, TILB.ATTRIBUTE11 ATTRIBUTE11
, TILB.ATTRIBUTE12 ATTRIBUTE12
, TILB.ATTRIBUTE13 ATTRIBUTE13
, TILB.ATTRIBUTE14 ATTRIBUTE14
, TILB.ATTRIBUTE15 ATTRIBUTE15
, TILB.REQUEST_ID REQUEST_ID
, TILB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TILB.PROGRAM_ID PROGRAM_ID
, TILB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TILB.ORG_ID ORG_ID
, TILB.INVENTORY_ORG_ID INVENTORY_ORG_ID
, TILB.CREATED_BY CREATED_BY
, TILB.CREATION_DATE CREATION_DATE
, TILB.LAST_UPDATED_BY LAST_UPDATED_BY
, TILB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TILB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TILB.QTE_LINE_ID QTE_LINE_ID
, TILB.TXS_TRX_ID TXS_TRX_ID
, TILB.BANK_ACCT_ID BANK_ACCT_ID
, TILB.TXL_AR_LINE_NUMBER
, TILB.TXS_TRX_LINE_ID
, TILB.UPGRADE_FROM_TWO_LEVEL_YN
FROM OKL_TXL_AR_INV_LNS_B TILB
, OKL_TXL_AR_INV_LNS_TL TILT
WHERE TILB.ID = TILT.ID
AND TILT.LANGUAGE = USERENV('LANG')

Columns