[Home] [Help] [Dependency Information]
Object Name: | BSC_DIM_OBJ_CHD_RELS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
View of Dimension object child relationship
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHORT_NAME | VARCHAR2 | (30) | Short name | |
DIM_OBJ_ID | NUMBER | (5) | Yes | Dimension level identifier |
DIM_OBJ_NAME | VARCHAR2 | (255) | Yes | |
CHILD_SHORT_NAME | VARCHAR2 | (30) | ||
CHILD_DIM_OBJ_ID | NUMBER | (5) | Yes | Dimension level identifier |
CHILD_DIM_OBJ_NAME | VARCHAR2 | (255) | Yes | |
BIND_COLUMN | VARCHAR2 | (50) | ||
RELATION_TYPE | NUMBER | (15) | Yes | Dimension level identifier |
DIRECT_RELATION | NUMBER | (3) | Dimension level identifier | |
DATA_TYPE | VARCHAR2 | (30) | Data source type | |
DATA_SOURCE | VARCHAR2 | (240) | Data source | |
LEVEL_TABLE_NAME | VARCHAR2 | (30) | Yes | Dimension level table name |
TABLE_TYPE | NUMBER | (3) | Yes | Table type, 0=normal, 1= system table |
LEVEL_PK_COL | VARCHAR2 | (30) | Yes | Primary key column name |
ABBREVIATION | VARCHAR2 | (24) | Yes | Abbreviation to generate dump values |
LEVEL_VIEW_NAME | VARCHAR2 | (30) | Dimension level view name | |
SOURCE | VARCHAR2 | (10) | Source | |
LAST_UPDATE_DATE | DATE | |||
CHILD_LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT SHORT_NAME
, DIM_OBJ_ID
, DIM_OBJ_NAME
, CHILD_SHORT_NAME
, CHILD_DIM_OBJ_ID
, CHILD_DIM_OBJ_NAME
, BIND_COLUMN
, RELATION_TYPE
, DIRECT_RELATION
, DATA_TYPE
, DATA_SOURCE
, LEVEL_TABLE_NAME
, TABLE_TYPE
, LEVEL_PK_COL
, ABBREVIATION
, LEVEL_VIEW_NAME
, SOURCE
, LAST_UPDATE_DATE
, CHILD_LAST_UPDATE_DATE
FROM APPS.BSC_DIM_OBJ_CHD_RELS_VL;
APPS.BSC_DIM_OBJ_CHD_RELS_VL is not referenced by any database object
|
|
|