Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_TXL_AR_INV_LNS_UV |
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.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.ACN_ID_COST ACN_ID_COST
, TILB.AMOUNT AMOUNT
, TILB.LINE_NUMBER LINE_NUMBER
, TILB.QUANTITY QUANTITY
, TILT.DESCRIPTION DESCRIPTION
, TILB.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_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.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.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
, 'ITEM' LINE_TYPE
, KLE.LINE_NUMBER CONTRACT_LINE_NUMBER
FROM OKL_TXL_AR_INV_LNS_B TILB
, OKL_TXL_AR_INV_LNS_TL TILT
, OKC_K_LINES_B KLE
WHERE TILB.ID = TILT.ID
AND TILT.LANGUAGE = USERENV('LANG')
AND TILB.KLE_ID = KLE.ID(+)