VIEW: APPS.OKL_BPD_CONTRACT_REMAINING_UV

Source

View Text - Preformatted

SELECT KH.ID CONTRACT_ID ,KH.CONTRACT_NUMBER CONTRACT_NUMBER ,KH.START_DATE START_DATE ,HD.IXX_ID CUSTOMER_ID ,PY.PARTY_NAME CUSTOMER_NAME ,HD.CURRENCY_CODE CURRENCY_CODE ,CA.ACCOUNT_NUMBER CUSTOMER_NUMBER ,to_char (SUM (PS.AMOUNT_DUE_REMAINING), '99,999,999,999.99') AMOUNT ,okl_accounting_util.get_func_curr_code ,SUM(PS.AMOUNT_DUE_REMAINING) DUE_REMAINING FROM OKL_CNSLD_AR_HDRS_ALL_B HD,OKL_CNSLD_AR_LINES_B LN,OKL_CNSLD_AR_STRMS_B ST,OKC_K_HEADERS_B KH,AR_PAYMENT_SCHEDULES_ALL PS,HZ_CUST_ACCOUNTS CA,HZ_PARTIES PY,OKL_STRM_TYPE_TL SM 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 SM.ID = ST.STY_ID AND SM.LANGUAGE = USERENV('LANG') AND CA.CUST_ACCOUNT_ID = HD.IXX_ID AND PY.PARTY_ID = CA.PARTY_ID GROUP BY KH.ID ,KH.CONTRACT_NUMBER ,KH.START_DATE ,HD.IXX_ID ,PY.PARTY_NAME ,HD.CURRENCY_CODE ,CA.ACCOUNT_NUMBER HAVING SUM (PS.AMOUNT_DUE_REMAINING) > 0

View Text - HTML Formatted

SELECT KH.ID CONTRACT_ID
, KH.CONTRACT_NUMBER CONTRACT_NUMBER
, KH.START_DATE START_DATE
, HD.IXX_ID CUSTOMER_ID
, PY.PARTY_NAME CUSTOMER_NAME
, HD.CURRENCY_CODE CURRENCY_CODE
, CA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, TO_CHAR (SUM (PS.AMOUNT_DUE_REMAINING)
, '99
, 999
, 999
, 999.99') AMOUNT
, OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE
, SUM(PS.AMOUNT_DUE_REMAINING) DUE_REMAINING
FROM OKL_CNSLD_AR_HDRS_ALL_B HD
, OKL_CNSLD_AR_LINES_B LN
, OKL_CNSLD_AR_STRMS_B ST
, OKC_K_HEADERS_B KH
, AR_PAYMENT_SCHEDULES_ALL PS
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
, OKL_STRM_TYPE_TL SM
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 SM.ID = ST.STY_ID
AND SM.LANGUAGE = USERENV('LANG')
AND CA.CUST_ACCOUNT_ID = HD.IXX_ID
AND PY.PARTY_ID = CA.PARTY_ID GROUP BY KH.ID
, KH.CONTRACT_NUMBER
, KH.START_DATE
, HD.IXX_ID
, PY.PARTY_NAME
, HD.CURRENCY_CODE
, CA.ACCOUNT_NUMBER HAVING SUM (PS.AMOUNT_DUE_REMAINING) > 0