[Home] [Help]
View: FII_AR_OLTP_CASH_V
Product: | FII - Financial Intelligence |
Description: | FII_AR_OLTP_CASH_V is an internal view used to support Operations Indicators Portlet |
Implementation/DBA Data: |
APPS.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
Name |
CASH_RECEIPT_ID |
INSTANCE_CODE |
ORG_ID |
SOB_ID |
CUSTOMER_ID |
PERIOD_SET |
PERIOD_TYPE |
CALENDAR_DAY |
FUNCTIONAL_CURRENCY |
CASH_G |
CASH_B |