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_COLUMN_REQUIREMNT_B

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_COLUMN_REQUIREMNT_B_PK	NORMAL	UNIQUE	APPS_TS_SEED	COLUMN_NAME
FEM_COLUMN_REQUIREMNT_B_UK1	NORMAL	UNIQUE	APPS_TS_SEED	PROCESS_KEY_COL_ID
FEM_COLUMN_REQUIREMNT_B_UK2	NORMAL	UNIQUE	APPS_TS_SEED	DISPLAY_SEQ

Columns

Name	Datatype	Length	Mandatory	Comments
COLUMN_NAME	VARCHAR2	(30)	Yes	Name of required column.
FEM_DATA_TYPE_CODE	VARCHAR2	(30)	Yes	FEM Data Type Code of the column. References FEM_DATA_TYPES_B.FEM_DATA_TYPE_CODE.
DATA_TYPE	VARCHAR2	(10)	Yes	Data type of column (RDBMS data types such as CHAR, VARCHAR2 etc.)
PROCESS_KEY_CANDIDATE_FLG	NUMBER	(1)	Yes	This is a flag which indicates whether or not a required column may be part of the processing key. Valid values are 1 which means a column is a processing key candidate, and 0 which means a column is NOT a processing key candidate.
PROCESS_KEY_COL_ID	NUMBER	(3)		This column contains a numeric identifier used by the software. It is only assigned and applicable to columns which are processing key.
DISPLAY_SEQ	NUMBER	(3)		). It is used to determine the order of appearance of the columns on the user interface. Values in this column must be unique.
RESTRICTED_FLAG	VARCHAR2	(1)	Yes	Indicates whether a row is updateable. N indicates the row is not updateable, and Y indicates the row is updateable.
ACTIVITY_DIM_REQUIREMENT_CODE	VARCHAR2	(30)		Indicates the columns which must be part of the activity dimension
ACTIVITY_DIM_COMPONENT_FLAG	VARCHAR2	(1)	Yes	Indicates all the dimension columns that are part of the activity dimension. Valid values are Y and N.
COST_OBJ_DIM_REQUIREMENT_CODE	VARCHAR2	(30)		Indicates the columns which must be part of the activity dimension.
COST_OBJ_DIM_COMPONENT_FLAG	VARCHAR2	(1)	Yes	Indicates all the dimension columns that are part of the cost object dimension. Valid values are Y and N.
DATA_LENGTH	NUMBER	(5)		Data length of column.
DATA_SCALE	NUMBER	(5)		Data scale of column.
DATA_PRECISION	NUMBER	(5)		Data precision of column.
UOM_COLUMN_NAME	VARCHAR2	(30)		Unit of measurement column name. Name of column that needs to exist on the same table for the current required column to be meaningful. References FEM_COLUMN_REQUIREMENT _B.COLUMN_NAME.
DIMENSION_ID	NUMBER	(9)		This is identifies the dimension that provides a list of values for the column. References FEM_DIMENSIONS_B.DIMENSION_ID.
CREATION_DATE	DATE		Yes	Date the row was created
CREATED_BY	NUMBER	(15)	Yes	Identifies user who created row References FND_USER.USER_ID.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Identifies user who last modified the row.
LAST_UPDATE_DATE	DATE		Yes	Date row was last modified.
LAST_UPDATE_LOGIN	NUMBER			Login ID of user who last modified the row.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number. This is a framework required column used for stale data detection.

Query Text

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


SELECT COLUMN_NAME
,      FEM_DATA_TYPE_CODE
,      DATA_TYPE
,      PROCESS_KEY_CANDIDATE_FLG
,      PROCESS_KEY_COL_ID
,      DISPLAY_SEQ
,      RESTRICTED_FLAG
,      ACTIVITY_DIM_REQUIREMENT_CODE
,      ACTIVITY_DIM_COMPONENT_FLAG
,      COST_OBJ_DIM_REQUIREMENT_CODE
,      COST_OBJ_DIM_COMPONENT_FLAG
,      DATA_LENGTH
,      DATA_SCALE
,      DATA_PRECISION
,      UOM_COLUMN_NAME
,      DIMENSION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM FEM.FEM_COLUMN_REQUIREMNT_B;