[Home] [Help] [Dependency Information]
Object Name: | FEM_XDIM_DIMENSIONS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
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 |
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;
|
|
|