[Home] [Help]
View: FII_AR_PROD_REV1_V_WH
Product: | FII - Financial Intelligence |
Description: | FII_AR_PROD_REV1_V_WH 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 |