Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_BPD_TRX_SUM_STRMS_RCPTS_UV |
SELECT A.CONSOLIDATED_INVOICE_NUMBER
, A.CONSOLIDATED_INVOICE_ID
, A.CONSOLIDATED_LINE_NUMBER
, A.CONTRACT_NUMBER
, A.CONTRACT_LINE_ID
, NVL(A.TAX_AMOUNT
, 0)
, A.LINE_NAME
, A.STREAM_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, A.STREAM_TYPE_PURPOSE) STREAM_PURPOSE_MEANING
, A.AMOUNT_DUE_ORIGINAL
, A.AMOUNT_DUE_REMAINING BALANCE
, (A.AMOUNT_DUE_ORIGINAL - A.AMOUNT_DUE_REMAINING) AMOUNT_PAID
, A.RECEIVABLES_INVOICE_NUMBER
, A.STREAM_ID LSM_ID
FROM OKL_BPD_LEASING_PAYMENT_TRX_V A