Product: | OKL - Leasing and Finance Management |
---|---|
Description: | Transaction line details to be included into Receivables invoices |
Implementation/DBA Data: | APPS.OKL_TXD_AR_LN_DTLS_V |
SELECT TLDB.ROWID ROW_ID
, TLDB.ID ID
, TLDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TLDT.SFWT_FLAG SFWT_FLAG
, TLDB.BCH_ID BCH_ID
, TLDB.BGH_ID BGH_ID
, TLDB.IDX_ID IDX_ID
, TLDB.TLD_ID_REVERSES TLD_ID_REVERSES
, TLDB.STY_ID STY_ID
, TLDB.SEL_ID SEL_ID
, TLDB.TIL_ID_DETAILS TIL_ID_DETAILS
, TLDB.BCL_ID BCL_ID
, TLDB.BSL_ID BSL_ID
, TLDB.AMOUNT AMOUNT
, TLDB.LINE_DETAIL_NUMBER LINE_DETAIL_NUMBER
, TLDB.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID
, TLDB.LATE_CHARGE_YN LATE_CHARGE_YN
, TLDT.DESCRIPTION DESCRIPTION
, TLDT.ERROR_MESSAGE ERROR_MESSAGE
, TLDB.AMOUNT_APPLIED AMOUNT_APPLIED
, TLDB.DATE_CALCULATION DATE_CALCULATION
, TLDB.FIXED_RATE_YN FIXED_RATE_YN
, TLDB.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TLDB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TLDB.ATTRIBUTE1 ATTRIBUTE1
, TLDB.ATTRIBUTE2 ATTRIBUTE2
, TLDB.ATTRIBUTE3 ATTRIBUTE3
, TLDB.ATTRIBUTE4 ATTRIBUTE4
, TLDB.ATTRIBUTE5 ATTRIBUTE5
, TLDB.ATTRIBUTE6 ATTRIBUTE6
, TLDB.ATTRIBUTE7 ATTRIBUTE7
, TLDB.ATTRIBUTE8 ATTRIBUTE8
, TLDB.ATTRIBUTE9 ATTRIBUTE9
, TLDB.ATTRIBUTE10 ATTRIBUTE10
, TLDB.ATTRIBUTE11 ATTRIBUTE11
, TLDB.ATTRIBUTE12 ATTRIBUTE12
, TLDB.ATTRIBUTE13 ATTRIBUTE13
, TLDB.ATTRIBUTE14 ATTRIBUTE14
, TLDB.ATTRIBUTE15 ATTRIBUTE15
, TLDB.REQUEST_ID REQUEST_ID
, TLDB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TLDB.PROGRAM_ID PROGRAM_ID
, TLDB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TLDB.ORG_ID ORG_ID
, TLDB.INVENTORY_ORG_ID INVENTORY_ORG_ID
, TLDB.CREATED_BY CREATED_BY
, TLDB.CREATION_DATE CREATION_DATE
, TLDB.LAST_UPDATED_BY LAST_UPDATED_BY
, TLDB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TLDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TLDB.TXL_AR_LINE_NUMBER
, TLDB.INVOICE_FORMAT_TYPE
, TLDB.INVOICE_FORMAT_LINE_TYPE
, TLDB.LATE_CHARGE_ASSESS_DATE
, TLDB.LATE_INT_ASSESS_DATE
, TLDB.LATE_CHARGE_ASS_YN
, TLDB.LATE_INT_ASS_YN
, TLDB.INVESTOR_DISB_STATUS
, TLDB.INVESTOR_DISB_ERR_MG
, TLDB.DATE_DISBURSED
, TLDB.PAY_STATUS_CODE
, TLDB.TAX_AMOUNT
, TLDB.LSM_ID
, TLDB.RBK_ORI_INVOICE_NUMBER
, TLDB.RBK_ORI_INVOICE_LINE_NUMBER
, TLDB.RBK_ADJUSTMENT_DATE
, TLDB.KHR_ID
, TLDB.KLE_ID
FROM OKL_TXD_AR_LN_DTLS_B TLDB
, OKL_TXD_AR_LN_DTLS_TL TLDT
WHERE TLDB.ID = TLDT.ID
AND TLDT.LANGUAGE = USERENV('LANG')