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_XDIM_DIMENSIONS_VL

Object Details

Object Name:	FEM_XDIM_DIMENSIONS_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
DIMENSION_ID	NUMBER	(9)	Yes	Identifier of a list of dimension members
DIMENSION_VARCHAR_LABEL	VARCHAR2	(30)	Yes	Alternate alphanumeric descriptor identifying a list of dimension members
DIM_OWNER_APPLICATION_ID	NUMBER		Yes	The Application ID whose schema owns the designated object
OBJECT_VERSION_NUMBER	NUMBER		Yes	Framework required column for determining concurrency
DIMENSION_NAME	VARCHAR2	(80)	Yes	Dimension name
DESCRIPTION	VARCHAR2	(255)		Description
MEMBER_DATA_TYPE_CODE	VARCHAR2	(30)	Yes	Data Type of the Member identifier column
MEMBER_B_TABLE_NAME	VARCHAR2	(30)	Yes	Member Base Table Name
MEMBER_TL_TABLE_NAME	VARCHAR2	(30)		Member Translatable Table Name
MEMBER_VL_OBJECT_NAME	VARCHAR2	(30)	Yes	Member Language View Name
MEMBER_COL	VARCHAR2	(30)	Yes	Column name that identifies dimension members
MEMBER_DISPLAY_CODE_COL	VARCHAR2	(30)	Yes	Column name that stores the dimension member alphanumeric code
MEMBER_NAME_COL	VARCHAR2	(30)	Yes	Column name that stores dimension member names
MEMBER_DESCRIPTION_COL	VARCHAR2	(30)	Yes	Column name that stores descriptions of the dimension members
HIERARCHY_TABLE_NAME	VARCHAR2	(30)		Hierarchy Table Name
ATTRIBUTE_TABLE_NAME	VARCHAR2	(30)		Attribute Table Name
DIMENSION_TYPE_CODE	VARCHAR2	(30)	Yes	Dimension Type Code
SIMPLE_DIMENSION_FLAG	VARCHAR2	(1)	Yes	Designates whether or not the dimension is a Simple dimension with no attributes and no hierarchies
COMPOSITE_DIMENSION_FLAG	VARCHAR2	(1)	Yes	Designates whether or not the dimension is a Composite dimension
VALUE_SET_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Designates whether or not a Value Set is required for dimension member identification
GROUP_USE_CODE	VARCHAR2	(30)	Yes	Designates how Dimension Groups are used for the Dimension
HIER_TYPE_ALLOWED_CODE	VARCHAR2	(30)	Yes	Designates the hierarchy types allowed for the dimension
HIER_VERSIONING_TYPE_CODE	VARCHAR2	(30)	Yes	Designates the versioning method for hierarchies of the dimension
HIER_EDITOR_MANAGED_FLAG	VARCHAR2	(1)	Yes	Designates whether not the dimension appears in the Dimension Hierarchy Manager application
SEEDED_CATEGORY_CODE	VARCHAR2	(30)	Yes	Seeded data category code
RESERVED_LOWER_BOUND	VARCHAR2	(30)		Seeded data reserved lower bound
RESERVED_UPPER_BOUND	VARCHAR2	(30)		Seeded data reserved upper bound
READ_ONLY_FLAG	VARCHAR2	(1)	Yes	Designates whether or not the Dimension member is protected from update
ID_FLEX_CODE	VARCHAR2	(4)		ID Flex Code required for Flexfields
ID_FLEX_NUM	NUMBER	(15)		ID Flex Num required for Flexfields
ID_FLEX_STRUCTURE_CODE	VARCHAR2	(30)
DIMENSION_ACTIVE_FLAG	VARCHAR2	(1)	Yes	Designates whether or not the Dimension is active
VS_MEMBER_VL_OBJECT_NAME	VARCHAR2	(30)	Yes	Object name of the Value Set context Member view
VS_HIERARCHY_OBJECT_NAME	VARCHAR2	(30)		Object name of the Value Set context Hierarchy view
VS_ATTRIBUTE_OBJECT_NAME	VARCHAR2	(30)		Object name of the Value Set context Attribute view
LOGICAL_DELETE_APPLICABLE_FLAG	VARCHAR2	(1)	Yes	Designates whether or not logical delete of members is allowed for the dimension
PERSONAL_HIERARCHY_TABLE_NAME	VARCHAR2	(30)		Personal Hierarchy Table Name
VS_PERSONAL_HIER_OBJECT_NAME	VARCHAR2	(30)		Object name of the Value Set context Personal Hierarchy view
USER_DEFINED_FLAG	VARCHAR2	(1)	Yes	Designates whether or not the dimension is a user defined dimension
READ_ONLY_APPLICABLE_FLAG	VARCHAR2	(1)	Yes	Designates whether or not members for the dimension can be set to read only and un-editable
DEFAULT_MVS_HIERARCHY_OBJ_ID	NUMBER	(9)		Default Multi-value Set Hierarchy
MEMBER_ID_METHOD_CODE	VARCHAR2	(30)	Yes	Designates the mechanism (such as FUNCTION or MANUAL) for determining new member identifiers
MEMBER_ID_SOURCE_CODE	VARCHAR2	(30)		Designates the object name from which new member identifiers are generated for the dimension
MEMBER_PRIV_TABLE_NAME	VARCHAR2	(30)		Designates the table name that stores member privileges for the dimension
DEFAULT_MEMBER_DISPLAY_CODE	VARCHAR2	(150)		For non value set dimensions, this is the default member for the dimension
CREATION_DATE	DATE		Yes	Identifies the date on which the data was created
CREATED_BY	NUMBER		Yes	Identifies the user that created the data
LAST_UPDATED_BY	NUMBER		Yes	Identifies the user that last updated the data
LAST_UPDATE_DATE	DATE		Yes	Identifies the data on which the data was last updated
LAST_UPDATE_LOGIN	NUMBER			Identifies the login user that last updated the data
LOADER_OBJECT_DEF_ID	NUMBER	(9)		Object Defintion associated with the Dimension used for loading operations
INTF_MEMBER_B_TABLE_NAME	VARCHAR2	(30)		Identifies the base interface table used for loading members for the dimension
INTF_MEMBER_TL_TABLE_NAME	VARCHAR2	(30)		Identifies the translatable interface table used for loading members for the dimension
INTF_ATTRIBUTE_TABLE_NAME	VARCHAR2	(30)		Identifies the attribute interface table used for loading attribute assignments for members of the dimension
DEFAULT_VALUE_SET_ID	NUMBER			Designates the value set to use for a dimension when creating a Global Combo and a value set is not otherwise explicitely designated for that dimension
DIM_TYPE_CONFIGURABLE_FLAG	VARCHAR2	(1)	Yes	A Y designates that users can set the Dimension Type for the dimension. A N designates that the Dimension Type is fixed at installation for the dimension
DSNP_ATTRIBUTE_TABLE_NAME	VARCHAR2	(30)		Designates the table used to store captured attribute assignments for dimension snapshots
DSNP_PRS_ATTR_VIEW_NAME	VARCHAR2	(30)		Dimension Snapshot attribute view name that also shows information for personal members
SEED_LAST_UPDATE_DATE	DATE		Yes	Date upon which the seeded columns in the table were updated by Oracle
OWB_DIM_MEM_MAPPING_NAME	VARCHAR2	(30)		Table name used by Oracle Warehouse Builder moving member interface data into the official Dimension Member Loader interface tables
OWB_DIM_MEM_STAGING_TABLE_NAME	VARCHAR2	(30)		Table name used by Oracle Warehouse Builder moving member interface data into the official Dimension Member Loader interface tables

