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_COLUMN_REQUIREMNT_VL

Object Details

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

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number. This is a framework required column used for stale data detection.
LAST_UPDATE_DATE	DATE		Yes	Date row was last modified.
LAST_UPDATE_LOGIN	NUMBER			Login ID of user who last modified the row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Identifies user who last modified the row.
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.
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
DISPLAY_NAME	VARCHAR2	(150)	Yes	Display name.
DESCRIPTION	VARCHAR2	(255)	Yes	Description.

Query Text

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


SELECT ROW_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      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
,      COLUMN_NAME
,      FEM_DATA_TYPE_CODE
,      DATA_TYPE
,      PROCESS_KEY_CANDIDATE_FLG
,      PROCESS_KEY_COL_ID
,      DISPLAY_SEQ
,      RESTRICTED_FLAG
,      ACTIVITY_DIM_REQUIREMENT_CODE
,      DISPLAY_NAME
,      DESCRIPTION
FROM APPS.FEM_COLUMN_REQUIREMNT_VL;

Dependencies

[top of page]

APPS.FEM_COLUMN_REQUIREMNT_VL references the following:

APPS: FEM_COLUMN_REQUIREMNT_B; FEM_COLUMN_REQUIREMNT_TL

APPS.FEM_COLUMN_REQUIREMNT_VL is referenced by following:

APPS: FEM_COLUMN_REQUIREMNT_DL; FEM_COLUMN_REQUIREMNT_IL; FEM_COLUMN_REQUIREMNT_UL; FEM_COL_TMPLT_DEFN_API_PUB - show dependent code; FEM_CONDITIONS_API - show dependent code; FEM_TABLE_REGISTRATION_PKG - show dependent code