VIEW: OZF.OZF_ACT_METRIC_FACTS_ALL#

Source

View Text - Preformatted

select ACTIVITY_METRIC_FACT_ID ACTIVITY_METRIC_FACT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACT_METRIC_USED_BY_ID ACT_METRIC_USED_BY_ID, ARC_ACT_METRIC_USED_BY ARC_ACT_METRIC_USED_BY, VALUE_TYPE VALUE_TYPE, ACTIVITY_METRIC_ID ACTIVITY_METRIC_ID, ACTIVITY_GEO_AREA_ID ACTIVITY_GEO_AREA_ID, ACTIVITY_PRODUCT_ID ACTIVITY_PRODUCT_ID, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE, TRANS_FORECASTED_VALUE TRANS_FORECASTED_VALUE, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, FUNC_FORECASTED_VALUE FUNC_FORECASTED_VALUE, ORG_ID ORG_ID, DE_METRIC_ID DE_METRIC_ID, DE_GEOGRAPHIC_AREA_ID DE_GEOGRAPHIC_AREA_ID, DE_GEOGRAPHIC_AREA_TYPE DE_GEOGRAPHIC_AREA_TYPE, DE_INVENTORY_ITEM_ID DE_INVENTORY_ITEM_ID, DE_INVENTORY_ITEM_ORG_ID DE_INVENTORY_ITEM_ORG_ID, HIERARCHY_ID HIERARCHY_ID, NODE_ID NODE_ID, LEVEL_DEPTH LEVEL_DEPTH, FORMULA_ID FORMULA_ID, FROM_DATE FROM_DATE, TO_DATE TO_DATE, FACT_VALUE FACT_VALUE, FACT_PERCENT FACT_PERCENT, BASE_QUANTITY BASE_QUANTITY, FORECAST_REMAINING_QUANTITY FORECAST_REMAINING_QUANTITY, FORWARD_BUY_QUANTITY FORWARD_BUY_QUANTITY, ROOT_FACT_ID ROOT_FACT_ID, PREVIOUS_FACT_ID PREVIOUS_FACT_ID, FACT_TYPE FACT_TYPE, FACT_REFERENCE FACT_REFERENCE, TIME_ID1 TIME_ID1, TIME_ID2 TIME_ID2, TIME_ID3 TIME_ID3, TIME_ID4 TIME_ID4, TIME_ID5 TIME_ID5, TIME_ID6 TIME_ID6, TIME_ID7 TIME_ID7, TIME_ID8 TIME_ID8, TIME_ID9 TIME_ID9, TIME_ID10 TIME_ID10, TIME_ID11 TIME_ID11, TIME_ID12 TIME_ID12, TIME_ID13 TIME_ID13, TIME_ID14 TIME_ID14, TIME_ID15 TIME_ID15, TIME_ID16 TIME_ID16, TIME_ID17 TIME_ID17, TIME_ID18 TIME_ID18, TIME_ID19 TIME_ID19, TIME_ID20 TIME_ID20, TIME_ID21 TIME_ID21, TIME_ID22 TIME_ID22, TIME_ID23 TIME_ID23, TIME_ID24 TIME_ID24, TIME_ID25 TIME_ID25, TIME_ID26 TIME_ID26, TIME_ID27 TIME_ID27, TIME_ID28 TIME_ID28, TIME_ID29 TIME_ID29, TIME_ID30 TIME_ID30, TIME_ID31 TIME_ID31, TIME_ID32 TIME_ID32, TIME_ID33 TIME_ID33, TIME_ID34 TIME_ID34, TIME_ID35 TIME_ID35, TIME_ID36 TIME_ID36, TIME_ID37 TIME_ID37, TIME_ID38 TIME_ID38, TIME_ID39 TIME_ID39, TIME_ID40 TIME_ID40, TIME_ID41 TIME_ID41, TIME_ID42 TIME_ID42, TIME_ID43 TIME_ID43, TIME_ID44 TIME_ID44, TIME_ID45 TIME_ID45, TIME_ID46 TIME_ID46, TIME_ID47 TIME_ID47, TIME_ID48 TIME_ID48, TIME_ID49 TIME_ID49, TIME_ID50 TIME_ID50, TIME_ID51 TIME_ID51, TIME_ID52 TIME_ID52, TIME_ID53 TIME_ID53, SECURITY_GROUP_ID SECURITY_GROUP_ID, STATUS_CODE STATUS_CODE, HIERARCHY_TYPE HIERARCHY_TYPE, RECOMMEND_TOTAL_AMOUNT RECOMMEND_TOTAL_AMOUNT, APPROVAL_DATE APPROVAL_DATE, RECOMMEND_HB_AMOUNT RECOMMEND_HB_AMOUNT, REQUEST_TOTAL_AMOUNT REQUEST_TOTAL_AMOUNT, REQUEST_HB_AMOUNT REQUEST_HB_AMOUNT, ACTUAL_TOTAL_AMOUNT ACTUAL_TOTAL_AMOUNT, ACTUAL_HB_AMOUNT ACTUAL_HB_AMOUNT, BASE_TOTAL_PCT BASE_TOTAL_PCT, BASE_HB_PCT BASE_HB_PCT, BASELINE_SALES BASELINE_SALES, TPR_PERCENT TPR_PERCENT, LIFT_FACTOR LIFT_FACTOR, INCREMENTAL_SALES INCREMENTAL_SALES from "OZF"."OZF_ACT_METRIC_FACTS_ALL"

View Text - HTML Formatted

