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.EGO_FINANCIAL_REPORTING_AGV

Object Details

Object Name:	EGO_FINANCIAL_REPORTING_AGV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_FINANCIAL_REPORTING_AGV
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CATEGORY_SET_ID	NUMBER	(15)	Yes	This is one of the primary keys for category; Foriegn key to MTL_CATEGORY_SETS_B
CATEGORY_ID	NUMBER	(15)		This is one of the primary keys for category; Foriegn key to MTL_CATEGORIES_B
TOP_NODE	NUMBER	(15)		This column stores the category whose children and grand-children are to be propagated
VALUE_ID	NUMBER	(15)		This column stores the corresponding value-id in the value-set
FLEX_VALUE_SET_ID	NUMBER	(15)		This column stores the value set id for the top node

Query Text

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


SELECT CATEGORY_SET_ID
,      CATEGORY_ID
,      TOP_NODE
,      VALUE_ID
,      FLEX_VALUE_SET_ID
FROM APPS.EGO_FINANCIAL_REPORTING_AGV;

Dependencies

[top of page]

APPS.EGO_FINANCIAL_REPORTING_AGV references the following:

APPS: EGO_FND_DSC_FLX_CTX_EXT; EGO_PRODUCT_CAT_SET_EXT

APPS.EGO_FINANCIAL_REPORTING_AGV is referenced by following:

APPS: ENI_PROD_VALUESET - show dependent code