Product: | OKL - Lease and Finance Management |
---|---|
Description: | Apply cash to various OKL objects |
Implementation/DBA Data: | APPS.OKL_TXL_RCPT_APPS_V |
SELECT RCAB.ROWID ROW_ID
, RCAB.ID ID
, RCAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RCAT.SFWT_FLAG SFWT_FLAG
, RCAB.CNR_ID CNR_ID
, RCAB.LLN_ID LLN_ID
, RCAB.LSM_ID LSM_ID
, RCAB.KHR_ID KHR_ID
, RCAB.ILE_ID ILE_ID
, RCAB.STY_ID STY_ID
, RCAB.RCT_ID_DETAILS RCT_ID_DETAILS
, RCAB.LINE_NUMBER LINE_NUMBER
, RCAT.DESCRIPTION DESCRIPTION
, RCAB.AMOUNT AMOUNT
, RCAB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, RCAB.ATTRIBUTE1 ATTRIBUTE1
, RCAB.ATTRIBUTE2 ATTRIBUTE2
, RCAB.ATTRIBUTE3 ATTRIBUTE3
, RCAB.ATTRIBUTE4 ATTRIBUTE4
, RCAB.ATTRIBUTE5 ATTRIBUTE5
, RCAB.ATTRIBUTE6 ATTRIBUTE6
, RCAB.ATTRIBUTE7 ATTRIBUTE7
, RCAB.ATTRIBUTE8 ATTRIBUTE8
, RCAB.ATTRIBUTE9 ATTRIBUTE9
, RCAB.ATTRIBUTE10 ATTRIBUTE10
, RCAB.ATTRIBUTE11 ATTRIBUTE11
, RCAB.ATTRIBUTE12 ATTRIBUTE12
, RCAB.ATTRIBUTE13 ATTRIBUTE13
, RCAB.ATTRIBUTE14 ATTRIBUTE14
, RCAB.ATTRIBUTE15 ATTRIBUTE15
, RCAB.REQUEST_ID REQUEST_ID
, RCAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, RCAB.PROGRAM_ID PROGRAM_ID
, RCAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RCAB.ORG_ID ORG_ID
, RCAB.CREATED_BY CREATED_BY
, RCAB.CREATION_DATE CREATION_DATE
, RCAB.LAST_UPDATED_BY LAST_UPDATED_BY
, RCAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RCAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RCAB.AR_INVOICE_ID AR_INVOICE_ID
FROM OKL_TXL_RCPT_APPS_B RCAB
, OKL_TXL_RCPT_APPS_TL RCAT
WHERE RCAB.ID = RCAT.ID
AND RCAT.LANGUAGE = USERENV('LANG')