VIEW: APPS.OKL_BPD_TRX_CONT_SUMMARY_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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