eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FEM.FEM_DIS_PRODUCTS_HIER_TL

Object Details

Object Name:	FEM_DIS_PRODUCTS_HIER_TL
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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_DIS_PRODUCTS_HIER_TL_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 LANGUAGE
FEM_DIS_PRODUCTS_HIER_TL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID OBJECT_DEFINITION_ID VALUE_SET_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_PRODUCTS_HIER_TL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEVEL20_ID
FEM_DIS_PRODUCTS_HIER_TL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEVEL20_NAME

Columns

Name	Datatype	Length	Mandatory
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
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

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
,      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_PRODUCTS_HIER_TL;

Dependencies

[top of page]

FEM.FEM_DIS_PRODUCTS_HIER_TL does not reference any database object

FEM.FEM_DIS_PRODUCTS_HIER_TL is referenced by following:

APPS: FEM_DIS_PRODUCTS_HIER_TL