[Home] [Help] [Dependency Information]
Object Name: | FEM_DIS_CAL_PER_HIER_TL |
---|---|
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_CAL_PER_HIER_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OBJECT_ID
OBJECT_DEFINITION_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 LANGUAGE |
FEM_DIS_CAL_PER_HIER_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OBJECT_ID
OBJECT_DEFINITION_ID LEVEL1_NAME LEVEL2_NAME LEVEL3_NAME LEVEL4_NAME LEVEL5_NAME LEVEL6_NAME LEVEL7_NAME LEVEL8_NAME LEVEL9_NAME LEVEL10_NAME LEVEL11_NAME LEVEL12_NAME LEVEL13_NAME LEVEL14_NAME LEVEL15_NAME LEVEL16_NAME LEVEL17_NAME LEVEL18_NAME LEVEL19_NAME LEVEL20_NAME LANGUAGE |
FEM_DIS_CAL_PER_HIER_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEVEL20_ID |
FEM_DIS_CAL_PER_HIER_TL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEVEL20_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | Yes | ||
OBJECT_DEFINITION_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 | ||
LANGUAGE | VARCHAR2 | (4) | Yes | |
SOURCE_LANG | VARCHAR2 | (4) | Yes | |
OBJECT_NAME | VARCHAR2 | (150) | Yes | |
OBJECT_DEFINITION_NAME | VARCHAR2 | (150) | Yes | |
LEVEL1_NAME | VARCHAR2 | (150) | Yes | |
LEVEL2_NAME | VARCHAR2 | (150) | Yes | |
LEVEL3_NAME | VARCHAR2 | (150) | Yes | |
LEVEL4_NAME | VARCHAR2 | (150) | Yes | |
LEVEL5_NAME | VARCHAR2 | (150) | Yes | |
LEVEL6_NAME | VARCHAR2 | (150) | Yes | |
LEVEL7_NAME | VARCHAR2 | (150) | Yes | |
LEVEL8_NAME | VARCHAR2 | (150) | Yes | |
LEVEL9_NAME | VARCHAR2 | (150) | Yes | |
LEVEL10_NAME | VARCHAR2 | (150) | Yes | |
LEVEL11_NAME | VARCHAR2 | (150) | Yes | |
LEVEL12_NAME | VARCHAR2 | (150) | Yes | |
LEVEL13_NAME | VARCHAR2 | (150) | Yes | |
LEVEL14_NAME | VARCHAR2 | (150) | Yes | |
LEVEL15_NAME | VARCHAR2 | (150) | Yes | |
LEVEL16_NAME | VARCHAR2 | (150) | Yes | |
LEVEL17_NAME | VARCHAR2 | (150) | Yes | |
LEVEL18_NAME | VARCHAR2 | (150) | Yes | |
LEVEL19_NAME | VARCHAR2 | (150) | Yes | |
LEVEL20_NAME | VARCHAR2 | (150) | Yes | |
LEVEL1_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL2_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL3_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL4_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL5_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL6_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL7_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL8_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL9_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL10_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL11_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL12_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL13_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL14_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL15_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL16_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL17_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL18_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL19_DESCRIPTION | VARCHAR2 | (255) | ||
LEVEL20_DESCRIPTION | VARCHAR2 | (255) | ||
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
, 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
, LANGUAGE
, SOURCE_LANG
, OBJECT_NAME
, OBJECT_DEFINITION_NAME
, LEVEL1_NAME
, LEVEL2_NAME
, LEVEL3_NAME
, LEVEL4_NAME
, LEVEL5_NAME
, LEVEL6_NAME
, LEVEL7_NAME
, LEVEL8_NAME
, LEVEL9_NAME
, LEVEL10_NAME
, LEVEL11_NAME
, LEVEL12_NAME
, LEVEL13_NAME
, LEVEL14_NAME
, LEVEL15_NAME
, LEVEL16_NAME
, LEVEL17_NAME
, LEVEL18_NAME
, LEVEL19_NAME
, LEVEL20_NAME
, LEVEL1_DESCRIPTION
, LEVEL2_DESCRIPTION
, LEVEL3_DESCRIPTION
, LEVEL4_DESCRIPTION
, LEVEL5_DESCRIPTION
, LEVEL6_DESCRIPTION
, LEVEL7_DESCRIPTION
, LEVEL8_DESCRIPTION
, LEVEL9_DESCRIPTION
, LEVEL10_DESCRIPTION
, LEVEL11_DESCRIPTION
, LEVEL12_DESCRIPTION
, LEVEL13_DESCRIPTION
, LEVEL14_DESCRIPTION
, LEVEL15_DESCRIPTION
, LEVEL16_DESCRIPTION
, LEVEL17_DESCRIPTION
, LEVEL18_DESCRIPTION
, LEVEL19_DESCRIPTION
, LEVEL20_DESCRIPTION
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM FEM.FEM_DIS_CAL_PER_HIER_TL;
FEM.FEM_DIS_CAL_PER_HIER_TL does not reference any database object
FEM.FEM_DIS_CAL_PER_HIER_TL is referenced by following:
|
|
|