VIEW: APPS.FII_AR_OLTP_CASH_V

Source

View Text - Preformatted

SELECT cash.cash_receipt_id, inst.instance_code, cash.org_id, cash.set_of_books_id, nvl(cash.pay_from_customer,-1), sob.period_set_name, sob.accounted_period_type, crh_first_posted.gl_date, sob.currency_code, edw_currency.convert_global_amount( nvl(ad.amount_dr,0) - nvl(ad.amount_cr,0), nvl(ad.acctd_amount_dr,0) - nvl(ad.acctd_amount_cr,0), cash.currency_code, sob.currency_code, cash.receipt_date, cash.exchange_rate_type) cash_g, nvl(ad.acctd_amount_dr,0) - nvl(ad.acctd_amount_cr,0) cash_b 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
, INST.INSTANCE_CODE
, CASH.ORG_ID
, CASH.SET_OF_BOOKS_ID
, NVL(CASH.PAY_FROM_CUSTOMER
, -1)
, SOB.PERIOD_SET_NAME
, SOB.ACCOUNTED_PERIOD_TYPE
, CRH_FIRST_POSTED.GL_DATE
, SOB.CURRENCY_CODE
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( NVL(AD.AMOUNT_DR
, 0) - NVL(AD.AMOUNT_CR
, 0)
, NVL(AD.ACCTD_AMOUNT_DR
, 0) - NVL(AD.ACCTD_AMOUNT_CR
, 0)
, CASH.CURRENCY_CODE
, SOB.CURRENCY_CODE
, CASH.RECEIPT_DATE
, CASH.EXCHANGE_RATE_TYPE) CASH_G
, NVL(AD.ACCTD_AMOUNT_DR
, 0) - NVL(AD.ACCTD_AMOUNT_CR
, 0) CASH_B
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'