Query Text

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


SELECT DIMENSION_ID
,      DIMENSION_VARCHAR_LABEL
,      DIM_OWNER_APPLICATION_ID
,      OBJECT_VERSION_NUMBER
,      DIMENSION_NAME
,      DESCRIPTION
,      MEMBER_DATA_TYPE_CODE
,      MEMBER_B_TABLE_NAME
,      MEMBER_TL_TABLE_NAME
,      MEMBER_VL_OBJECT_NAME
,      MEMBER_COL
,      MEMBER_DISPLAY_CODE_COL
,      MEMBER_NAME_COL
,      MEMBER_DESCRIPTION_COL
,      HIERARCHY_TABLE_NAME
,      ATTRIBUTE_TABLE_NAME
,      DIMENSION_TYPE_CODE
,      SIMPLE_DIMENSION_FLAG
,      COMPOSITE_DIMENSION_FLAG
,      VALUE_SET_REQUIRED_FLAG
,      GROUP_USE_CODE
,      HIER_TYPE_ALLOWED_CODE
,      HIER_VERSIONING_TYPE_CODE
,      HIER_EDITOR_MANAGED_FLAG
,      SEEDED_CATEGORY_CODE
,      RESERVED_LOWER_BOUND
,      RESERVED_UPPER_BOUND
,      READ_ONLY_FLAG
,      ID_FLEX_CODE
,      ID_FLEX_NUM
,      ID_FLEX_STRUCTURE_CODE
,      DIMENSION_ACTIVE_FLAG
,      VS_MEMBER_VL_OBJECT_NAME
,      VS_HIERARCHY_OBJECT_NAME
,      VS_ATTRIBUTE_OBJECT_NAME
,      LOGICAL_DELETE_APPLICABLE_FLAG
,      PERSONAL_HIERARCHY_TABLE_NAME
,      VS_PERSONAL_HIER_OBJECT_NAME
,      USER_DEFINED_FLAG
,      READ_ONLY_APPLICABLE_FLAG
,      DEFAULT_MVS_HIERARCHY_OBJ_ID
,      MEMBER_ID_METHOD_CODE
,      MEMBER_ID_SOURCE_CODE
,      MEMBER_PRIV_TABLE_NAME
,      DEFAULT_MEMBER_DISPLAY_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LOADER_OBJECT_DEF_ID
,      INTF_MEMBER_B_TABLE_NAME
,      INTF_MEMBER_TL_TABLE_NAME
,      INTF_ATTRIBUTE_TABLE_NAME
,      DEFAULT_VALUE_SET_ID
,      DIM_TYPE_CONFIGURABLE_FLAG
,      DSNP_ATTRIBUTE_TABLE_NAME
,      DSNP_PRS_ATTR_VIEW_NAME
,      SEED_LAST_UPDATE_DATE
,      OWB_DIM_MEM_MAPPING_NAME
,      OWB_DIM_MEM_STAGING_TABLE_NAME
FROM APPS.FEM_XDIM_DIMENSIONS_VL;

