[Home] [Help] [Dependency Information]
Object Name: | FEM_DIM_ATTRIBUTES_B |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_DIM_ATTRIBUTES_B_PK | NORMAL | UNIQUE | APPS_TS_SEED | ATTRIBUTE_ID |
FEM_DIM_ATTRIBUTES_B_UK1 | NORMAL | UNIQUE | APPS_TS_SEED |
ATTRIBUTE_VARCHAR_LABEL
DIMENSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 dimension attribute is a personal attribute only available to the Created By user |
READ_ONLY_FLAG | VARCHAR2 | (1) | Yes | Designates whether or not the characteristics of the attribute are 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 | |
DEFAULT_ASSIGNMENT | VARCHAR2 | (1000) | ||
DEFAULT_ASSIGNMENT_VS_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, DEFAULT_ASSIGNMENT
, DEFAULT_ASSIGNMENT_VS_ID
FROM FEM.FEM_DIM_ATTRIBUTES_B;
FEM.FEM_DIM_ATTRIBUTES_B does not reference any database object
FEM.FEM_DIM_ATTRIBUTES_B is referenced by following:
|
|
|