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]

VIEW: APPS.OZF_FUND_ALLOCTREE_V

Object Details

Object Name:	OZF_FUND_ALLOCTREE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OZF.OZF_FUND_ALLOCTREE_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ALLOCATION_FACT_ID	NUMBER		Yes
HOLDBACK_FACT_ID	NUMBER		Yes
ACT_METRIC_USED_BY_ID	NUMBER		Yes
ACTIVITY_METRIC_ID	NUMBER		Yes
ALLOCATION_FORMULA_ID	NUMBER
HOLDBACK_FORMULA_ID	NUMBER
ALLOCATION_AMOUNT	NUMBER
HOLDBACK_AMOUNT	NUMBER
ALLOCATION_VERSION_NUMBER	NUMBER	(9)	Yes
HOLDBACK_VERSION_NUMBER	NUMBER	(9)	Yes
HIERARCHY_ID	NUMBER
LEVEL_DEPTH	NUMBER	(15)
NODE_ID	NUMBER
NODE_VALUE	VARCHAR2	(2000)	Yes
PARENT_NODE_ID	VARCHAR2	(40)

Query Text

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


SELECT ALLOCATION_FACT_ID
,      HOLDBACK_FACT_ID
,      ACT_METRIC_USED_BY_ID
,      ACTIVITY_METRIC_ID
,      ALLOCATION_FORMULA_ID
,      HOLDBACK_FORMULA_ID
,      ALLOCATION_AMOUNT
,      HOLDBACK_AMOUNT
,      ALLOCATION_VERSION_NUMBER
,      HOLDBACK_VERSION_NUMBER
,      HIERARCHY_ID
,      LEVEL_DEPTH
,      NODE_ID
,      NODE_VALUE
,      PARENT_NODE_ID
FROM APPS.OZF_FUND_ALLOCTREE_V;

Dependencies

[top of page]

APPS.OZF_FUND_ALLOCTREE_V references the following:

APPS: AMS_ACT_METRICS_ALL; AMS_ACT_METRIC_FACTS_ALL; AMS_ACT_METRIC_FORMULAS; AMS_TERR_V

APPS.OZF_FUND_ALLOCTREE_V is not referenced by any database object