eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FII_AR_REV_CUST_V

Product:	FII - Financial Intelligence (Obsolete)
Description:	FII_AR_REV_CUST_V is an Internal view used to support Operation Indicators Portlets
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT F.SET_OF_BOOKS_FK_KEY
, F.OPERATING_UNIT_FK_KEY
, F.CUSTOMER_FK_KEY
, F.FUNCTIONAL_CURRENCY
, F.AMT_REV_EARNED_G
, F.INV_REVREC_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_REV_EARNED_G <> 0 OR F.INV_REVREC_CNT <> 0)

Columns

Name
SOB_ID
ORG_ID
CUSTOMER_ID
FUNCTIONAL_CURRENCY
CYCQ_QTD_REV
CYCQ_QTD_INV_COUNT