[Home] [Help] [Dependency Information]
Object Name: | FEM_DIS_USR_DIM5_HIER_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_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_DIS_USR_DIM5_HIER_B_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OBJECT_ID
OBJECT_DEFINITION_ID VALUE_SET_ID LEVEL1_ID LEVEL2_ID LEVEL3_ID LEVEL4_ID LEVEL5_ID LEVEL6_ID LEVEL7_ID LEVEL8_ID LEVEL9_ID LEVEL10_ID LEVEL11_ID LEVEL12_ID LEVEL13_ID LEVEL14_ID LEVEL15_ID LEVEL16_ID LEVEL17_ID LEVEL18_ID LEVEL19_ID LEVEL20_ID |
FEM_DIS_USR_DIM5_HIER_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OBJECT_ID
OBJECT_DEFINITION_ID VALUE_SET_ID LEVEL1_DISPLAY_CODE LEVEL2_DISPLAY_CODE LEVEL3_DISPLAY_CODE LEVEL4_DISPLAY_CODE LEVEL5_DISPLAY_CODE LEVEL6_DISPLAY_CODE LEVEL7_DISPLAY_CODE LEVEL8_DISPLAY_CODE LEVEL9_DISPLAY_CODE LEVEL10_DISPLAY_CODE LEVEL11_DISPLAY_CODE LEVEL12_DISPLAY_CODE LEVEL13_DISPLAY_CODE LEVEL14_DISPLAY_CODE LEVEL15_DISPLAY_CODE LEVEL16_DISPLAY_CODE LEVEL17_DISPLAY_CODE LEVEL18_DISPLAY_CODE LEVEL19_DISPLAY_CODE LEVEL20_DISPLAY_CODE |
FEM_DIS_USR_DIM5_HIER_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEVEL20_ID |
FEM_DIS_USR_DIM5_HIER_B_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEVEL20_DISPLAY_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | Yes | ||
OBJECT_DEFINITION_ID | NUMBER | Yes | ||
VALUE_SET_ID | NUMBER | Yes | ||
LEVEL1_ID | NUMBER | Yes | ||
LEVEL2_ID | NUMBER | Yes | ||
LEVEL3_ID | NUMBER | Yes | ||
LEVEL4_ID | NUMBER | Yes | ||
LEVEL5_ID | NUMBER | Yes | ||
LEVEL6_ID | NUMBER | Yes | ||
LEVEL7_ID | NUMBER | Yes | ||
LEVEL8_ID | NUMBER | Yes | ||
LEVEL9_ID | NUMBER | Yes | ||
LEVEL10_ID | NUMBER | Yes | ||
LEVEL11_ID | NUMBER | Yes | ||
LEVEL12_ID | NUMBER | Yes | ||
LEVEL13_ID | NUMBER | Yes | ||
LEVEL14_ID | NUMBER | Yes | ||
LEVEL15_ID | NUMBER | Yes | ||
LEVEL16_ID | NUMBER | Yes | ||
LEVEL17_ID | NUMBER | Yes | ||
LEVEL18_ID | NUMBER | Yes | ||
LEVEL19_ID | NUMBER | Yes | ||
LEVEL20_ID | NUMBER | Yes | ||
LEVEL1_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL2_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL3_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL4_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL5_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL6_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL7_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL8_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL9_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL10_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL11_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL12_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL13_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL14_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL15_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL16_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL17_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL18_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL19_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL20_DISPLAY_CODE | VARCHAR2 | (150) | Yes | |
LEVEL1_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL2_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL3_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL4_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL5_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL6_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL7_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL8_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL9_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL10_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL11_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL12_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL13_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL14_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL15_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL16_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL17_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL18_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL19_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
LEVEL20_DISPLAY_ORDER_NUM | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_ID
, OBJECT_DEFINITION_ID
, VALUE_SET_ID
, LEVEL1_ID
, LEVEL2_ID
, LEVEL3_ID
, LEVEL4_ID
, LEVEL5_ID
, LEVEL6_ID
, LEVEL7_ID
, LEVEL8_ID
, LEVEL9_ID
, LEVEL10_ID
, LEVEL11_ID
, LEVEL12_ID
, LEVEL13_ID
, LEVEL14_ID
, LEVEL15_ID
, LEVEL16_ID
, LEVEL17_ID
, LEVEL18_ID
, LEVEL19_ID
, LEVEL20_ID
, LEVEL1_DISPLAY_CODE
, LEVEL2_DISPLAY_CODE
, LEVEL3_DISPLAY_CODE
, LEVEL4_DISPLAY_CODE
, LEVEL5_DISPLAY_CODE
, LEVEL6_DISPLAY_CODE
, LEVEL7_DISPLAY_CODE
, LEVEL8_DISPLAY_CODE
, LEVEL9_DISPLAY_CODE
, LEVEL10_DISPLAY_CODE
, LEVEL11_DISPLAY_CODE
, LEVEL12_DISPLAY_CODE
, LEVEL13_DISPLAY_CODE
, LEVEL14_DISPLAY_CODE
, LEVEL15_DISPLAY_CODE
, LEVEL16_DISPLAY_CODE
, LEVEL17_DISPLAY_CODE
, LEVEL18_DISPLAY_CODE
, LEVEL19_DISPLAY_CODE
, LEVEL20_DISPLAY_CODE
, LEVEL1_DISPLAY_ORDER_NUM
, LEVEL2_DISPLAY_ORDER_NUM
, LEVEL3_DISPLAY_ORDER_NUM
, LEVEL4_DISPLAY_ORDER_NUM
, LEVEL5_DISPLAY_ORDER_NUM
, LEVEL6_DISPLAY_ORDER_NUM
, LEVEL7_DISPLAY_ORDER_NUM
, LEVEL8_DISPLAY_ORDER_NUM
, LEVEL9_DISPLAY_ORDER_NUM
, LEVEL10_DISPLAY_ORDER_NUM
, LEVEL11_DISPLAY_ORDER_NUM
, LEVEL12_DISPLAY_ORDER_NUM
, LEVEL13_DISPLAY_ORDER_NUM
, LEVEL14_DISPLAY_ORDER_NUM
, LEVEL15_DISPLAY_ORDER_NUM
, LEVEL16_DISPLAY_ORDER_NUM
, LEVEL17_DISPLAY_ORDER_NUM
, LEVEL18_DISPLAY_ORDER_NUM
, LEVEL19_DISPLAY_ORDER_NUM
, LEVEL20_DISPLAY_ORDER_NUM
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM FEM.FEM_DIS_USR_DIM5_HIER_B;
FEM.FEM_DIS_USR_DIM5_HIER_B does not reference any database object
FEM.FEM_DIS_USR_DIM5_HIER_B is referenced by following:
|
|
|