DBA Data[Home] [Help] [Dependency Information]

TABLE: FEM.FEM_DIS_ENTITIES_HIER_B

Object Details
Object Name: FEM_DIS_ENTITIES_HIER_B
Object Type: TABLE
Owner: FEM
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_DIS_ENTITIES_HIER_B_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
ColumnOBJECT_DEFINITION_ID
ColumnVALUE_SET_ID
ColumnLEVEL1_ID
ColumnLEVEL2_ID
ColumnLEVEL3_ID
ColumnLEVEL4_ID
ColumnLEVEL5_ID
ColumnLEVEL6_ID
ColumnLEVEL7_ID
ColumnLEVEL8_ID
ColumnLEVEL9_ID
ColumnLEVEL10_ID
ColumnLEVEL11_ID
ColumnLEVEL12_ID
ColumnLEVEL13_ID
ColumnLEVEL14_ID
ColumnLEVEL15_ID
ColumnLEVEL16_ID
ColumnLEVEL17_ID
ColumnLEVEL18_ID
ColumnLEVEL19_ID
ColumnLEVEL20_ID
FEM_DIS_ENTITIES_HIER_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
ColumnOBJECT_DEFINITION_ID
ColumnVALUE_SET_ID
ColumnLEVEL1_DISPLAY_CODE
ColumnLEVEL2_DISPLAY_CODE
ColumnLEVEL3_DISPLAY_CODE
ColumnLEVEL4_DISPLAY_CODE
ColumnLEVEL5_DISPLAY_CODE
ColumnLEVEL6_DISPLAY_CODE
ColumnLEVEL7_DISPLAY_CODE
ColumnLEVEL8_DISPLAY_CODE
ColumnLEVEL9_DISPLAY_CODE
ColumnLEVEL10_DISPLAY_CODE
ColumnLEVEL11_DISPLAY_CODE
ColumnLEVEL12_DISPLAY_CODE
ColumnLEVEL13_DISPLAY_CODE
ColumnLEVEL14_DISPLAY_CODE
ColumnLEVEL15_DISPLAY_CODE
ColumnLEVEL16_DISPLAY_CODE
ColumnLEVEL17_DISPLAY_CODE
ColumnLEVEL18_DISPLAY_CODE
ColumnLEVEL19_DISPLAY_CODE
ColumnLEVEL20_DISPLAY_CODE
FEM_DIS_ENTITIES_HIER_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEVEL20_ID
FEM_DIS_ENTITIES_HIER_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEVEL20_DISPLAY_CODE
Columns
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

Query Text

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_ENTITIES_HIER_B;

Dependencies

[top of page]

FEM.FEM_DIS_ENTITIES_HIER_B does not reference any database object

FEM.FEM_DIS_ENTITIES_HIER_B is referenced by following:

SchemaAPPS
SynonymFEM_DIS_ENTITIES_HIER_B