[Home] [Help]
View: FII_AR_PROD_REV2_V
Product: | FII - Financial Intelligence |
Description: | FII_AR_PROD_REV2_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_YTD
, F.PRIOR_YTD
FROM FII_AR_PROD_REV_SUM2_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_YTD |
PRIOR_YTD |