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_ALLOC_PREVIEW_MAPS

Object Details

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

The FEM_ALLOC_PREVIEW_MAPS table associates the dimension member columns with the dimension member name columns in the temporary table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_ALLOC_PREVIEW_MAPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PREVIEW_OBJ_DEF_ID PREVIEW_ROW_GROUP DIM_MEMBER_COLUMN_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
PREVIEW_OBJ_DEF_ID	NUMBER	(9)	Yes	Object Definition ID for the Mapping Preview Rule
PREVIEW_ROW_GROUP	VARCHAR2	(30)	Yes	Describes the group that owns the rows in the Preview Results section. Examples are: SOURCE, DRIVER, CREDIT, and DEBIT
DIM_MEMBER_COLUMN_NAME	VARCHAR2	(30)	Yes	Name of the column in the temporary table that represents the dimension member column. E.g. PRODUCT_ID
DIM_NAME_COLUMN_NAME	VARCHAR2	(30)	Yes	Name of the column in the temporary table that represents the dimension member name column. E.g. PRODUCT_NAME
CREATED_BY_REQUEST_ID	NUMBER		Yes	Identifies the Request ID that created the data
CREATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Identifies the business rule that created the data
LAST_UPDATED_BY_REQUEST_ID	NUMBER		Yes	Identifies the Request ID that last updated the data
LAST_UPDATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Identifies the business rule that last updated the data

Query Text

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


SELECT PREVIEW_OBJ_DEF_ID
,      PREVIEW_ROW_GROUP
,      DIM_MEMBER_COLUMN_NAME
,      DIM_NAME_COLUMN_NAME
,      CREATED_BY_REQUEST_ID
,      CREATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      LAST_UPDATED_BY_OBJECT_ID
FROM FEM.FEM_ALLOC_PREVIEW_MAPS;

Dependencies

[top of page]

FEM.FEM_ALLOC_PREVIEW_MAPS does not reference any database object

FEM.FEM_ALLOC_PREVIEW_MAPS is referenced by following:

APPS: FEM_ALLOC_PREVIEW_MAPS