VIEW: APPS.FII_AR_CASH_FCV

Source

View Text - Preformatted

SELECT cash.cash_receipt_id, cash.set_of_books_id, cash.set_of_books_id||'-'||inst.instance_code, decode(cash.pay_from_customer,to_number(NULL),'NA_EDW', cash.pay_from_customer||'-'||inst.instance_code|| '-CUST_ACCT-TPRT'), cash.org_id||'-'||inst.instance_code, trunc(crh_first_posted.gl_date), inst.instance_code, cash.receipt_date, sob.currency_code, nvl(ad.acctd_amount_dr,0) - nvl(ad.acctd_amount_cr,0) cash_b, crh_first_posted.gl_date FROM edw_local_instance inst, ar_cash_receipt_history_all crh_first_posted, ar_cash_receipts_all cash, gl_sets_of_books sob, ar_cash_receipt_history_all crh_current, ar_distributions_all ad WHERE crh_first_posted.first_posted_record_flag = 'Y' and cash.cash_receipt_id = crh_first_posted.cash_receipt_id and cash.status not in ('NSF','REV','STOP') and NVL(cash.confirmed_flag, 'Y') = 'Y' and sob.set_of_books_id = cash.set_of_books_id and crh_current.cash_receipt_id = cash.cash_receipt_id and crh_current.current_record_flag = 'Y' and ad.source_id = crh_current.cash_receipt_history_id and ad.source_table = 'CRH'

View Text - HTML Formatted

SELECT CASH.CASH_RECEIPT_ID
, CASH.SET_OF_BOOKS_ID
, CASH.SET_OF_BOOKS_ID||'-'||INST.INSTANCE_CODE
, DECODE(CASH.PAY_FROM_CUSTOMER
, TO_NUMBER(NULL)
, 'NA_EDW'
, CASH.PAY_FROM_CUSTOMER||'-'||INST.INSTANCE_CODE|| '-CUST_ACCT-TPRT')
, CASH.ORG_ID||'-'||INST.INSTANCE_CODE
, TRUNC(CRH_FIRST_POSTED.GL_DATE)
, INST.INSTANCE_CODE
, CASH.RECEIPT_DATE
, SOB.CURRENCY_CODE
, NVL(AD.ACCTD_AMOUNT_DR
, 0) - NVL(AD.ACCTD_AMOUNT_CR
, 0) CASH_B
, CRH_FIRST_POSTED.GL_DATE
FROM EDW_LOCAL_INSTANCE INST
, AR_CASH_RECEIPT_HISTORY_ALL CRH_FIRST_POSTED
, AR_CASH_RECEIPTS_ALL CASH
, GL_SETS_OF_BOOKS SOB
, AR_CASH_RECEIPT_HISTORY_ALL CRH_CURRENT
, AR_DISTRIBUTIONS_ALL AD
WHERE CRH_FIRST_POSTED.FIRST_POSTED_RECORD_FLAG = 'Y'
AND CASH.CASH_RECEIPT_ID = CRH_FIRST_POSTED.CASH_RECEIPT_ID
AND CASH.STATUS NOT IN ('NSF'
, 'REV'
, 'STOP')
AND NVL(CASH.CONFIRMED_FLAG
, 'Y') = 'Y'
AND SOB.SET_OF_BOOKS_ID = CASH.SET_OF_BOOKS_ID
AND CRH_CURRENT.CASH_RECEIPT_ID = CASH.CASH_RECEIPT_ID
AND CRH_CURRENT.CURRENT_RECORD_FLAG = 'Y'
AND AD.SOURCE_ID = CRH_CURRENT.CASH_RECEIPT_HISTORY_ID
AND AD.SOURCE_TABLE = 'CRH'