Product: | OKL - Lease and Finance Management |
---|---|
Description: | Receipt application specyfing amount applied to Receivables invoices |
Implementation/DBA Data: | APPS.OKL_XTL_CSH_APPS_V |
SELECT XCAB.ROWID ROW_ID
, XCAB.ID ID
, XCAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XCAT.SFWT_FLAG SFWT_FLAG
, XCAB.RCA_ID RCA_ID
, XCAB.LSM_ID LSM_ID
, XCAB.IRP_ID IRP_ID
, XCAB.CAT_ID CAT_ID
, XCAB.XCR_ID_DETAILS XCR_ID_DETAILS
, XCAB.INVOICE_NUMBER INVOICE_NUMBER
, XCAB.AMOUNT_APPLIED AMOUNT_APPLIED
, XCAB.INVOICE_INSTALLMENT INVOICE_INSTALLMENT
, XCAB.AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM
, XCAB.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, XCAB.TRANS_TO_RECEIPT_RATE TRANS_TO_RECEIPT_RATE
, XCAB.TRX_DATE TRX_DATE
, XCAB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, XCAB.ATTRIBUTE1 ATTRIBUTE1
, XCAB.ATTRIBUTE2 ATTRIBUTE2
, XCAB.ATTRIBUTE3 ATTRIBUTE3
, XCAB.ATTRIBUTE4 ATTRIBUTE4
, XCAB.ATTRIBUTE5 ATTRIBUTE5
, XCAB.ATTRIBUTE6 ATTRIBUTE6
, XCAB.ATTRIBUTE7 ATTRIBUTE7
, XCAB.ATTRIBUTE8 ATTRIBUTE8
, XCAB.ATTRIBUTE9 ATTRIBUTE9
, XCAB.ATTRIBUTE10 ATTRIBUTE10
, XCAB.ATTRIBUTE11 ATTRIBUTE11
, XCAB.ATTRIBUTE12 ATTRIBUTE12
, XCAB.ATTRIBUTE13 ATTRIBUTE13
, XCAB.ATTRIBUTE14 ATTRIBUTE14
, XCAB.ATTRIBUTE15 ATTRIBUTE15
, XCAB.REQUEST_ID REQUEST_ID
, XCAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, XCAB.PROGRAM_ID PROGRAM_ID
, XCAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, XCAB.ORG_ID ORG_ID
, XCAB.CREATED_BY CREATED_BY
, XCAB.CREATION_DATE CREATION_DATE
, XCAB.LAST_UPDATED_BY LAST_UPDATED_BY
, XCAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XCAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_XTL_CSH_APPS_B XCAB
, OKL_XTL_CSH_APPS_TL XCAT
WHERE XCAB.ID = XCAT.ID
AND XCAT.LANGUAGE = USERENV('LANG')