View: FII_AR_INV_CUST_WH_V

Product:	FII - Financial Intelligence
Description:	fii_ar_inv_cust_wh_v is an Internal view used to support Operations Indicators Portlets
Implementation/DBA Data:	APPS.FII_AR_INV_CUST_WH_V

View Text

SELECT F.SET_OF_BOOKS_FK_KEY
, F.OPERATING_UNIT_FK_KEY
, F.CUSTOMER_FK_KEY
, F.FUNCTIONAL_CURRENCY
, F.AMT_INVOICED_AR_G
, F.INV_CREATED_CNT FROM (SELECT FII_TIME_WH_API.ENT_CYCQ_START CYCQ_START
, FII_TIME_WH_API.TODAY CYCQ_TODAY
FROM DUAL) CAL
, FII_AR_OPER_CUST_SUMMARY_F F
WHERE F.CALENDAR_DATE BETWEEN CAL.CYCQ_START
AND CAL.CYCQ_TODAY AND (F.AMT_INVOICED_AR_G <> 0 OR F.INV_CREATED_CNT <> 0)

Columns