eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OZF.OZF_ACT_METRIC_FACTS_ALL

Object Details

Object Name:	OZF_ACT_METRIC_FACTS_ALL
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_ACT_METRIC_FACTS_ALL
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_ACT_METRIC_FACTS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTIVITY_METRIC_FACT_ID
OZF_ACT_METRIC_FACTS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_METRIC_ID
OZF_ACT_METRIC_FACTS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARC_ACT_METRIC_USED_BY ACT_METRIC_USED_BY_ID
OZF_ACT_METRIC_FACTS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DE_GEOGRAPHIC_AREA_ID DE_GEOGRAPHIC_AREA_TYPE
OZF_ACT_METRIC_FACTS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DE_INVENTORY_ITEM_ID DE_INVENTORY_ITEM_ORG_ID
OZF_ACT_METRIC_FACTS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIME_ID1
OZF_ACT_METRIC_FACTS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_GEO_AREA_ID
OZF_ACT_METRIC_FACTS_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_PRODUCT_ID
OZF_ACT_METRIC_FACTS_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORMULA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_METRIC_FACT_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
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			Foreign Key to an Oracle Marketing Hierarchy.
NODE_ID	NUMBER			The Node Identifer on an Oracle Marketing Hierarchy.
LEVEL_DEPTH	NUMBER	(15)		The Node Identifer on an Oracle Marketing Hierarchy.
FORMULA_ID	NUMBER			Foreign Key to the formula used to calculate the result.
FROM_DATE	DATE			The Start date period to restrict metric calculations.
TO_DATE	DATE			The End date period to restrict metric calcaulations.
FACT_VALUE	NUMBER			The Value of the result for the Node in the hierarchy.
FACT_PERCENT	NUMBER			The Percent value for the Node in the hierarchy.
BASE_QUANTITY	NUMBER			Base Quantity of forcasted metric fact
FORECAST_REMAINING_QUANTITY	NUMBER
FORWARD_BUY_QUANTITY	NUMBER
ROOT_FACT_ID	NUMBER			Reference to the first level fact
PREVIOUS_FACT_ID	NUMBER			Reference to the previous fact
FACT_TYPE	VARCHAR2	(30)		Type of the fact
FACT_REFERENCE	VARCHAR2	(240)		Reference about the fact
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			Used in hosted environments
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			Stores 3rd Party Baseline Sales for each fact
TPR_PERCENT	NUMBER			Stores the trade promotion reduction for the product line
LIFT_FACTOR	NUMBER			Stores 3rd Party Lift Factor
INCREMENTAL_SALES	NUMBER			Stores the incremental sales for each fact, due to the lift factor.

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 does not reference any database object

OZF.OZF_ACT_METRIC_FACTS_ALL is referenced by following:

OZF: OZF_ACT_METRIC_FACTS_ALL#