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]

VIEW: APPS.FEM_DIS_GEOGRAPHY_HIER_VL

Object Details

Object Name:	FEM_DIS_GEOGRAPHY_HIER_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
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_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER
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)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      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_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      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
FROM APPS.FEM_DIS_GEOGRAPHY_HIER_VL;

Dependencies

[top of page]

APPS.FEM_DIS_GEOGRAPHY_HIER_VL references the following:

APPS: FEM_DIS_GEOGRAPHY_HIER_B; FEM_DIS_GEOGRAPHY_HIER_TL

APPS.FEM_DIS_GEOGRAPHY_HIER_VL is referenced by following:

APPS: FEM_DIS_GEOGRAPHY_HIER_DL; FEM_DIS_GEOGRAPHY_HIER_IL; FEM_DIS_GEOGRAPHY_HIER_UL