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

Object Details

Object Name:	FEM_BR_DIS_MBR_HIER_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Information on Hierarchy rules that contain references to disabled dimension presented in a manner to allow hierarchical reporting, including runtime parameters

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)	Yes	Unique ID to differentiate each execution of the "Check Mapping Rules for Disabled Dimension Members" Concurrent Program. This is the same number as the concurrent request ID.
REQUEST_DATE	DATE		Yes	Execution date of the concurrent program
REQUEST_NAME	VARCHAR2	(100)	Yes	Execution name given for each execution for the concurrent program
PARAM_OBJECT_TYPE_CODE	VARCHAR2	(30)	Yes	Rule type code parameter
PARAM_OBJECT_TYPE_NAME	VARCHAR2	(150)	Yes	Rule type name parameter
PARAM_LEDGER_ID	NUMBER		Yes	Ledger ID parameter
PARAM_LEDGER_NAME	VARCHAR2	(150)	Yes	Ledger name parameter
PARAM_EFFECTIVE_DATE	DATE		Yes	Effective date parameter
PARAM_OBJECT_ID	NUMBER	(9)		Rule ID parameter
PARAM_OBJECT_NAME	VARCHAR2	(150)		Rule name parameter
PARAM_FOLDER_ID	NUMBER	(9)		Folder ID parameter
PARAM_FOLDER_NAME	VARCHAR2	(150)		Folder name parameter
PARAM_DIMENSION_ID	NUMBER			Dimension ID parameter
PARAM_DIMENSION_NAME	VARCHAR2	(150)		Dimension name parameter
HIERARCHY_OBJECT_ID	NUMBER	(9)	Yes	Hierarchy rule ID
HIERARCHY_OBJECT_NAME	VARCHAR2	(150)	Yes	Hierarchy rule name
HIERARCHY_OBJ_DEF_ID	NUMBER	(9)	Yes	Hierarchy rule version ID
HIERARCHY_OBJ_DEF_NAME	VARCHAR2	(150)	Yes	Hierarchy rule version name
PARENT_MEMBER_ID	NUMBER		Yes	ID of the parent node
PARENT_DISPLAY_CODE	VARCHAR2	(150)	Yes	Display code of the parent node
PARENT_NAME	VARCHAR2	(150)	Yes	Parent node name
PARENT_VALUE_SET_ID	NUMBER			ID of the Value Set in which the parent node resides
PARENT_VALUE_SET_NAME	VARCHAR2	(150)		Name of the Value Set in which the parent node resides
CHILD_MEMBER_ID	NUMBER		Yes	ID of the child node
CHILD_DISPLAY_CODE	VARCHAR2	(150)	Yes	Display code of the child node
CHILD_NAME	VARCHAR2	(150)	Yes	Child node name
CHILD_VALUE_SET_ID	NUMBER			ID of the Value Set in which the child node resides
CHILD_VALUE_SET_NAME	VARCHAR2	(150)		Name of the Value Set in which the child node resides
DISABLED_FLAG	VARCHAR2	(1)	Yes	Indicates if the node is a disabled dimension member

Query Text

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


SELECT REQUEST_ID
,      REQUEST_DATE
,      REQUEST_NAME
,      PARAM_OBJECT_TYPE_CODE
,      PARAM_OBJECT_TYPE_NAME
,      PARAM_LEDGER_ID
,      PARAM_LEDGER_NAME
,      PARAM_EFFECTIVE_DATE
,      PARAM_OBJECT_ID
,      PARAM_OBJECT_NAME
,      PARAM_FOLDER_ID
,      PARAM_FOLDER_NAME
,      PARAM_DIMENSION_ID
,      PARAM_DIMENSION_NAME
,      HIERARCHY_OBJECT_ID
,      HIERARCHY_OBJECT_NAME
,      HIERARCHY_OBJ_DEF_ID
,      HIERARCHY_OBJ_DEF_NAME
,      PARENT_MEMBER_ID
,      PARENT_DISPLAY_CODE
,      PARENT_NAME
,      PARENT_VALUE_SET_ID
,      PARENT_VALUE_SET_NAME
,      CHILD_MEMBER_ID
,      CHILD_DISPLAY_CODE
,      CHILD_NAME
,      CHILD_VALUE_SET_ID
,      CHILD_VALUE_SET_NAME
,      DISABLED_FLAG
FROM APPS.FEM_BR_DIS_MBR_HIER_V;

Dependencies

[top of page]

APPS.FEM_BR_DIS_MBR_HIER_V references the following:

APPS: FEM_BR_DIS_MBR_HIER; FEM_BR_DIS_MBR_REQUESTS

APPS.FEM_BR_DIS_MBR_HIER_V is not referenced by any database object