SELECT ACTIVITY_METRIC_FACT_ID ACTIVITY_METRIC_FACT_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACT_METRIC_USED_BY_ID ACT_METRIC_USED_BY_ID
, ARC_ACT_METRIC_USED_BY ARC_ACT_METRIC_USED_BY
, VALUE_TYPE VALUE_TYPE
, ACTIVITY_METRIC_ID ACTIVITY_METRIC_ID
, ACTIVITY_GEO_AREA_ID ACTIVITY_GEO_AREA_ID
, ACTIVITY_PRODUCT_ID ACTIVITY_PRODUCT_ID
, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, TRANS_FORECASTED_VALUE TRANS_FORECASTED_VALUE
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, FUNC_FORECASTED_VALUE FUNC_FORECASTED_VALUE
, ORG_ID ORG_ID
, DE_METRIC_ID DE_METRIC_ID
, DE_GEOGRAPHIC_AREA_ID DE_GEOGRAPHIC_AREA_ID
, DE_GEOGRAPHIC_AREA_TYPE DE_GEOGRAPHIC_AREA_TYPE
, DE_INVENTORY_ITEM_ID DE_INVENTORY_ITEM_ID
, DE_INVENTORY_ITEM_ORG_ID DE_INVENTORY_ITEM_ORG_ID
, HIERARCHY_ID HIERARCHY_ID
, NODE_ID NODE_ID
, LEVEL_DEPTH LEVEL_DEPTH
, FORMULA_ID FORMULA_ID
, FROM_DATE FROM_DATE
, TO_DATE TO_DATE
, FACT_VALUE FACT_VALUE
, FACT_PERCENT FACT_PERCENT
, BASE_QUANTITY BASE_QUANTITY
, FORECAST_REMAINING_QUANTITY FORECAST_REMAINING_QUANTITY
, FORWARD_BUY_QUANTITY FORWARD_BUY_QUANTITY
, ROOT_FACT_ID ROOT_FACT_ID
, PREVIOUS_FACT_ID PREVIOUS_FACT_ID
, FACT_TYPE FACT_TYPE
, FACT_REFERENCE FACT_REFERENCE
, TIME_ID1 TIME_ID1
, TIME_ID2 TIME_ID2
, TIME_ID3 TIME_ID3
, TIME_ID4 TIME_ID4
, TIME_ID5 TIME_ID5
, TIME_ID6 TIME_ID6
, TIME_ID7 TIME_ID7
, TIME_ID8 TIME_ID8
, TIME_ID9 TIME_ID9
, TIME_ID10 TIME_ID10
, TIME_ID11 TIME_ID11
, TIME_ID12 TIME_ID12
, TIME_ID13 TIME_ID13
, TIME_ID14 TIME_ID14
, TIME_ID15 TIME_ID15
, TIME_ID16 TIME_ID16
, TIME_ID17 TIME_ID17
, TIME_ID18 TIME_ID18
, TIME_ID19 TIME_ID19
, TIME_ID20 TIME_ID20
, TIME_ID21 TIME_ID21
, TIME_ID22 TIME_ID22
, TIME_ID23 TIME_ID23
, TIME_ID24 TIME_ID24
, TIME_ID25 TIME_ID25
, TIME_ID26 TIME_ID26
, TIME_ID27 TIME_ID27
, TIME_ID28 TIME_ID28
, TIME_ID29 TIME_ID29
, TIME_ID30 TIME_ID30
, TIME_ID31 TIME_ID31
, TIME_ID32 TIME_ID32
, TIME_ID33 TIME_ID33
, TIME_ID34 TIME_ID34
, TIME_ID35 TIME_ID35
, TIME_ID36 TIME_ID36
, TIME_ID37 TIME_ID37
, TIME_ID38 TIME_ID38
, TIME_ID39 TIME_ID39
, TIME_ID40 TIME_ID40
, TIME_ID41 TIME_ID41
, TIME_ID42 TIME_ID42
, TIME_ID43 TIME_ID43
, TIME_ID44 TIME_ID44
, TIME_ID45 TIME_ID45
, TIME_ID46 TIME_ID46
, TIME_ID47 TIME_ID47
, TIME_ID48 TIME_ID48
, TIME_ID49 TIME_ID49
, TIME_ID50 TIME_ID50
, TIME_ID51 TIME_ID51
, TIME_ID52 TIME_ID52
, TIME_ID53 TIME_ID53
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, STATUS_CODE STATUS_CODE
, HIERARCHY_TYPE HIERARCHY_TYPE
, RECOMMEND_TOTAL_AMOUNT RECOMMEND_TOTAL_AMOUNT
, APPROVAL_DATE APPROVAL_DATE
, RECOMMEND_HB_AMOUNT RECOMMEND_HB_AMOUNT
, REQUEST_TOTAL_AMOUNT REQUEST_TOTAL_AMOUNT
, REQUEST_HB_AMOUNT REQUEST_HB_AMOUNT
, ACTUAL_TOTAL_AMOUNT ACTUAL_TOTAL_AMOUNT
, ACTUAL_HB_AMOUNT ACTUAL_HB_AMOUNT
, BASE_TOTAL_PCT BASE_TOTAL_PCT
, BASE_HB_PCT BASE_HB_PCT
, BASELINE_SALES BASELINE_SALES
, TPR_PERCENT TPR_PERCENT
, LIFT_FACTOR LIFT_FACTOR
, INCREMENTAL_SALES INCREMENTAL_SALES
FROM "OZF"."OZF_ACT_METRIC_FACTS_ALL"