VIEW: APPS.OKL_BPD_CONS_INV_CUST_UV

Source

View Text - Preformatted

SELECT cnr.consolidated_invoice_number , party.name CUSTOMER_NAME , site.name BILL_TO_SITE_NAME , cnr.currency_code , cnr.due_date , cnr.amount , sum(aps.amount_due_remaining) balance FROM OKC_K_HEADERS_B KHR,OKL_CNSLD_AR_HDRS_ALL_B CNR,OKL_CNSLD_AR_LINES_B LLN,OKL_CNSLD_AR_STRMS_B LSM,AR_PAYMENT_SCHEDULES_ALL APS,OKX_CUST_SITE_USES_V SITE,OKC_K_PARTY_ROLES_B RLE,OKX_PARTIES_V PARTY WHERE cnr.id = lln.cnr_id and lln.id = lsm.lln_id and lsm.receivables_invoice_id = aps.customer_trx_id and lsm.khr_id = khr.id and khr.bill_to_site_use_id = to_char(site.id1) and lsm.khr_id = rle.dnz_chr_id and rle.rle_code = 'LESSEE' and rle.object1_id1 = party.id1 group by cnr.consolidated_invoice_number , party.name , site.name , cnr.currency_code , cnr.due_date , cnr.amount

View Text - HTML Formatted

SELECT CNR.CONSOLIDATED_INVOICE_NUMBER
, PARTY.NAME CUSTOMER_NAME
, SITE.NAME BILL_TO_SITE_NAME
, CNR.CURRENCY_CODE
, CNR.DUE_DATE
, CNR.AMOUNT
, SUM(APS.AMOUNT_DUE_REMAINING) BALANCE
FROM OKC_K_HEADERS_B KHR
, OKL_CNSLD_AR_HDRS_ALL_B CNR
, OKL_CNSLD_AR_LINES_B LLN
, OKL_CNSLD_AR_STRMS_B LSM
, AR_PAYMENT_SCHEDULES_ALL APS
, OKX_CUST_SITE_USES_V SITE
, OKC_K_PARTY_ROLES_B RLE
, OKX_PARTIES_V PARTY
WHERE CNR.ID = LLN.CNR_ID
AND LLN.ID = LSM.LLN_ID
AND LSM.RECEIVABLES_INVOICE_ID = APS.CUSTOMER_TRX_ID
AND LSM.KHR_ID = KHR.ID
AND KHR.BILL_TO_SITE_USE_ID = TO_CHAR(SITE.ID1)
AND LSM.KHR_ID = RLE.DNZ_CHR_ID
AND RLE.RLE_CODE = 'LESSEE'
AND RLE.OBJECT1_ID1 = PARTY.ID1 GROUP BY CNR.CONSOLIDATED_INVOICE_NUMBER
, PARTY.NAME
, SITE.NAME
, CNR.CURRENCY_CODE
, CNR.DUE_DATE
, CNR.AMOUNT