View: OKL_BPD_CONTRACT_REMAINING_V

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_CONTRACT_REMAINING_V

View Text

SELECT KH.ID CONTRACT_ID
, KH.CONTRACT_NUMBER CONTRACT_NUMBER
, HD.IXX_ID CUSTOMER_ID
, PY.PARTY_NAME CUSTOMER_NAME
, CA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, KH.CURRENCY_CODE CURRENCY_CODE
, PS.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, SUM (PS.ACCTD_AMOUNT_DUE_REMAINING) FUNCTIONAL_AMOUNT
, SUM (PS.AMOUNT_DUE_REMAINING) AMOUNT
FROM AR_PAYMENT_SCHEDULES_ALL PS
, OKL_CNSLD_AR_HDRS_B HD
, OKL_CNSLD_AR_LINES_B LN
, OKL_CNSLD_AR_STRMS_B ST
, OKC_K_HEADERS_ALL_B KH
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
, OKL_STRM_TYPE_V STRM
WHERE LN.CNR_ID = HD.ID
AND ST.LLN_ID = LN.ID
AND PS.CUSTOMER_TRX_ID = ST.RECEIVABLES_INVOICE_ID
AND KH.ID = ST.KHR_ID
AND CA.CUST_ACCOUNT_ID = HD.IXX_ID
AND PY.PARTY_ID = CA.PARTY_ID
AND STRM.ID=ST.STY_ID
AND STRM.STREAM_TYPE_PURPOSE <>'CURE'
AND HD.ORG_ID = PS.ORG_ID GROUP BY KH.ID
, KH.CONTRACT_NUMBER
, HD.IXX_ID
, PY.PARTY_NAME
, CA.ACCOUNT_NUMBER
, KH.CURRENCY_CODE
, PS.CUSTOMER_SITE_USE_ID

Columns