[Home] [Help] [Dependency Information]
Object Name: | FEM_DIM_ATTRIBUTES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Framework required column identifying the row | |
ATTRIBUTE_ID | NUMBER | (9) | Yes | Attribute Identifier |
ATTRIBUTE_VARCHAR_LABEL | VARCHAR2 | (30) | Yes | Alternate alphanumeric identifier for the attribute |
DIMENSION_ID | NUMBER | (9) | Yes | Identifier of a list of dimension members |
ATTRIBUTE_DIMENSION_ID | NUMBER | (9) | Identifier of a list of dimension members | |
ATTRIBUTE_VALUE_COLUMN_NAME | VARCHAR2 | (30) | Yes | Designates the column name storing the attribute assignment in the _ATTR table of the dimension |
ATTRIBUTE_DATA_TYPE_CODE | VARCHAR2 | (30) | Yes | Designates the Data Type of the attribute assignment |
ALLOW_MULTIPLE_ASSIGNMENT_FLAG | VARCHAR2 | (1) | Yes | Designates whether the attribute allows multiple assignments for the same version |
ATTRIBUTE_ORDER_TYPE_CODE | VARCHAR2 | (30) | Designates how attribute assignments can be ordered | |
ATTRIBUTE_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Designates whether or not an attribute assignment is required for every member in the dimension |
USE_INHERITANCE_FLAG | VARCHAR2 | (1) | Yes | Designates whether child members inherit assignments of the attribute from parent members given a hierarchy context |
QUERYABLE_FOR_REPORTING_FLAG | VARCHAR2 | (1) | Yes | Designates whether or not assignments of the attribute are available for reporting queries |
ALLOW_MULTIPLE_VERSIONS_FLAG | VARCHAR2 | (1) | Yes | Designates whether or multiple versions of the attribute are allowed |
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 | ||
ASSIGNMENT_IS_READ_ONLY_FLAG | VARCHAR2 | (1) | Yes | Designates whether or not the attribute assignment is protected from update |
PERSONAL_FLAG | VARCHAR2 | (1) | Yes | Designates whether or not the member is a personal dimension member |
READ_ONLY_FLAG | VARCHAR2 | (1) | Yes | Designates whether or not the Dimension member is protected from update |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number for stale data detection | |
USER_ASSIGN_ALLOWED_FLAG | VARCHAR2 | (1) | A N designates that users cannot provide an assignment value for the attribute, either during creation of new members or update of an existing member. Assignments for such attributes can only be made programatically | |
ATTRIBUTE_NAME | VARCHAR2 | (80) | Yes | Attribute Name |
DESCRIPTION | VARCHAR2 | (255) | Description |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ATTRIBUTE_ID
, ATTRIBUTE_VARCHAR_LABEL
, DIMENSION_ID
, ATTRIBUTE_DIMENSION_ID
, ATTRIBUTE_VALUE_COLUMN_NAME
, ATTRIBUTE_DATA_TYPE_CODE
, ALLOW_MULTIPLE_ASSIGNMENT_FLAG
, ATTRIBUTE_ORDER_TYPE_CODE
, ATTRIBUTE_REQUIRED_FLAG
, USE_INHERITANCE_FLAG
, QUERYABLE_FOR_REPORTING_FLAG
, ALLOW_MULTIPLE_VERSIONS_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ASSIGNMENT_IS_READ_ONLY_FLAG
, PERSONAL_FLAG
, READ_ONLY_FLAG
, OBJECT_VERSION_NUMBER
, USER_ASSIGN_ALLOWED_FLAG
, ATTRIBUTE_NAME
, DESCRIPTION
FROM APPS.FEM_DIM_ATTRIBUTES_VL;
|
|
|