[Home] [Help]
View: FII_AR_CASH_FCV
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | FII_AR_CASH_FCV is an internal view used to support Operations Indicators Portlet |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
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'
Columns
| Name |
| CASH_RECEIPT_ID |
| SET_OF_BOOKS_ID |
| SET_OF_BOOKS_FK |
| CUSTOMER_FK |
| ORG_FK |
| GL_DATE |
| INSTANCE |
| RECEIPT_DATE |
| BASE_CURRENCY |
| CASH_B |
| GL_DATE_FILTER |