Dependencies

[top of page]

APPS.FEM_XDIM_DIMENSIONS_VL references the following:

APPS: FEM_DIMENSIONS_B; FEM_DIMENSIONS_TL; FEM_XDIM_DIMENSIONS

APPS.FEM_XDIM_DIMENSIONS_VL is referenced by following:

APPS: FEM_ADMIN_UTIL_PKG - show dependent code; FEM_BI_DIMENSION_UTILS_PKG - show dependent code; FEM_COL_TMPLT_DEFN_API_PUB - show dependent code; FEM_COMP_DIM_MEMBER_LOADER_PKG - show dependent code; FEM_CONDITIONS_API - show dependent code; FEM_DIMENSION_MIGRATION_PKG - show dependent code; FEM_DIMENSION_UTIL_PKG - show dependent code; FEM_DIM_MEMBER_LOADER_PKG - show dependent code; FEM_DIM_SNAPSHOT_ENG_PKG - show dependent code; FEM_DIM_SNAPSHOT_UTIL_PKG - show dependent code; FEM_DIM_UTILS_PVT - show dependent code; FEM_HIER_LOADER_PKG - show dependent code; FEM_HIER_UTILS_PVT - show dependent code; FEM_MIR_PKG - show dependent code; FEM_RU_ENGINE_PVT - show dependent code; FEM_UD_PKG - show dependent code; FEM_UD_PKG - show dependent code; FEM_WEBADI_HIER_UTILS_PVT - show dependent code; FEM_WEBADI_MEMBER_UTILS_PVT - show dependent code; PFT_AR_ENGINE_PVT - show dependent code; ZPB_BUSAREA_MAINT - show dependent code