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_FUNCTION_CD_MAPPING

Object Details

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

The FEM_FUNCTION_CD_MAPPING table stores the relationship between the FUNCTION_CD concept (stored in FEM_ALLOC_BR_FORMULA) and the PREVIEW_ROW_GROUP concept (stored in FEM_MAPPING_PREVIEW_STATS). Code can then refer to this table for the relationship instead of hard-coding it. The data in this table is seeded.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_FUNCTION_CD_MAPPING_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FUNCTION_CD

Columns

Name	Datatype	Length	Mandatory	Comments
FUNCTION_CD	VARCHAR2	(30)	Yes	Represents the function of a row stored in FEM_ALLOC_BR_FORMULA. Examples are: CREDIT, DEBITFILTER, TABLE_ACCESS, LEAFFUNC, and PCT_DISTRB
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
PREVIEW_ROW_GROUP_DISPLAY_SEQ	NUMBER		Yes	Order in which preview row groups are to be shown in the Preview user interface
PREVIEW_ROW_GROUP_PROCESS_SEQ	NUMBER		Yes	Order in which preview row groups are processed in the Mapping Preview engine
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 FUNCTION_CD
,      PREVIEW_ROW_GROUP
,      PREVIEW_ROW_GROUP_DISPLAY_SEQ
,      PREVIEW_ROW_GROUP_PROCESS_SEQ
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FEM.FEM_FUNCTION_CD_MAPPING;

Dependencies

[top of page]

FEM.FEM_FUNCTION_CD_MAPPING does not reference any database object

FEM.FEM_FUNCTION_CD_MAPPING is referenced by following:

APPS: FEM_FUNCTION_CD_MAPPING