Product: | FII - Financial Intelligence (Obsolete) |
---|---|
Description: | FII_AR_PROD_REV4_V_WH is an internal view used to support Product Revenue Portlet |
Implementation/DBA Data: | Not implemented in this database |
SELECT F.CUSTOMER_ID
, F.MGR_L09_ID
, F.MGR_L10_ID
, F.MGR_L11_ID
, F.MGR_L12_ID
, F.MGR_L13_ID
, F.MGR_L14_ID
, F.MGR_L15_ID
, F.PROD_L06_ID
, F.PROD_L07_ID
, F.PROD_L08_ID
, F.PROD_L09_ID
, F.PROD_L10_ID
, F.SEQ_ID
, DECODE(INSTR(F.QUARTER
, 'QTD')
, 0
, SUBSTR(F.QUARTER
, 1
, 1)||SUBSTR(F.QUARTER
, LENGTH(F.QUARTER)
, 1)
, 1
, F.QUARTER)
, F.START_DATE
, F.CURR_AMT
, F.PRIOR_AMT
, F.PRIOR_TOTAL
FROM FII_AR_PROD_REV_SUM4_F F