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_TAB_COL_PROP_ATTRB_V

Object Details

Object Name:	FEM_TAB_COL_PROP_ATTRB_V
Object Type:	VIEW
Owner:	APPS
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TABLE_NAME	VARCHAR2	(30)	Yes	Name of registered table or view. References FEM_TAB_COLUMNS_PROP.TABLE_NAME.
COLUMN_NAME	VARCHAR2	(30)	Yes	Name of column. References FEM_TAB_COLUMNS_PROP.TABLE_NAME.
DISPLAY_NAME	VARCHAR2	(150)	Yes	Column display name. References FEM_TAB_COLUMNS_VL.DISPLAY_NAME.
COLUMN_PROPERTY_CODE	VARCHAR2	(30)	Yes	Column Property Code. References FEM_TAB_COLUMNS_PROP.TABLE_NAME.
DISPLAY_SEQ	NUMBER	(3)		). It is used to determine the order of appearance of the columns on the user interface. References FEM_COLUMN_REQUIREMNT_B.DISPLAY_SEQ.
DIMENSION_ID	NUMBER	(9)		This is identifies the dimension that provides a list of values for the column. References FEM_COLUMN_REQUIREMNT_B.DIMENSION_ID.
MEMBER_VL_OBJECT_NAME	VARCHAR2	(30)		Member VL object name. References FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME.
MEMBER_COL	VARCHAR2	(30)		Member Column. References FEM_XDIM_DIMENSIONS.MEMBER_COL.
MEMBER_NAME_COL	VARCHAR2	(30)		Member Name Column. References FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL.
HIERARCHY_TABLE_NAME	VARCHAR2	(30)		Hierarchy table name. References FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME.

Query Text

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


SELECT TABLE_NAME
,      COLUMN_NAME
,      DISPLAY_NAME
,      COLUMN_PROPERTY_CODE
,      DISPLAY_SEQ
,      DIMENSION_ID
,      MEMBER_VL_OBJECT_NAME
,      MEMBER_COL
,      MEMBER_NAME_COL
,      HIERARCHY_TABLE_NAME
FROM APPS.FEM_TAB_COL_PROP_ATTRB_V;

Dependencies

[top of page]

APPS.FEM_TAB_COL_PROP_ATTRB_V references the following:

APPS: FEM_COLUMN_REQUIREMNT_B; FEM_TAB_COLUMNS_V; FEM_TAB_COLUMN_PROP; FEM_XDIM_DIMENSIONS

APPS.FEM_TAB_COL_PROP_ATTRB_V is not referenced by any database object