ZSF_FCST_METRICS_TXN_TERR_V
Details
-
Schema: FUSION
-
Object owner: ZSF
-
Object type: VIEW
Columns
Name |
---|
BI_METRIC_TYPE FCST_HEADER_ID FCST_METRICS_PARTITION_KEY ADJUST_PERIOD_ID ROOT_PRODUCT_FLAG FCST_TERRITORY_ID FCST_PARTICIPANT_ID UNALLOCATED_ADJUSTMENT_FLAG CORP_REVN_AMT CORP_UPSIDE_AMT CORP_DOWNSIDE_AMT CORP_REVN_EXPECT_AMT CORP_PRED_REVN_AMT UNADJ_QUANTITY CORP_ITEM_ADJ_AMT CORP_BEST_ITEM_ADJ_AMT CORP_WRST_ITEM_ADJ_AMT ITADJ_QUANTITY CORP_SUM_ADJ_AMT CORP_BEST_SUM_ADJ_AMT CORP_WRST_SUM_ADJ_AMT SUMADJ_QUANTITY CORP_PS_REVN_AMT CORP_PS_UPSIDE_AMT CORP_PS_DOWNSIDE_AMT CORP_PS_REVN_EXPECT_AMT CORP_PS_PRED_REVN_AMT PS_UNADJ_QUANTITY CORP_PS_ITEM_ADJ_AMT CORP_PS_BEST_ITEM_ADJ_AMT CORP_PS_WRST_ITEM_ADJ_AMT PS_ITADJ_QUANTITY CORP_PS_SUM_ADJ_AMT CORP_PS_BEST_SUM_ADJ_AMT CORP_PS_WRST_SUM_ADJ_AMT PS_SUMADJ_QUANTITY CORP_ITEM_SUBADJ_AMT CORP_BEST_ITEM_SUBADJ_AMT CORP_WRST_ITEM_SUBADJ_AMT ITADJ_SUB_QUANTITY CORP_SUM_SUBADJ_AMT CORP_BEST_SUM_SUBADJ_AMT CORP_WRST_SUM_SUBADJ_AMT SUMADJ_SUB_QUANTITY 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_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_SUMADJ_MET_1 CORP_EXTN_SUMADJ_MET_2 CORP_EXTN_SUMADJ_MET_3 CORP_EXTN_SUMADJ_MET_4 CORP_EXTN_SUMADJ_MET_5 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_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_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_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_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_REVN_WON_AMT CORP_REVN_WON_UNAL_AMT CORP_PS_REVN_WON_AMT CORP_PS_REVN_WON_UNAL_AMT CORP_REVN_OPEN_AMT CORP_REVN_OPEN_UNAL_AMT CORP_PS_REVN_OPEN_AMT CORP_PS_REVN_OPEN_UNAL_AMT RNWL_REVN_AMT RNWL_UPSIDE_AMT RNWL_DOWNSIDE_AMT RNWL_REVN_EXPECT_AMT RNWL_PRED_REVN_AMT RNWL_UNADJ_QUANTITY RNWL_ITEM_ADJ_AMT RNWL_BEST_ITEM_ADJ_AMT RNWL_WRST_ITEM_ADJ_AMT RNWL_ITADJ_QUANTITY RNWL_SUM_ADJ_AMT RNWL_BEST_SUM_ADJ_AMT RNWL_WRST_SUM_ADJ_AMT RNWL_SUMADJ_QUANTITY RNWL_PS_REVN_AMT RNWL_PS_UPSIDE_AMT RNWL_PS_DOWNSIDE_AMT RNWL_PS_REVN_EXPECT_AMT RNWL_PS_PRED_REVN_AMT RNWL_PS_UNADJ_QUANTITY RNWL_PS_ITEM_ADJ_AMT RNWL_PS_BEST_ITEM_ADJ_AMT RNWL_PS_WRST_ITEM_ADJ_AMT RNWL_PS_ITADJ_QUANTITY RNWL_PS_SUM_ADJ_AMT RNWL_PS_BEST_SUM_ADJ_AMT RNWL_PS_WRST_SUM_ADJ_AMT RNWL_PS_SUMADJ_QUANTITY RNWL_ITEM_SUBADJ_AMT RNWL_BEST_ITEM_SUBADJ_AMT RNWL_WRST_ITEM_SUBADJ_AMT RNWL_ITADJ_SUB_QUANTITY RNWL_SUM_SUBADJ_AMT RNWL_BEST_SUM_SUBADJ_AMT RNWL_WRST_SUM_SUBADJ_AMT RNWL_SUMADJ_SUB_QUANTITY RNWL_REVN_WON_AMT RNWL_REVN_WON_UNAL_AMT RNWL_PS_REVN_WON_AMT RNWL_PS_REVN_WON_UNAL_AMT RNWL_REVN_OPEN_AMT RNWL_REVN_OPEN_UNAL_AMT RNWL_PS_REVN_OPEN_AMT RNWL_PS_REVN_OPEN_UNAL_AMT NEW_REVN_AMT NEW_UPSIDE_AMT NEW_DOWNSIDE_AMT NEW_REVN_EXPECT_AMT NEW_PRED_REVN_AMT NEW_UNADJ_QUANTITY NEW_ITEM_ADJ_AMT NEW_BEST_ITEM_ADJ_AMT NEW_WRST_ITEM_ADJ_AMT NEW_ITADJ_QUANTITY NEW_SUM_ADJ_AMT NEW_BEST_SUM_ADJ_AMT NEW_WRST_SUM_ADJ_AMT NEW_SUMADJ_QUANTITY NEW_PS_REVN_AMT NEW_PS_UPSIDE_AMT NEW_PS_DOWNSIDE_AMT NEW_PS_REVN_EXPECT_AMT NEW_PS_PRED_REVN_AMT NEW_PS_UNADJ_QUANTITY NEW_PS_ITEM_ADJ_AMT NEW_PS_BEST_ITEM_ADJ_AMT NEW_PS_WRST_ITEM_ADJ_AMT NEW_PS_ITADJ_QUANTITY NEW_PS_SUM_ADJ_AMT NEW_PS_BEST_SUM_ADJ_AMT NEW_PS_WRST_SUM_ADJ_AMT NEW_PS_SUMADJ_QUANTITY NEW_ITEM_SUBADJ_AMT NEW_BEST_ITEM_SUBADJ_AMT NEW_WRST_ITEM_SUBADJ_AMT NEW_ITADJ_SUB_QUANTITY NEW_SUM_SUBADJ_AMT NEW_BEST_SUM_SUBADJ_AMT NEW_WRST_SUM_SUBADJ_AMT NEW_SUMADJ_SUB_QUANTITY NEW_REVN_WON_AMT NEW_REVN_WON_UNAL_AMT NEW_PS_REVN_WON_AMT NEW_PS_REVN_WON_UNAL_AMT NEW_REVN_OPEN_AMT NEW_REVN_OPEN_UNAL_AMT NEW_PS_REVN_OPEN_AMT NEW_PS_REVN_OPEN_UNAL_AMT CREATION_DATE LAST_UPDATE_DATE CREATED_BY LAST_UPDATED_BY CORP_CURR_CODE TERR_HIER_FREEZE_DATE PERIOD_SET_NAME PERIOD_NAME |
Query
SQL_Statement |
---|
SELECT FACTS.BI_METRIC_TYPE, FACTS.FCST_HEADER_ID, FACTS.FCST_METRICS_PARTITION_KEY, FACTS.ADJUST_PERIOD_ID, FACTS.ROOT_PRODUCT_FLAG, PART.TERRITORY_ID FCST_TERRITORY_ID, PART.FCST_PARTICIPANT_ID, NVL(FACTS.UNALLOCATED_ADJUSTMENT_FLAG,'N') UNALLOCATED_ADJUSTMENT_FLAG, (CORP_REVN_AMT) CORP_REVN_AMT, (CORP_UPSIDE_AMT) CORP_UPSIDE_AMT, (CORP_DOWNSIDE_AMT) CORP_DOWNSIDE_AMT, (CORP_REVN_EXPECT_AMT) CORP_REVN_EXPECT_AMT, (CORP_PRED_REVN_AMT) CORP_PRED_REVN_AMT, (UNADJ_QUANTITY) UNADJ_QUANTITY, (CORP_ITEM_ADJ_AMT) CORP_ITEM_ADJ_AMT, (CORP_BEST_ITEM_ADJ_AMT) CORP_BEST_ITEM_ADJ_AMT, (CORP_WRST_ITEM_ADJ_AMT) CORP_WRST_ITEM_ADJ_AMT, (ITADJ_QUANTITY) ITADJ_QUANTITY, (CORP_SUM_ADJ_AMT) CORP_SUM_ADJ_AMT, (CORP_BEST_SUM_ADJ_AMT) CORP_BEST_SUM_ADJ_AMT, (CORP_WRST_SUM_ADJ_AMT) CORP_WRST_SUM_ADJ_AMT, (SUMADJ_QUANTITY) SUMADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_REVN_AMT,0)) CORP_PS_REVN_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_UPSIDE_AMT,0)) CORP_PS_UPSIDE_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_DOWNSIDE_AMT,0)) CORP_PS_DOWNSIDE_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_REVN_EXPECT_AMT,0)) CORP_PS_REVN_EXPECT_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_PRED_REVN_AMT,0)) CORP_PS_PRED_REVN_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,UNADJ_QUANTITY,0)) PS_UNADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_ITEM_ADJ_AMT,0)) CORP_PS_ITEM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_BEST_ITEM_ADJ_AMT,0)) CORP_PS_BEST_ITEM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_WRST_ITEM_ADJ_AMT,0)) CORP_PS_WRST_ITEM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,ITADJ_QUANTITY,0)) PS_ITADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_SUM_ADJ_AMT,0)) CORP_PS_SUM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_BEST_SUM_ADJ_AMT,0)) CORP_PS_BEST_SUM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_WRST_SUM_ADJ_AMT,0)) CORP_PS_WRST_SUM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,SUMADJ_QUANTITY,0)) PS_SUMADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_ITEM_ADJ_AMT)) CORP_ITEM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_BEST_ITEM_ADJ_AMT)) CORP_BEST_ITEM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_WRST_ITEM_ADJ_AMT)) CORP_WRST_ITEM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,ITADJ_QUANTITY)) ITADJ_SUB_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_SUM_ADJ_AMT)) CORP_SUM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_BEST_SUM_ADJ_AMT)) CORP_BEST_SUM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_WRST_SUM_ADJ_AMT)) CORP_WRST_SUM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,SUMADJ_QUANTITY)) SUMADJ_SUB_QUANTITY, (CORP_EXTN_UNADJ_MET_1) CORP_EXTN_UNADJ_MET_1, (CORP_EXTN_UNADJ_MET_2) CORP_EXTN_UNADJ_MET_2, (CORP_EXTN_UNADJ_MET_3) CORP_EXTN_UNADJ_MET_3, (CORP_EXTN_UNADJ_MET_4) CORP_EXTN_UNADJ_MET_4, (CORP_EXTN_UNADJ_MET_5) CORP_EXTN_UNADJ_MET_5, (CORP_EXTN_ITADJ_MET_1) CORP_EXTN_ITADJ_MET_1, (CORP_EXTN_ITADJ_MET_2) CORP_EXTN_ITADJ_MET_2, (CORP_EXTN_ITADJ_MET_3) CORP_EXTN_ITADJ_MET_3, (CORP_EXTN_ITADJ_MET_4) CORP_EXTN_ITADJ_MET_4, (CORP_EXTN_ITADJ_MET_5) CORP_EXTN_ITADJ_MET_5, (CORP_EXTN_SUMADJ_MET_1) CORP_EXTN_SUMADJ_MET_1, (CORP_EXTN_SUMADJ_MET_2) CORP_EXTN_SUMADJ_MET_2, (CORP_EXTN_SUMADJ_MET_3) CORP_EXTN_SUMADJ_MET_3, (CORP_EXTN_SUMADJ_MET_4) CORP_EXTN_SUMADJ_MET_4, (CORP_EXTN_SUMADJ_MET_5) CORP_EXTN_SUMADJ_MET_5, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_UNADJ_MET_1,0)) CORP_PS_EXTN_UNADJ_MET_1, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_UNADJ_MET_2,0)) CORP_PS_EXTN_UNADJ_MET_2, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_UNADJ_MET_3,0)) CORP_PS_EXTN_UNADJ_MET_3, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_UNADJ_MET_4,0)) CORP_PS_EXTN_UNADJ_MET_4, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_UNADJ_MET_5,0)) CORP_PS_EXTN_UNADJ_MET_5, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_ITADJ_MET_1,0)) CORP_PS_EXTN_ITADJ_MET_1, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_ITADJ_MET_2,0)) CORP_PS_EXTN_ITADJ_MET_2, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_ITADJ_MET_3,0)) CORP_PS_EXTN_ITADJ_MET_3, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_ITADJ_MET_4,0)) CORP_PS_EXTN_ITADJ_MET_4, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_ITADJ_MET_5,0)) CORP_PS_EXTN_ITADJ_MET_5, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_SUMADJ_MET_1,0)) CORP_PS_EXTN_SUMADJ_MET_1, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_SUMADJ_MET_2,0)) CORP_PS_EXTN_SUMADJ_MET_2, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_SUMADJ_MET_3,0)) CORP_PS_EXTN_SUMADJ_MET_3, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_SUMADJ_MET_4,0)) CORP_PS_EXTN_SUMADJ_MET_4, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,CORP_EXTN_SUMADJ_MET_5,0)) CORP_PS_EXTN_SUMADJ_MET_5, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_EXTN_ITADJ_MET_1)) CORP_EXTN_ITADJ_SUB_1, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_EXTN_ITADJ_MET_2)) CORP_EXTN_ITADJ_SUB_2, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_EXTN_ITADJ_MET_3)) CORP_EXTN_ITADJ_SUB_3, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_EXTN_ITADJ_MET_4)) CORP_EXTN_ITADJ_SUB_4, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_EXTN_ITADJ_MET_5)) CORP_EXTN_ITADJ_SUB_5, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_EXTN_SUMADJ_MET_1)) CORP_EXTN_SUMADJ_SUB_1, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_EXTN_SUMADJ_MET_2)) CORP_EXTN_SUMADJ_SUB_2, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_EXTN_SUMADJ_MET_3)) CORP_EXTN_SUMADJ_SUB_3, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_EXTN_SUMADJ_MET_4)) CORP_EXTN_SUMADJ_SUB_4, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,CORP_EXTN_SUMADJ_MET_5)) CORP_EXTN_SUMADJ_SUB_5, (NVL(CORP_REVN_WON_AMT,0)) CORP_REVN_WON_AMT, NULL CORP_REVN_WON_UNAL_AMT, (DECODE(TDN.TERRITORY_ID, FACTS.FCST_ADJUSTED_TERR_ID, CORP_REVN_WON_AMT,0)) CORP_PS_REVN_WON_AMT, NULL CORP_PS_REVN_WON_UNAL_AMT, (NVL(CORP_REVN_AMT, 0) - NVL(CORP_REVN_WON_AMT, 0)) CORP_REVN_OPEN_AMT, NULL CORP_REVN_OPEN_UNAL_AMT, (DECODE(TDN.TERRITORY_ID, FACTS.FCST_ADJUSTED_TERR_ID, NVL(CORP_REVN_AMT, 0) - NVL(CORP_REVN_WON_AMT,0),0)) CORP_PS_REVN_OPEN_AMT, NULL CORP_PS_REVN_OPEN_UNAL_AMT, (RNWL_REVN_AMT) RNWL_REVN_AMT, (RNWL_UPSIDE_AMT) RNWL_UPSIDE_AMT, (RNWL_DOWNSIDE_AMT) RNWL_DOWNSIDE_AMT, (RNWL_REVN_EXPECT_AMT) RNWL_REVN_EXPECT_AMT, (RNWL_PRED_REVN_AMT) RNWL_PRED_REVN_AMT, (RNWL_UNADJ_QUANTITY) RNWL_UNADJ_QUANTITY, (RNWL_ITEM_ADJ_AMT) RNWL_ITEM_ADJ_AMT, (RNWL_BEST_ITEM_ADJ_AMT) RNWL_BEST_ITEM_ADJ_AMT, (RNWL_WRST_ITEM_ADJ_AMT) RNWL_WRST_ITEM_ADJ_AMT, (RNWL_ITADJ_QUANTITY) RNWL_ITADJ_QUANTITY, (RNWL_SUM_ADJ_AMT) RNWL_SUM_ADJ_AMT, (RNWL_BEST_SUM_ADJ_AMT) RNWL_BEST_SUM_ADJ_AMT, (RNWL_WRST_SUM_ADJ_AMT) RNWL_WRST_SUM_ADJ_AMT, (RNWL_SUMADJ_QUANTITY) RNWL_SUMADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_REVN_AMT,0)) RNWL_PS_REVN_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_UPSIDE_AMT,0)) RNWL_PS_UPSIDE_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_DOWNSIDE_AMT,0)) RNWL_PS_DOWNSIDE_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_REVN_EXPECT_AMT,0)) RNWL_PS_REVN_EXPECT_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_PRED_REVN_AMT,0)) RNWL_PS_PRED_REVN_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_UNADJ_QUANTITY,0)) RNWL_PS_UNADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_ITEM_ADJ_AMT,0)) RNWL_PS_ITEM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_BEST_ITEM_ADJ_AMT,0)) RNWL_PS_BEST_ITEM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_WRST_ITEM_ADJ_AMT,0)) RNWL_PS_WRST_ITEM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_ITADJ_QUANTITY,0)) RNWL_PS_ITADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_SUM_ADJ_AMT,0)) RNWL_PS_SUM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_BEST_SUM_ADJ_AMT,0)) RNWL_PS_BEST_SUM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_WRST_SUM_ADJ_AMT,0)) RNWL_PS_WRST_SUM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,RNWL_SUMADJ_QUANTITY,0)) RNWL_PS_SUMADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,RNWL_ITEM_ADJ_AMT)) RNWL_ITEM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,RNWL_BEST_ITEM_ADJ_AMT)) RNWL_BEST_ITEM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,RNWL_WRST_ITEM_ADJ_AMT)) RNWL_WRST_ITEM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,RNWL_ITADJ_QUANTITY)) RNWL_ITADJ_SUB_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,RNWL_SUM_ADJ_AMT)) RNWL_SUM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,RNWL_BEST_SUM_ADJ_AMT)) RNWL_BEST_SUM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,RNWL_WRST_SUM_ADJ_AMT)) RNWL_WRST_SUM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,RNWL_SUMADJ_QUANTITY)) RNWL_SUMADJ_SUB_QUANTITY, (NVL(RNWL_REVN_WON_AMT,0)) RNWL_REVN_WON_AMT, NULL RNWL_REVN_WON_UNAL_AMT, (DECODE(TDN.TERRITORY_ID, FACTS.FCST_ADJUSTED_TERR_ID, RNWL_REVN_WON_AMT,0)) RNWL_PS_REVN_WON_AMT, NULL RNWL_PS_REVN_WON_UNAL_AMT, (NVL(RNWL_REVN_AMT, 0) - NVL(RNWL_REVN_WON_AMT, 0)) RNWL_REVN_OPEN_AMT, NULL RNWL_REVN_OPEN_UNAL_AMT, (DECODE(TDN.TERRITORY_ID, FACTS.FCST_ADJUSTED_TERR_ID, NVL(RNWL_REVN_AMT, 0) - NVL(RNWL_REVN_WON_AMT,0),0)) RNWL_PS_REVN_OPEN_AMT, NULL RNWL_PS_REVN_OPEN_UNAL_AMT, (NEW_REVN_AMT) NEW_REVN_AMT, (NEW_UPSIDE_AMT) NEW_UPSIDE_AMT, (NEW_DOWNSIDE_AMT) NEW_DOWNSIDE_AMT, (NEW_REVN_EXPECT_AMT) NEW_REVN_EXPECT_AMT, (NEW_PRED_REVN_AMT) NEW_PRED_REVN_AMT, (NEW_UNADJ_QUANTITY) NEW_UNADJ_QUANTITY, (NEW_ITEM_ADJ_AMT) NEW_ITEM_ADJ_AMT, (NEW_BEST_ITEM_ADJ_AMT) NEW_BEST_ITEM_ADJ_AMT, (NEW_WRST_ITEM_ADJ_AMT) NEW_WRST_ITEM_ADJ_AMT, (NEW_ITADJ_QUANTITY) NEW_ITADJ_QUANTITY, (NEW_SUM_ADJ_AMT) NEW_SUM_ADJ_AMT, (NEW_BEST_SUM_ADJ_AMT) NEW_BEST_SUM_ADJ_AMT, (NEW_WRST_SUM_ADJ_AMT) NEW_WRST_SUM_ADJ_AMT, (NEW_SUMADJ_QUANTITY) NEW_SUMADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_REVN_AMT,0)) NEW_PS_REVN_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_UPSIDE_AMT,0)) NEW_PS_UPSIDE_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_DOWNSIDE_AMT,0)) NEW_PS_DOWNSIDE_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_REVN_EXPECT_AMT,0)) NEW_PS_REVN_EXPECT_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_PRED_REVN_AMT,0)) NEW_PS_PRED_REVN_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_UNADJ_QUANTITY,0)) NEW_PS_UNADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_ITEM_ADJ_AMT,0)) NEW_PS_ITEM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_BEST_ITEM_ADJ_AMT,0)) NEW_PS_BEST_ITEM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_WRST_ITEM_ADJ_AMT,0)) NEW_PS_WRST_ITEM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_ITADJ_QUANTITY,0)) NEW_PS_ITADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_SUM_ADJ_AMT,0)) NEW_PS_SUM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_BEST_SUM_ADJ_AMT,0)) NEW_PS_BEST_SUM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_WRST_SUM_ADJ_AMT,0)) NEW_PS_WRST_SUM_ADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_ADJUSTED_TERR_ID,NEW_SUMADJ_QUANTITY,0)) NEW_PS_SUMADJ_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,NEW_ITEM_ADJ_AMT)) NEW_ITEM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,NEW_BEST_ITEM_ADJ_AMT)) NEW_BEST_ITEM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,NEW_WRST_ITEM_ADJ_AMT)) NEW_WRST_ITEM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,NEW_ITADJ_QUANTITY)) NEW_ITADJ_SUB_QUANTITY, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,NEW_SUM_ADJ_AMT)) NEW_SUM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,NEW_BEST_SUM_ADJ_AMT)) NEW_BEST_SUM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,NEW_WRST_SUM_ADJ_AMT)) NEW_WRST_SUM_SUBADJ_AMT, (DECODE(TDN.TERRITORY_ID,FACTS.FCST_TERRITORY_ID,0,NEW_SUMADJ_QUANTITY)) NEW_SUMADJ_SUB_QUANTITY, (NVL(NEW_REVN_WON_AMT,0)) NEW_REVN_WON_AMT, NULL NEW_REVN_WON_UNAL_AMT, (DECODE(TDN.TERRITORY_ID, FACTS.FCST_ADJUSTED_TERR_ID, NEW_REVN_WON_AMT,0)) NEW_PS_REVN_WON_AMT, NULL NEW_PS_REVN_WON_UNAL_AMT, (NVL(NEW_REVN_AMT, 0) - NVL(NEW_REVN_WON_AMT, 0)) NEW_REVN_OPEN_AMT, NULL NEW_REVN_OPEN_UNAL_AMT, (DECODE(TDN.TERRITORY_ID, FACTS.FCST_ADJUSTED_TERR_ID, NVL(NEW_REVN_AMT, 0) - NVL(NEW_REVN_WON_AMT,0),0)) NEW_PS_REVN_OPEN_AMT, NULL NEW_PS_REVN_OPEN_UNAL_AMT, FACTS.CREATION_DATE, FACTS.LAST_UPDATE_DATE, FACTS.CREATED_BY, FACTS.LAST_UPDATED_BY, H.CORP_CURR_CODE, H.TERR_HIER_FREEZE_DATE, AP.PERIOD_SET_NAME, AP.PERIOD_NAME FROM ZSF_FCST_METRICS_TXN FACTS , ZSF_FCST_HEADER H , ZSF_FCST_TERR_HIER_DN TDN, ZSF_FCST_PARTICIPANT PART, ZSF_FCST_ADJUST_PERIOD AP WHERE FACTS.FCST_HEADER_ID = H.FCST_HEADER_ID AND H.DENORM_VERSION_ID = TDN.DENORM_VERSION_ID AND FACTS.FCST_TERRITORY_ID = TDN.DESCENDANT_TERRITORY_ID AND TDN.TERRITORY_ID = PART.TERRITORY_ID AND FACTS.FCST_HEADER_ID = PART.FCST_HEADER_ID AND FACTS.ADJUST_PERIOD_ID = AP.FCST_ADJUST_PERIOD_ID AND PART.MANAGER_TERRITORY_FLAG = 'N' |