VIEW: APPS.IEX_BPD_CONTRACT_REMAINING_V

Source

View Text - Preformatted

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 PS,OKL_CNSLD_AR_HDRS_B HD, OKL_CNSLD_AR_LINES_B LN, OKL_CNSLD_AR_STRMS_B ST, OKC_K_HEADERS_B KH, HZ_CUST_ACCOUNTS CA, HZ_PARTIES PY 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 GROUP BY KH.ID , KH.CONTRACT_NUMBER , HD.IXX_ID , PY.PARTY_NAME, CA.ACCOUNT_NUMBER, KH.CURRENCY_CODE , PS.CUSTOMER_SITE_USE_ID

View Text - HTML Formatted

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 PS
, OKL_CNSLD_AR_HDRS_B HD
, OKL_CNSLD_AR_LINES_B LN
, OKL_CNSLD_AR_STRMS_B ST
, OKC_K_HEADERS_B KH
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
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 GROUP BY KH.ID
, KH.CONTRACT_NUMBER
, HD.IXX_ID
, PY.PARTY_NAME
, CA.ACCOUNT_NUMBER
, KH.CURRENCY_CODE
, PS.CUSTOMER_SITE_USE_ID