Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: OZF.OZF_ACT_METRIC_FACTS_ALL#

Object Details
Object Name: OZF_ACT_METRIC_FACTS_ALL#
Object Type: VIEW
Owner: OZF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTIVITY_METRIC_FACT_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
ACT_METRIC_USED_BY_ID NUMBER
Yes
ARC_ACT_METRIC_USED_BY VARCHAR2 (30) Yes
VALUE_TYPE VARCHAR2 (30) Yes
ACTIVITY_METRIC_ID NUMBER
Yes
ACTIVITY_GEO_AREA_ID NUMBER

ACTIVITY_PRODUCT_ID NUMBER

TRANSACTION_CURRENCY_CODE VARCHAR2 (15)
TRANS_FORECASTED_VALUE NUMBER (15) Yes
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15) Yes
FUNC_FORECASTED_VALUE NUMBER (15) Yes
ORG_ID NUMBER (32)
DE_METRIC_ID NUMBER
Yes
DE_GEOGRAPHIC_AREA_ID NUMBER

DE_GEOGRAPHIC_AREA_TYPE VARCHAR2 (30)
DE_INVENTORY_ITEM_ID NUMBER (38)
DE_INVENTORY_ITEM_ORG_ID NUMBER (32)
HIERARCHY_ID NUMBER

NODE_ID NUMBER

LEVEL_DEPTH NUMBER (15)
FORMULA_ID NUMBER

FROM_DATE DATE

TO_DATE DATE

FACT_VALUE NUMBER

FACT_PERCENT NUMBER

BASE_QUANTITY NUMBER

FORECAST_REMAINING_QUANTITY NUMBER

FORWARD_BUY_QUANTITY NUMBER

ROOT_FACT_ID NUMBER

PREVIOUS_FACT_ID NUMBER

FACT_TYPE VARCHAR2 (30)
FACT_REFERENCE VARCHAR2 (240)
TIME_ID1 NUMBER
Yes
TIME_ID2 NUMBER

TIME_ID3 NUMBER

TIME_ID4 NUMBER

TIME_ID5 NUMBER

TIME_ID6 NUMBER

TIME_ID7 NUMBER

TIME_ID8 NUMBER

TIME_ID9 NUMBER

TIME_ID10 NUMBER

TIME_ID11 NUMBER

TIME_ID12 NUMBER

TIME_ID13 NUMBER

TIME_ID14 NUMBER

TIME_ID15 NUMBER

TIME_ID16 NUMBER

TIME_ID17 NUMBER

TIME_ID18 NUMBER

TIME_ID19 NUMBER

TIME_ID20 NUMBER

TIME_ID21 NUMBER

TIME_ID22 NUMBER

TIME_ID23 NUMBER

TIME_ID24 NUMBER

TIME_ID25 NUMBER

TIME_ID26 NUMBER

TIME_ID27 NUMBER

TIME_ID28 NUMBER

TIME_ID29 NUMBER

TIME_ID30 NUMBER

TIME_ID31 NUMBER

TIME_ID32 NUMBER

TIME_ID33 NUMBER

TIME_ID34 NUMBER

TIME_ID35 NUMBER

TIME_ID36 NUMBER

TIME_ID37 NUMBER

TIME_ID38 NUMBER

TIME_ID39 NUMBER

TIME_ID40 NUMBER

TIME_ID41 NUMBER

TIME_ID42 NUMBER

TIME_ID43 NUMBER

TIME_ID44 NUMBER

TIME_ID45 NUMBER

TIME_ID46 NUMBER

TIME_ID47 NUMBER

TIME_ID48 NUMBER

TIME_ID49 NUMBER

TIME_ID50 NUMBER

TIME_ID51 NUMBER

TIME_ID52 NUMBER

TIME_ID53 NUMBER

SECURITY_GROUP_ID NUMBER

STATUS_CODE VARCHAR2 (30)
HIERARCHY_TYPE VARCHAR2 (30)
RECOMMEND_TOTAL_AMOUNT NUMBER

APPROVAL_DATE DATE

RECOMMEND_HB_AMOUNT NUMBER

REQUEST_TOTAL_AMOUNT NUMBER

REQUEST_HB_AMOUNT NUMBER

ACTUAL_TOTAL_AMOUNT NUMBER

ACTUAL_HB_AMOUNT NUMBER

BASE_TOTAL_PCT NUMBER

BASE_HB_PCT NUMBER

BASELINE_SALES NUMBER

TPR_PERCENT NUMBER

LIFT_FACTOR NUMBER

INCREMENTAL_SALES NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

OZF.OZF_ACT_METRIC_FACTS_ALL# references the following:

SchemaOZF
TableOZF_ACT_METRIC_FACTS_ALL
OZF.OZF_ACT_METRIC_FACTS_ALL# is referenced by following:

SchemaAPPS
SynonymOZF_ACT_METRIC_FACTS_ALL