View: OKL_BPD_TRX_CONT_SUMMARY_UV

Product:	OKL - Lease and Finance Management
Description:	Contract Transaction Summary
Implementation/DBA Data:	APPS.OKL_BPD_TRX_CONT_SUMMARY_UV

View Text

SELECT CN.CONTRACT_NUMBER
, SUBSTRB (PY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, CA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HD.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER
, HD.CURRENCY_CODE
, PS.TRX_DATE TRX_DATE
, SUM(PS.AMOUNT_DUE_ORIGINAL) AMOUNT
, SUM(PS.AMOUNT_DUE_REMAINING) BALANCE
, HD.ORG_ID
FROM AR_PAYMENT_SCHEDULES_ALL PS
, OKL_CNSLD_AR_STRMS_B ST
, OKL_CNSLD_AR_LINES_B LN
, OKL_CNSLD_AR_HDRS_B HD
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
, OKC_K_HEADERS_ALL_B CN
WHERE PS.CLASS IN ('INV'
, 'CM')
AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
AND LN.ID = ST.LLN_ID
AND HD.ID = LN.CNR_ID
AND CA.CUST_ACCOUNT_ID = HD.IXX_ID
AND PY.PARTY_ID = CA.PARTY_ID
AND CN.ID (+) = ST.KHR_ID GROUP BY CN.CONTRACT_NUMBER
, SUBSTRB (PY.PARTY_NAME
, 1
, 50)
, CA.ACCOUNT_NUMBER
, HD.CONSOLIDATED_INVOICE_NUMBER
, HD.CURRENCY_CODE
, PS.TRX_DATE
, HD.ORG_ID

Columns