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


VIEW: APPS.HR_HIER_ORG_PEOPLE_V

Object Details
Object Name: HR_HIER_ORG_PEOPLE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_HIER_ORG_PEOPLE_V
Subobject Name:
Status: VALID

View Type

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


People with organization details and place in organization hierarchy


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_NAME VARCHAR2 (240)
Organization name
ORGANIZATION_LOCATION_NAME VARCHAR2 (60)
Organization location
ORGANIZATION_INTERNAL_ADDRESS VARCHAR2 (80)
Organization Internal address line
ORGANIZATION_HIERARCHY_NAME VARCHAR2 (30)
Org hirearchy name
ORGANIZATION_HIERARCHY_VERSION NUMBER

Org hierarchy version
HIERARCHY_VERSION_START_DATE DATE

Hierarchy start date
HIERARCHY_VERSION_END_DATE DATE

Hierarchy end date
ORGANIZATION_TYPE VARCHAR2 (4000)
Organization type
FULL_NAME VARCHAR2 (240)
Person's full name
EMPLOYEE_NUMBER VARCHAR2 (30)
Person's employee number
KNOWN_AS VARCHAR2 (80)
Name person is known as
EMAIL_ADDRESS VARCHAR2 (240)
Person's email address
MAILSTOP VARCHAR2 (45)
Person's mailstop
WORK_PHONE_NUMBER VARCHAR2 (60)
Person's work phone number
BUSINESS_GROUP_NAME VARCHAR2 (240)
Business Group name
ORGANIZATION_ID NUMBER (15)
Organization
PARENT_ORGANIZATION_ID NUMBER

Parent Organization ni hierarchy
ORG_HIERARCHY_VERSION_ID NUMBER

Org hierarchy version identifier
Query Text

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


SELECT ORGANIZATION_NAME
,      ORGANIZATION_LOCATION_NAME
,      ORGANIZATION_INTERNAL_ADDRESS
,      ORGANIZATION_HIERARCHY_NAME
,      ORGANIZATION_HIERARCHY_VERSION
,      HIERARCHY_VERSION_START_DATE
,      HIERARCHY_VERSION_END_DATE
,      ORGANIZATION_TYPE
,      FULL_NAME
,      EMPLOYEE_NUMBER
,      KNOWN_AS
,      EMAIL_ADDRESS
,      MAILSTOP
,      WORK_PHONE_NUMBER
,      BUSINESS_GROUP_NAME
,      ORGANIZATION_ID
,      PARENT_ORGANIZATION_ID
,      ORG_HIERARCHY_VERSION_ID
FROM APPS.HR_HIER_ORG_PEOPLE_V;

Dependencies

[top of page]

APPS.HR_HIER_ORG_PEOPLE_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_HIER_ASG_PEOPLE_V
ViewHR_LOCATIONS
PL/SQL PackageHR_THIRD_PARTY_INTERFACE_PKG - show dependent code
SynonymPER_ORGANIZATION_STRUCTURES
SynonymPER_ORG_STRUCTURE_ELEMENTS
SynonymPER_ORG_STRUCTURE_VERSIONS
APPS.HR_HIER_ORG_PEOPLE_V is referenced by following:

SchemaPUBLIC
SynonymHR_HIER_ORG_PEOPLE_V