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: FEM.FEM_BR_DIS_MBR_CONTEXTS

Object Details

Object Name:	FEM_BR_DIS_MBR_CONTEXTS
Object Type:	TABLE
Owner:	FEM
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_BR_DIS_MBR_CONTEXTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_ID REPORT_ROW_ID

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.
REPORT_ROW_ID	NUMBER		Yes	System generated ID to uniquely reference a row in this table
PARENT_REPORT_ROW_ID	NUMBER			Row ID of the parent component that references the object that the current row represents
OBJECT_ID	NUMBER	(9)	Yes	Rule ID
OBJECT_NAME	VARCHAR2	(150)	Yes	Rule name
OBJECT_TYPE_CODE	VARCHAR2	(30)	Yes	Rule type code
OBJECT_TYPE_NAME	VARCHAR2	(150)	Yes	Rule type name
FOLDER_ID	NUMBER	(9)	Yes	Folder ID
FOLDER_NAME	VARCHAR2	(150)	Yes	Folder name
OBJECT_DEFINITION_ID	NUMBER	(9)	Yes	Rule version ID
OBJECT_DEFINITION_NAME	VARCHAR2	(150)	Yes	Rule version name
EFFECTIVE_START_DATE	DATE		Yes	Effective start date of the rule version
EFFECTIVE_END_DATE	DATE		Yes	Effective end date of the rule version
CONTEXT	VARCHAR2	(80)		Provides the context within the rule version that contains the reference to the disabled dimension member.
DIMENSION_ID	NUMBER	(9)		Dimension ID
DIMENSION_NAME	VARCHAR2	(150)		Dimension name
DIMENSION_MEMBER	VARCHAR2	(40)		Dimension member identifier
DIMENSION_MEMBER_DC	VARCHAR2	(150)		Dimension member display code
DIMENSION_MEMBER_NAME	VARCHAR2	(150)		Dimension member name
VALUE_SET_ID	NUMBER			Value set ID of the dimension member
VALUE_SET_NAME	VARCHAR2	(150)		Value set name of the dimension member
CREATION_DATE	DATE		Yes	APPS Standard WHO column.
CREATED_BY	NUMBER		Yes	APPS Standard WHO column.
LAST_UPDATED_BY	NUMBER		Yes	APPS Standard WHO column.
LAST_UPDATE_DATE	DATE		Yes	APPS Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER			APPS Standard WHO column.

Query Text

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


SELECT REQUEST_ID
,      REPORT_ROW_ID
,      PARENT_REPORT_ROW_ID
,      OBJECT_ID
,      OBJECT_NAME
,      OBJECT_TYPE_CODE
,      OBJECT_TYPE_NAME
,      FOLDER_ID
,      FOLDER_NAME
,      OBJECT_DEFINITION_ID
,      OBJECT_DEFINITION_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CONTEXT
,      DIMENSION_ID
,      DIMENSION_NAME
,      DIMENSION_MEMBER
,      DIMENSION_MEMBER_DC
,      DIMENSION_MEMBER_NAME
,      VALUE_SET_ID
,      VALUE_SET_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FEM.FEM_BR_DIS_MBR_CONTEXTS;

Dependencies

[top of page]

FEM.FEM_BR_DIS_MBR_CONTEXTS does not reference any database object

FEM.FEM_BR_DIS_MBR_CONTEXTS is referenced by following:

APPS: FEM_BR_DIS_MBR_CONTEXTS