[Home] [Help]
View: FII_AR_PROD_REV1_V
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | FII_AR_PROD_REV1_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
, F.CURR_QTD
, F.PRIOR_QTD
, F.PRIOR_TOTAL
FROM FII_AR_PROD_REV_SUM1_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 |
| CURR_QTD |
| PRIOR_QTD |
| PRIOR_TOTAL |