View: OKL_BPD_RECEIPT_SUMMARY_UV

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

View Text

SELECT DISTINCT RCT.ILE_ID CUSTOMER_ID
, SUBSTRB (PY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, CA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, RCT.DATE_EFFECTIVE RECEIPT_DATE
, RCT.CURRENCY_CODE CURRENCY_CODE
, EXT.CHECK_NUMBER RECEIPT_NUMBER
, TO_CHAR (RCT.AMOUNT
, '99
, 999
, 999
, 999.99') RECEIPT_AMOUNT
, RM.NAME RECEIPT_METHOD
, EXT.REMITTANCE_BANK_NAME CUSTOMER_BANK_NAME
, EXT.ACCOUNT ACCOUNT
, CNR.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER
, CNR.DATE_CONSOLIDATED DATE_CONSOLIDATED
, CNR.AMOUNT CONSOLIDATED_INVOICE_AMOUNT
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, RCT.ID INT_RECEIPT_ID
, EXT.ID EXT_RECEIPT_ID
, CNR.ID CNSLD_AR_HDRS_ID
, KHR_ID OKC_K_HEADERS_ID
, RCT.ORG_ID ORG_ID
, RCT.RECEIPT_TYPE RECEIPT_TYPE
FROM OKL_TRX_CSH_RECEIPT_B RCT
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
, OKL_EXT_CSH_RCPTS_ALL_B EXT
, OKL_TXL_RCPT_APPS_ALL_B RCA
, OKL_CNSLD_AR_HDRS_ALL_B CNR
, OKC_K_HEADERS_ALL_B KHR
, AR_RECEIPT_METHODS RM
WHERE CA.CUST_ACCOUNT_ID = RCT.ILE_ID
AND PY.PARTY_ID = CA.PARTY_ID
AND EXT.RCT_ID = RCT.ID
AND RCT.IRM_ID = RM.RECEIPT_METHOD_ID
AND RCA.RCT_ID_DETAILS = RCT.ID
AND CNR.ID (+) = RCA.CNR_ID
AND KHR.ID (+) = RCA.KHR_ID

Columns