eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_BPD_RECEIPT_SUMMARY_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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