[Home] [Help]
View: FII_AR_PROD_REV3_V
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | FII_AR_PROD_REV3_V is an internal view used to support Product Revenue Portlet |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
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
, TO_CHAR(TO_DATE(F.PERIOD_NAME
, 'MONTH')
, 'MON')
, F.START_DATE
, F.CURR_AMT
, F.PRIOR_AMT
FROM FII_AR_PROD_REV_SUM3_F F
Columns
| Name |
| CUSTOMER_ID |
| MGR_L09_ID |
| MGR_L10_ID |
| MGR_L11_ID |
| MGR_L12_ID |
| MGR_L13_ID |
| MGR_L14_ID |
| MGR_L15_ID |
| PROD_L06_ID |
| PROD_L07_ID |
| PROD_L08_ID |
| PROD_L09_ID |
| PROD_L10_ID |
| PERIOD_NAME |
| START_DATE |
| CURR_AMT |
| PRIOR_AMT |