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.GHG_ORG_HIERARCHY_STRUCTURES_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view stores information about organizations hierarchy structures

[View Source]

Columns

Name	Datatype	Length	Comments
ORGANIZATION_HIERARCHY_ID	NUMBER	(15)	Organization Hierarchy Identifier
ORGANIZATION_ID	NUMBER		Organization Identifier
LEVEL_01_ORGANIZATION_ID	NUMBER		Level 01 Organization Identifier
LEVEL_02_ORGANIZATION_ID	NUMBER		Level 02 Organization Identifier
LEVEL_03_ORGANIZATION_ID	NUMBER		Level 03 Organization Identifier
LEVEL_04_ORGANIZATION_ID	NUMBER		Level 04 Organization Identifier
LEVEL_05_ORGANIZATION_ID	NUMBER		Level 05 Organization Identifier
LEVEL_06_ORGANIZATION_ID	NUMBER		Level 06 Organization Identifier
LEVEL_07_ORGANIZATION_ID	NUMBER		Level 07 Organization Identifier
LEVEL_08_ORGANIZATION_ID	NUMBER		Level 08 Organization Identifier
LEVEL_09_ORGANIZATION_ID	NUMBER		Level 09 Organization Identifier
LEVEL_10_ORGANIZATION_ID	NUMBER		Level 10 Organization Identifier
LEVEL_11_ORGANIZATION_ID	NUMBER		Level 11 Organization Identifier
LEVEL_12_ORGANIZATION_ID	NUMBER		Level 12 Organization Identifier

Query Text

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


SELECT ORGANIZATION_HIERARCHY_ID
,      ORGANIZATION_ID
,      LEVEL_01_ORGANIZATION_ID
,      LEVEL_02_ORGANIZATION_ID
,      LEVEL_03_ORGANIZATION_ID
,      LEVEL_04_ORGANIZATION_ID
,      LEVEL_05_ORGANIZATION_ID
,      LEVEL_06_ORGANIZATION_ID
,      LEVEL_07_ORGANIZATION_ID
,      LEVEL_08_ORGANIZATION_ID
,      LEVEL_09_ORGANIZATION_ID
,      LEVEL_10_ORGANIZATION_ID
,      LEVEL_11_ORGANIZATION_ID
,      LEVEL_12_ORGANIZATION_ID
FROM APPS.GHG_ORG_HIERARCHY_STRUCTURES_V;

Dependencies

[top of page]

APPS.GHG_ORG_HIERARCHY_STRUCTURES_V references the following:

APPS: GHG_ORGANIZATIONS_ALL; PER_GEN_HIERARCHY; PER_GEN_HIERARCHY_NODES; PER_GEN_HIERARCHY_VERSIONS

APPS.GHG_ORG_HIERARCHY_STRUCTURES_V is not referenced by any database object