ZSF_FCST_MET_TERR_ADJPR_V
Details
-
Schema: FUSION
-
Object owner: ZSF
-
Object type: VIEW
Columns
Name |
---|
FCST_HEADER_ID FCST_METRICS_PARTITION_KEY FCST_PARTICIPANT_ID FCST_TERRITORY_ID ADJUST_PERIOD_ID CORP_REVN_AMT CORP_REVN_EXPECT_AMT CORP_UPSIDE_AMT CORP_DOWNSIDE_AMT CORP_PRED_REVN_AMT CORP_EXTN_UNADJ_MET_1 CORP_EXTN_UNADJ_MET_2 CORP_EXTN_UNADJ_MET_3 CORP_EXTN_UNADJ_MET_4 CORP_EXTN_UNADJ_MET_5 CORP_ITEM_ADJ_AMT CORP_BEST_ITEM_ADJ_AMT CORP_WRST_ITEM_ADJ_AMT CORP_ITEM_SUBADJ_AMT CORP_BEST_ITEM_SUBADJ_AMT CORP_WRST_ITEM_SUBADJ_AMT CORP_EXTN_ITADJ_MET_1 CORP_EXTN_ITADJ_MET_2 CORP_EXTN_ITADJ_MET_3 CORP_EXTN_ITADJ_MET_4 CORP_EXTN_ITADJ_MET_5 CORP_EXTN_ITADJ_SUB_1 CORP_EXTN_ITADJ_SUB_2 CORP_EXTN_ITADJ_SUB_3 CORP_EXTN_ITADJ_SUB_4 CORP_EXTN_ITADJ_SUB_5 CORP_SUM_ADJ_AMT CORP_BEST_SUM_ADJ_AMT CORP_WRST_SUM_ADJ_AMT CORP_SUM_SUBADJ_AMT CORP_BEST_SUM_SUBADJ_AMT CORP_WRST_SUM_SUBADJ_AMT CORP_EXTN_SUMADJ_MET_1 CORP_EXTN_SUMADJ_MET_2 CORP_EXTN_SUMADJ_MET_3 CORP_EXTN_SUMADJ_MET_4 CORP_EXTN_SUMADJ_MET_5 CORP_EXTN_SUMADJ_SUB_1 CORP_EXTN_SUMADJ_SUB_2 CORP_EXTN_SUMADJ_SUB_3 CORP_EXTN_SUMADJ_SUB_4 CORP_EXTN_SUMADJ_SUB_5 CORP_PS_REVN_AMT CORP_PS_REVN_EXPECT_AMT CORP_PS_UPSIDE_AMT CORP_PS_DOWNSIDE_AMT CORP_PS_PRED_REVN_AMT CORP_PS_EXTN_UNADJ_MET_1 CORP_PS_EXTN_UNADJ_MET_2 CORP_PS_EXTN_UNADJ_MET_3 CORP_PS_EXTN_UNADJ_MET_4 CORP_PS_EXTN_UNADJ_MET_5 CORP_PS_ITEM_ADJ_AMT CORP_PS_BEST_ITEM_ADJ_AMT CORP_PS_WRST_ITEM_ADJ_AMT CORP_PS_EXTN_ITADJ_MET_1 CORP_PS_EXTN_ITADJ_MET_2 CORP_PS_EXTN_ITADJ_MET_3 CORP_PS_EXTN_ITADJ_MET_4 CORP_PS_EXTN_ITADJ_MET_5 CORP_PS_SUM_ADJ_AMT CORP_PS_BEST_SUM_ADJ_AMT CORP_PS_WRST_SUM_ADJ_AMT CORP_PS_EXTN_SUMADJ_MET_1 CORP_PS_EXTN_SUMADJ_MET_2 CORP_PS_EXTN_SUMADJ_MET_3 CORP_PS_EXTN_SUMADJ_MET_4 CORP_PS_EXTN_SUMADJ_MET_5 CORP_REVN_WON_AMT CORP_REVN_WON_UNAL_AMT CORP_PS_REVN_WON_AMT CORP_PS_REVN_WON_UNAL_AMT UNADJ_QUANTITY ITADJ_QUANTITY ITADJ_SUB_QUANTITY SUMADJ_QUANTITY SUMADJ_SUB_QUANTITY PS_UNADJ_QUANTITY PS_ITADJ_QUANTITY PS_SUMADJ_QUANTITY RNWL_REVN_AMT RNWL_REVN_EXPECT_AMT RNWL_UPSIDE_AMT RNWL_DOWNSIDE_AMT RNWL_PRED_REVN_AMT RNWL_ITEM_ADJ_AMT RNWL_BEST_ITEM_ADJ_AMT RNWL_WRST_ITEM_ADJ_AMT RNWL_ITEM_SUBADJ_AMT RNWL_BEST_ITEM_SUBADJ_AMT RNWL_WRST_ITEM_SUBADJ_AMT RNWL_SUM_ADJ_AMT RNWL_BEST_SUM_ADJ_AMT RNWL_WRST_SUM_ADJ_AMT RNWL_SUM_SUBADJ_AMT RNWL_BEST_SUM_SUBADJ_AMT RNWL_WRST_SUM_SUBADJ_AMT RNWL_PS_REVN_AMT RNWL_PS_REVN_EXPECT_AMT RNWL_PS_UPSIDE_AMT RNWL_PS_DOWNSIDE_AMT RNWL_PS_PRED_REVN_AMT RNWL_PS_ITEM_ADJ_AMT RNWL_PS_BEST_ITEM_ADJ_AMT RNWL_PS_WRST_ITEM_ADJ_AMT RNWL_PS_SUM_ADJ_AMT RNWL_PS_BEST_SUM_ADJ_AMT RNWL_PS_WRST_SUM_ADJ_AMT RNWL_REVN_WON_AMT RNWL_REVN_WON_UNAL_AMT RNWL_PS_REVN_WON_AMT RNWL_PS_REVN_WON_UNAL_AMT RNWL_UNADJ_QUANTITY RNWL_ITADJ_QUANTITY RNWL_ITADJ_SUB_QUANTITY RNWL_SUMADJ_QUANTITY RNWL_SUMADJ_SUB_QUANTITY RNWL_PS_UNADJ_QUANTITY RNWL_PS_ITADJ_QUANTITY RNWL_PS_SUMADJ_QUANTITY NEW_REVN_AMT NEW_REVN_EXPECT_AMT NEW_UPSIDE_AMT NEW_DOWNSIDE_AMT NEW_PRED_REVN_AMT NEW_ITEM_ADJ_AMT NEW_BEST_ITEM_ADJ_AMT NEW_WRST_ITEM_ADJ_AMT NEW_ITEM_SUBADJ_AMT NEW_BEST_ITEM_SUBADJ_AMT NEW_WRST_ITEM_SUBADJ_AMT NEW_SUM_ADJ_AMT NEW_BEST_SUM_ADJ_AMT NEW_WRST_SUM_ADJ_AMT NEW_SUM_SUBADJ_AMT NEW_BEST_SUM_SUBADJ_AMT NEW_WRST_SUM_SUBADJ_AMT NEW_PS_REVN_AMT NEW_PS_REVN_EXPECT_AMT NEW_PS_UPSIDE_AMT NEW_PS_DOWNSIDE_AMT NEW_PS_PRED_REVN_AMT NEW_PS_ITEM_ADJ_AMT NEW_PS_BEST_ITEM_ADJ_AMT NEW_PS_WRST_ITEM_ADJ_AMT NEW_PS_SUM_ADJ_AMT NEW_PS_BEST_SUM_ADJ_AMT NEW_PS_WRST_SUM_ADJ_AMT NEW_REVN_WON_AMT NEW_REVN_WON_UNAL_AMT NEW_PS_REVN_WON_AMT NEW_PS_REVN_WON_UNAL_AMT NEW_UNADJ_QUANTITY NEW_ITADJ_QUANTITY NEW_ITADJ_SUB_QUANTITY NEW_SUMADJ_QUANTITY NEW_SUMADJ_SUB_QUANTITY NEW_PS_UNADJ_QUANTITY NEW_PS_ITADJ_QUANTITY NEW_PS_SUMADJ_QUANTITY |
Query
SQL_Statement |
---|
SELECT FCST_HEADER_ID , FCST_METRICS_PARTITION_KEY , FCST_PARTICIPANT_ID , FCST_TERRITORY_ID , ADJUST_PERIOD_ID , CORP_REVN_AMT , CORP_REVN_EXPECT_AMT , CORP_UPSIDE_AMT , CORP_DOWNSIDE_AMT , CORP_PRED_REVN_AMT , CORP_EXTN_UNADJ_MET_1 , CORP_EXTN_UNADJ_MET_2 , CORP_EXTN_UNADJ_MET_3 , CORP_EXTN_UNADJ_MET_4 , CORP_EXTN_UNADJ_MET_5 , CORP_ITEM_ADJ_AMT , CORP_BEST_ITEM_ADJ_AMT , CORP_WRST_ITEM_ADJ_AMT , CORP_ITEM_SUBADJ_AMT , CORP_BEST_ITEM_SUBADJ_AMT , CORP_WRST_ITEM_SUBADJ_AMT , CORP_EXTN_ITADJ_MET_1 , CORP_EXTN_ITADJ_MET_2 , CORP_EXTN_ITADJ_MET_3 , CORP_EXTN_ITADJ_MET_4 , CORP_EXTN_ITADJ_MET_5 , CORP_EXTN_ITADJ_SUB_1 , CORP_EXTN_ITADJ_SUB_2 , CORP_EXTN_ITADJ_SUB_3 , CORP_EXTN_ITADJ_SUB_4 , CORP_EXTN_ITADJ_SUB_5 , CORP_SUM_ADJ_AMT , CORP_BEST_SUM_ADJ_AMT , CORP_WRST_SUM_ADJ_AMT , CORP_SUM_SUBADJ_AMT , CORP_BEST_SUM_SUBADJ_AMT , CORP_WRST_SUM_SUBADJ_AMT , CORP_EXTN_SUMADJ_MET_1 , CORP_EXTN_SUMADJ_MET_2 , CORP_EXTN_SUMADJ_MET_3 , CORP_EXTN_SUMADJ_MET_4 , CORP_EXTN_SUMADJ_MET_5 , CORP_EXTN_SUMADJ_SUB_1 , CORP_EXTN_SUMADJ_SUB_2 , CORP_EXTN_SUMADJ_SUB_3 , CORP_EXTN_SUMADJ_SUB_4 , CORP_EXTN_SUMADJ_SUB_5 , CORP_PS_REVN_AMT , CORP_PS_REVN_EXPECT_AMT , CORP_PS_UPSIDE_AMT , CORP_PS_DOWNSIDE_AMT , CORP_PS_PRED_REVN_AMT , CORP_PS_EXTN_UNADJ_MET_1 , CORP_PS_EXTN_UNADJ_MET_2 , CORP_PS_EXTN_UNADJ_MET_3 , CORP_PS_EXTN_UNADJ_MET_4 , CORP_PS_EXTN_UNADJ_MET_5 , CORP_PS_ITEM_ADJ_AMT , CORP_PS_BEST_ITEM_ADJ_AMT , CORP_PS_WRST_ITEM_ADJ_AMT , CORP_PS_EXTN_ITADJ_MET_1 , CORP_PS_EXTN_ITADJ_MET_2 , CORP_PS_EXTN_ITADJ_MET_3 , CORP_PS_EXTN_ITADJ_MET_4 , CORP_PS_EXTN_ITADJ_MET_5 , CORP_PS_SUM_ADJ_AMT , CORP_PS_BEST_SUM_ADJ_AMT , CORP_PS_WRST_SUM_ADJ_AMT , CORP_PS_EXTN_SUMADJ_MET_1 , CORP_PS_EXTN_SUMADJ_MET_2 , CORP_PS_EXTN_SUMADJ_MET_3 , CORP_PS_EXTN_SUMADJ_MET_4 , CORP_PS_EXTN_SUMADJ_MET_5 , CORP_REVN_WON_AMT , CORP_REVN_WON_UNAL_AMT , CORP_PS_REVN_WON_AMT , CORP_PS_REVN_WON_UNAL_AMT , UNADJ_QUANTITY, ITADJ_QUANTITY , ITADJ_SUB_QUANTITY, SUMADJ_QUANTITY, SUMADJ_SUB_QUANTITY, PS_UNADJ_QUANTITY, PS_ITADJ_QUANTITY, PS_SUMADJ_QUANTITY, RNWL_REVN_AMT , RNWL_REVN_EXPECT_AMT , RNWL_UPSIDE_AMT , RNWL_DOWNSIDE_AMT , RNWL_PRED_REVN_AMT , RNWL_ITEM_ADJ_AMT , RNWL_BEST_ITEM_ADJ_AMT , RNWL_WRST_ITEM_ADJ_AMT , RNWL_ITEM_SUBADJ_AMT , RNWL_BEST_ITEM_SUBADJ_AMT , RNWL_WRST_ITEM_SUBADJ_AMT , RNWL_SUM_ADJ_AMT , RNWL_BEST_SUM_ADJ_AMT , RNWL_WRST_SUM_ADJ_AMT , RNWL_SUM_SUBADJ_AMT , RNWL_BEST_SUM_SUBADJ_AMT , RNWL_WRST_SUM_SUBADJ_AMT , RNWL_PS_REVN_AMT , RNWL_PS_REVN_EXPECT_AMT , RNWL_PS_UPSIDE_AMT , RNWL_PS_DOWNSIDE_AMT , RNWL_PS_PRED_REVN_AMT , RNWL_PS_ITEM_ADJ_AMT , RNWL_PS_BEST_ITEM_ADJ_AMT , RNWL_PS_WRST_ITEM_ADJ_AMT , RNWL_PS_SUM_ADJ_AMT , RNWL_PS_BEST_SUM_ADJ_AMT , RNWL_PS_WRST_SUM_ADJ_AMT , RNWL_REVN_WON_AMT , RNWL_REVN_WON_UNAL_AMT , RNWL_PS_REVN_WON_AMT , RNWL_PS_REVN_WON_UNAL_AMT , RNWL_UNADJ_QUANTITY, RNWL_ITADJ_QUANTITY , RNWL_ITADJ_SUB_QUANTITY, RNWL_SUMADJ_QUANTITY, RNWL_SUMADJ_SUB_QUANTITY, RNWL_PS_UNADJ_QUANTITY, RNWL_PS_ITADJ_QUANTITY, RNWL_PS_SUMADJ_QUANTITY , NEW_REVN_AMT , NEW_REVN_EXPECT_AMT , NEW_UPSIDE_AMT , NEW_DOWNSIDE_AMT , NEW_PRED_REVN_AMT , NEW_ITEM_ADJ_AMT , NEW_BEST_ITEM_ADJ_AMT , NEW_WRST_ITEM_ADJ_AMT , NEW_ITEM_SUBADJ_AMT , NEW_BEST_ITEM_SUBADJ_AMT , NEW_WRST_ITEM_SUBADJ_AMT , NEW_SUM_ADJ_AMT , NEW_BEST_SUM_ADJ_AMT , NEW_WRST_SUM_ADJ_AMT , NEW_SUM_SUBADJ_AMT , NEW_BEST_SUM_SUBADJ_AMT , NEW_WRST_SUM_SUBADJ_AMT , NEW_PS_REVN_AMT , NEW_PS_REVN_EXPECT_AMT , NEW_PS_UPSIDE_AMT , NEW_PS_DOWNSIDE_AMT , NEW_PS_PRED_REVN_AMT , NEW_PS_ITEM_ADJ_AMT , NEW_PS_BEST_ITEM_ADJ_AMT , NEW_PS_WRST_ITEM_ADJ_AMT , NEW_PS_SUM_ADJ_AMT , NEW_PS_BEST_SUM_ADJ_AMT , NEW_PS_WRST_SUM_ADJ_AMT , NEW_REVN_WON_AMT , NEW_REVN_WON_UNAL_AMT , NEW_PS_REVN_WON_AMT , NEW_PS_REVN_WON_UNAL_AMT , NEW_UNADJ_QUANTITY, NEW_ITADJ_QUANTITY , NEW_ITADJ_SUB_QUANTITY, NEW_SUMADJ_QUANTITY, NEW_SUMADJ_SUB_QUANTITY, NEW_PS_UNADJ_QUANTITY, NEW_PS_ITADJ_QUANTITY, NEW_PS_SUMADJ_QUANTITY FROM ZSF_FCST_METRICS_TXN_TERR_V TXN WHERE TXN.BI_METRIC_TYPE = 'BI_TERR_PROD_ADJPER' UNION ALL SELECT FCST_HEADER_ID , FCST_METRICS_PARTITION_KEY , FCST_PARTICIPANT_ID , FCST_TERRITORY_ID , ADJUST_PERIOD_ID , CORP_REVN_AMT , CORP_REVN_EXPECT_AMT , CORP_UPSIDE_AMT , CORP_DOWNSIDE_AMT , CORP_PRED_REVN_AMT , CORP_EXTN_UNADJ_MET_1 , CORP_EXTN_UNADJ_MET_2 , CORP_EXTN_UNADJ_MET_3 , CORP_EXTN_UNADJ_MET_4 , CORP_EXTN_UNADJ_MET_5 , CORP_ITEM_ADJ_AMT , CORP_BEST_ITEM_ADJ_AMT , CORP_WRST_ITEM_ADJ_AMT , CORP_ITEM_SUBADJ_AMT , CORP_BEST_ITEM_SUBADJ_AMT , CORP_WRST_ITEM_SUBADJ_AMT , CORP_EXTN_ITADJ_MET_1 , CORP_EXTN_ITADJ_MET_2 , CORP_EXTN_ITADJ_MET_3 , CORP_EXTN_ITADJ_MET_4 , CORP_EXTN_ITADJ_MET_5 , CORP_EXTN_ITADJ_SUB_1 , CORP_EXTN_ITADJ_SUB_2 , CORP_EXTN_ITADJ_SUB_3 , CORP_EXTN_ITADJ_SUB_4 , CORP_EXTN_ITADJ_SUB_5 , CORP_SUM_ADJ_AMT , CORP_BEST_SUM_ADJ_AMT , CORP_WRST_SUM_ADJ_AMT , CORP_BEST_SUM_SUBADJ_AMT , CORP_WRST_SUM_SUBADJ_AMT , CORP_EXTN_SUMADJ_MET_1 , CORP_EXTN_SUMADJ_MET_2 , CORP_EXTN_SUMADJ_MET_3 , CORP_EXTN_SUMADJ_MET_4 , CORP_EXTN_SUMADJ_MET_5 , CORP_EXTN_SUMADJ_SUB_1 , CORP_EXTN_SUMADJ_SUB_2 , CORP_EXTN_SUMADJ_SUB_3 , CORP_EXTN_SUMADJ_SUB_4 , CORP_EXTN_SUMADJ_SUB_5 , CORP_SUM_ADJ_UNAL_AMT , CORP_PS_REVN_AMT , CORP_PS_REVN_EXPECT_AMT , CORP_PS_UPSIDE_AMT , CORP_PS_DOWNSIDE_AMT , CORP_PS_PRED_REVN_AMT , CORP_PS_EXTN_UNADJ_MET_1 , CORP_PS_EXTN_UNADJ_MET_2 , CORP_PS_EXTN_UNADJ_MET_3 , CORP_PS_EXTN_UNADJ_MET_4 , CORP_PS_EXTN_UNADJ_MET_5 , CORP_PS_ITEM_ADJ_AMT , CORP_PS_BEST_ITEM_ADJ_AMT , CORP_PS_WRST_ITEM_ADJ_AMT , CORP_PS_EXTN_ITADJ_MET_1 , CORP_PS_EXTN_ITADJ_MET_2 , CORP_PS_EXTN_ITADJ_MET_3 , CORP_PS_EXTN_ITADJ_MET_4 , CORP_PS_EXTN_ITADJ_MET_5 , CORP_PS_SUM_ADJ_AMT , CORP_PS_BEST_SUM_ADJ_AMT , CORP_PS_WRST_SUM_ADJ_AMT , CORP_PS_EXTN_SUMADJ_MET_1 , CORP_PS_EXTN_SUMADJ_MET_2 , CORP_PS_EXTN_SUMADJ_MET_3 , CORP_PS_EXTN_SUMADJ_MET_4 , CORP_PS_EXTN_SUMADJ_MET_5 , CORP_REVN_WON_AMT , CORP_REVN_WON_UNAL_AMT , CORP_PS_REVN_WON_AMT , CORP_PS_REVN_WON_UNAL_AMT , UNADJ_QUANTITY, ITADJ_QUANTITY , ITADJ_SUB_QUANTITY, SUMADJ_QUANTITY, SUMADJ_SUB_QUANTITY, PS_UNADJ_QUANTITY, PS_ITADJ_QUANTITY, PS_SUMADJ_QUANTITY, RNWL_REVN_AMT , RNWL_REVN_EXPECT_AMT , RNWL_UPSIDE_AMT , RNWL_DOWNSIDE_AMT , RNWL_PRED_REVN_AMT , RNWL_ITEM_ADJ_AMT , RNWL_BEST_ITEM_ADJ_AMT , RNWL_WRST_ITEM_ADJ_AMT , RNWL_ITEM_SUBADJ_AMT , RNWL_BEST_ITEM_SUBADJ_AMT , RNWL_WRST_ITEM_SUBADJ_AMT , RNWL_SUM_ADJ_AMT , RNWL_BEST_SUM_ADJ_AMT , RNWL_WRST_SUM_ADJ_AMT , RNWL_SUM_SUBADJ_AMT , RNWL_BEST_SUM_SUBADJ_AMT , RNWL_WRST_SUM_SUBADJ_AMT , RNWL_PS_REVN_AMT , RNWL_PS_REVN_EXPECT_AMT , RNWL_PS_UPSIDE_AMT , RNWL_PS_DOWNSIDE_AMT , RNWL_PS_PRED_REVN_AMT , RNWL_PS_ITEM_ADJ_AMT , RNWL_PS_BEST_ITEM_ADJ_AMT , RNWL_PS_WRST_ITEM_ADJ_AMT , RNWL_PS_SUM_ADJ_AMT , RNWL_PS_BEST_SUM_ADJ_AMT , RNWL_PS_WRST_SUM_ADJ_AMT , RNWL_REVN_WON_AMT , RNWL_REVN_WON_UNAL_AMT , RNWL_PS_REVN_WON_AMT , RNWL_PS_REVN_WON_UNAL_AMT , RNWL_UNADJ_QUANTITY, RNWL_ITADJ_QUANTITY , RNWL_ITADJ_SUB_QUANTITY, RNWL_SUMADJ_QUANTITY, RNWL_SUMADJ_SUB_QUANTITY, RNWL_PS_UNADJ_QUANTITY, RNWL_PS_ITADJ_QUANTITY, RNWL_PS_SUMADJ_QUANTITY , NEW_REVN_AMT , NEW_REVN_EXPECT_AMT , NEW_UPSIDE_AMT , NEW_DOWNSIDE_AMT , NEW_PRED_REVN_AMT , NEW_ITEM_ADJ_AMT , NEW_BEST_ITEM_ADJ_AMT , NEW_WRST_ITEM_ADJ_AMT , NEW_ITEM_SUBADJ_AMT , NEW_BEST_ITEM_SUBADJ_AMT , NEW_WRST_ITEM_SUBADJ_AMT , NEW_SUM_ADJ_AMT , NEW_BEST_SUM_ADJ_AMT , NEW_WRST_SUM_ADJ_AMT , NEW_SUM_SUBADJ_AMT , NEW_BEST_SUM_SUBADJ_AMT , NEW_WRST_SUM_SUBADJ_AMT , NEW_PS_REVN_AMT , NEW_PS_REVN_EXPECT_AMT , NEW_PS_UPSIDE_AMT , NEW_PS_DOWNSIDE_AMT , NEW_PS_PRED_REVN_AMT , NEW_PS_ITEM_ADJ_AMT , NEW_PS_BEST_ITEM_ADJ_AMT , NEW_PS_WRST_ITEM_ADJ_AMT , NEW_PS_SUM_ADJ_AMT , NEW_PS_BEST_SUM_ADJ_AMT , NEW_PS_WRST_SUM_ADJ_AMT , NEW_REVN_WON_AMT , NEW_REVN_WON_UNAL_AMT , NEW_PS_REVN_WON_AMT , NEW_PS_REVN_WON_UNAL_AMT , NEW_UNADJ_QUANTITY, NEW_ITADJ_QUANTITY , NEW_ITADJ_SUB_QUANTITY, NEW_SUMADJ_QUANTITY, NEW_SUMADJ_SUB_QUANTITY, NEW_PS_UNADJ_QUANTITY, NEW_PS_ITADJ_QUANTITY, NEW_PS_SUMADJ_QUANTITY FROM ZSF_FCST_METRICS MET WHERE MET.BI_METRIC_TYPE = 'BI_TERR_PROD_ADJPER' AND MET.ROOT_PRODUCT_FLAG = 'Y' |