View: FII_AR_OLTP_CASH_V

View Text

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'

Columns