[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_ORGANIZATION_HIERARCHIES

Object Details

Object Name:	HRFV_ORGANIZATION_HIERARCHIES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_ORGANIZATION_HIERARCHIES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows the organization hierarchies defined for your enterprise. If there are
multiple versions of an organization hierarchy, all versions are
included.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      CHILD_ORGANIZATION_NAME
,      PARENT_ORGANIZATION_NAME
,      ORGANIZATION_HIERARCHY_NAME
,      PRIMARY_HIERARCHY_FLAG
,      ORGANIZATION_HIERARCHY_LEVEL
,      NUMBER_OF_EMPLOYEES
,      HIERARCHY_VERSION_START_DATE
,      HIERARCHY_VERSION_END_DATE
,      ORGANIZATION_HIERARCHY_VERSION
,      BUSINESS_GROUP_ID
,      CHILD_ORGANIZATION_ID
,      ORGANIZATION_HIERARCHY_ID
,      ORG_HIERARCHY_VERSION_ID
,      PARENT_ORGANIZATION_ID
FROM APPS.HRFV_ORGANIZATION_HIERARCHIES;

Dependencies

[top of page]

APPS

HRBV_ORGANIZATION_DESCENDENTS

HR_ALL_ORGANIZATION_UNITS_TL

HR_BIS - show dependent code

PER_ORGANIZATION_STRUCTURES

PER_ORG_STRUCTURE_VERSIONS

PER_VIEWS_PKG - show dependent code

PUBLIC

HRFV_ORGANIZATION_HIERARCHIES