Product: | OKL - Lease and Finance Management |
---|---|
Description: | Application of OKL writeoffs to AR invoices |
Implementation/DBA Data: | APPS.OKL_TXL_ADJSTS_LNS_V |
SELECT AJLB.ROWID ROW_ID
, AJLB.ID ID
, AJLB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AJLT.SFWT_FLAG SFWT_FLAG
, AJLB.ADJ_ID ADJ_ID
, AJLB.TIL_ID TIL_ID
, AJLB.TLD_ID TLD_ID
, AJLB.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AJLB.PSL_ID PSL_ID
, AJLB.AMOUNT AMOUNT
, AJLB.CHECK_APPROVAL_LIMIT_YN CHECK_APPROVAL_LIMIT_YN
, AJLB.RECEIVABLES_ADJUSTMENT_ID RECEIVABLES_ADJUSTMENT_ID
, AJLB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AJLB.ATTRIBUTE1 ATTRIBUTE1
, AJLB.ATTRIBUTE2 ATTRIBUTE2
, AJLB.ATTRIBUTE3 ATTRIBUTE3
, AJLB.ATTRIBUTE4 ATTRIBUTE4
, AJLB.ATTRIBUTE5 ATTRIBUTE5
, AJLB.ATTRIBUTE6 ATTRIBUTE6
, AJLB.ATTRIBUTE7 ATTRIBUTE7
, AJLB.ATTRIBUTE8 ATTRIBUTE8
, AJLB.ATTRIBUTE9 ATTRIBUTE9
, AJLB.ATTRIBUTE10 ATTRIBUTE10
, AJLB.ATTRIBUTE11 ATTRIBUTE11
, AJLB.ATTRIBUTE12 ATTRIBUTE12
, AJLB.ATTRIBUTE13 ATTRIBUTE13
, AJLB.ATTRIBUTE14 ATTRIBUTE14
, AJLB.ATTRIBUTE15 ATTRIBUTE15
, AJLB.REQUEST_ID REQUEST_ID
, AJLB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AJLB.PROGRAM_ID PROGRAM_ID
, AJLB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AJLB.ORG_ID ORG_ID
, AJLB.CREATED_BY CREATED_BY
, AJLB.CREATION_DATE CREATION_DATE
, AJLB.LAST_UPDATED_BY LAST_UPDATED_BY
, AJLB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AJLB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AJLB.KLE_ID KLE_ID
, AJLB.STY_ID STY_ID
, AJLB.KHR_ID KHR_ID
FROM OKL_TXL_ADJSTS_LNS_B AJLB
, OKL_TXL_ADJSTS_LNS_TL AJLT
WHERE AJLB.ID = AJLT.ID
AND AJLT.LANGUAGE = USERENV('LANG')