[Home] [Help]
View: FII_AR_CASH_CUST_L7D_WH_V
Product: | FII - Financial Intelligence |
Description: | fii_ar_cash_cust_l7d_wh_v is an Internal view used to support Operation Indicators Portlets |
Implementation/DBA Data: |
APPS.FII_AR_CASH_CUST_L7D_WH_V
|
View Text
SELECT F.SET_OF_BOOKS_FK_KEY
, F.OPERATING_UNIT_FK_KEY
, F.CUSTOMER_FK_KEY
, F.FUNCTIONAL_CURRENCY
, DECODE(SIGN(F.CALENDAR_DATE - CAL.CYCQ_7DAYS_AGO)
, -1
, 0
, DECODE(SIGN(CAL.CYCQ_TODAY - F.CALENDAR_DATE)
, -1
, 0
, F.AMT_CASH_RECEIVED_G))
, DECODE(SIGN(F.CALENDAR_DATE - CAL.CYCQ_7DAYS_AGO)
, -1
, 0
, DECODE(SIGN(CAL.CYCQ_TODAY - F.CALENDAR_DATE)
, -1
, 0
, F.RECEIPT_CNT))
FROM (SELECT FII_TIME_WH_API.ENT_CYCQ_START CYCQ_START
, FII_TIME_WH_API.TODAY CYCQ_TODAY
, FII_TIME_WH_API.TODAY - 6 CYCQ_7DAYS_AGO
FROM DUAL) CAL
, FII_AR_OPER_CUST_SUMMARY_F F
WHERE F.CALENDAR_DATE BETWEEN CAL.CYCQ_START
AND CAL.CYCQ_TODAY AND (DECODE(SIGN(F.CALENDAR_DATE - CAL.CYCQ_7DAYS_AGO)
, -1
, 0
, DECODE(SIGN(CAL.CYCQ_TODAY - F.CALENDAR_DATE)
, -1
, 0
, F.AMT_CASH_RECEIVED_G)) <> 0 OR DECODE(SIGN(F.CALENDAR_DATE - CAL.CYCQ_7DAYS_AGO)
, -1
, 0
, DECODE(SIGN(CAL.CYCQ_TODAY - F.CALENDAR_DATE)
, -1
, 0
, F.RECEIPT_CNT)) <> 0)
Columns
Name |
SOB_ID |
ORG_ID |
CUSTOMER_ID |
FUNCTIONAL_CURRENCY |
CYCQ_7DAY_CASH |
CYCQ_7DAY_REC_COUNT |