Skip to content

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

VIEW: OZF.OZF_ACT_METRICS_ALL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTIVITY_METRIC_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)
ACT_METRIC_USED_BY_ID NUMBER
Yes
ARC_ACT_METRIC_USED_BY VARCHAR2 (30) Yes
PURCHASE_REQ_RAISED_FLAG VARCHAR2 (1)
APPLICATION_ID NUMBER
Yes
SENSITIVE_DATA_FLAG VARCHAR2 (1) Yes
BUDGET_ID NUMBER

METRIC_ID NUMBER
Yes
TRANSACTION_CURRENCY_CODE VARCHAR2 (15)
TRANS_FORECASTED_VALUE NUMBER

TRANS_COMMITTED_VALUE NUMBER

TRANS_ACTUAL_VALUE NUMBER

FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
FUNC_FORECASTED_VALUE NUMBER

FUNC_COMMITTED_VALUE NUMBER

FUNC_ACTUAL_VALUE NUMBER

DIRTY_FLAG VARCHAR2 (1) Yes
LAST_CALCULATED_DATE DATE

VARIABLE_VALUE NUMBER

FORECASTED_VARIABLE_VALUE NUMBER

COMPUTED_USING_FUNCTION_VALUE NUMBER

METRIC_UOM_CODE VARCHAR2 (3)
ORG_ID NUMBER (32)
DIFFERENCE_SINCE_LAST_CALC NUMBER

ACTIVITY_METRIC_ORIGIN_ID NUMBER

ARC_ACTIVITY_METRIC_ORIGIN VARCHAR2 (30)
DAYS_SINCE_LAST_REFRESH NUMBER (15)
SCENARIO_ID NUMBER

SUMMARIZE_TO_METRIC NUMBER

ROLLUP_TO_METRIC NUMBER

HIERARCHY_ID NUMBER

START_NODE NUMBER

FROM_LEVEL NUMBER

TO_LEVEL NUMBER

FROM_DATE DATE

TO_DATE DATE

AMOUNT1 NUMBER

AMOUNT2 NUMBER

AMOUNT3 NUMBER

PERCENT1 NUMBER (3)
PERCENT2 NUMBER (3)
PERCENT3 NUMBER (3)
PUBLISHED_FLAG VARCHAR2 (1)
PRE_FUNCTION_NAME VARCHAR2 (4000)
POST_FUNCTION_NAME VARCHAR2 (4000)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER

DESCRIPTION VARCHAR2 (4000)
ACT_METRIC_DATE DATE

DEPEND_ACT_METRIC NUMBER

FUNCTION_USED_BY_ID NUMBER

ARC_FUNCTION_USED_BY VARCHAR2 (30)
STATUS_CODE VARCHAR2 (30)
ACTION_CODE VARCHAR2 (30)
METHOD_CODE VARCHAR2 (30)
BASIS_YEAR NUMBER

EX_START_NODE VARCHAR2 (1)
HIERARCHY_TYPE VARCHAR2 (30)
START_PERIOD_NAME VARCHAR2 (30)
END_PERIOD_NAME VARCHAR2 (30)
PRODUCT_SPREAD_TIME_ID NUMBER

Query Text

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


SELECT ACTIVITY_METRIC_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
,      PURCHASE_REQ_RAISED_FLAG
,      APPLICATION_ID
,      SENSITIVE_DATA_FLAG
,      BUDGET_ID
,      METRIC_ID
,      TRANSACTION_CURRENCY_CODE
,      TRANS_FORECASTED_VALUE
,      TRANS_COMMITTED_VALUE
,      TRANS_ACTUAL_VALUE
,      FUNCTIONAL_CURRENCY_CODE
,      FUNC_FORECASTED_VALUE
,      FUNC_COMMITTED_VALUE
,      FUNC_ACTUAL_VALUE
,      DIRTY_FLAG
,      LAST_CALCULATED_DATE
,      VARIABLE_VALUE
,      FORECASTED_VARIABLE_VALUE
,      COMPUTED_USING_FUNCTION_VALUE
,      METRIC_UOM_CODE
,      ORG_ID
,      DIFFERENCE_SINCE_LAST_CALC
,      ACTIVITY_METRIC_ORIGIN_ID
,      ARC_ACTIVITY_METRIC_ORIGIN
,      DAYS_SINCE_LAST_REFRESH
,      SCENARIO_ID
,      SUMMARIZE_TO_METRIC
,      ROLLUP_TO_METRIC
,      HIERARCHY_ID
,      START_NODE
,      FROM_LEVEL
,      TO_LEVEL
,      FROM_DATE
,      TO_DATE
,      AMOUNT1
,      AMOUNT2
,      AMOUNT3
,      PERCENT1
,      PERCENT2
,      PERCENT3
,      PUBLISHED_FLAG
,      PRE_FUNCTION_NAME
,      POST_FUNCTION_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      DESCRIPTION
,      ACT_METRIC_DATE
,      DEPEND_ACT_METRIC
,      FUNCTION_USED_BY_ID
,      ARC_FUNCTION_USED_BY
,      STATUS_CODE
,      ACTION_CODE
,      METHOD_CODE
,      BASIS_YEAR
,      EX_START_NODE
,      HIERARCHY_TYPE
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      PRODUCT_SPREAD_TIME_ID
FROM OZF.OZF_ACT_METRICS_ALL#;

Dependencies

[top of page]

OZF.OZF_ACT_METRICS_ALL# references the following:

SchemaOZF
TableOZF_ACT_METRICS_ALL
OZF.OZF_ACT_METRICS_ALL# is referenced by following:

SchemaAPPS
SynonymOZF_ACT_METRICS_ALL