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

VIEW: APPS.PJI_DIS_ORG_HRCHY_V

Object Details
Object Name: PJI_DIS_ORG_HRCHY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJI.PJI_DIS_ORG_HRCHY_V
Subobject Name:
Status: VALID

View Type

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


Organization hierarchy is based on the PJI reporting hierarchy specified in PJI setup. The absolute levels of the organizations in the hierarchy are also stored. This is a 2 level hierarchy.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Identifier for organization.
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization name
SUB_ORGANIZATION_ID NUMBER

Identifier for subordinate organization.
SUB_ORGANIZATION_NAME VARCHAR2 (240) Yes Subordinate organization name
ORGANIZATION_LEVEL NUMBER

Level of organization.
SUB_ORGANIZATION_LEVEL NUMBER

Level of subordinate organization
SUB_RELATIVE_LEVEL NUMBER

Subordinate relative level
Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_NAME
,      SUB_ORGANIZATION_ID
,      SUB_ORGANIZATION_NAME
,      ORGANIZATION_LEVEL
,      SUB_ORGANIZATION_LEVEL
,      SUB_RELATIVE_LEVEL
FROM APPS.PJI_DIS_ORG_HRCHY_V;

Dependencies

[top of page]

APPS.PJI_DIS_ORG_HRCHY_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymPJI_ORG_DENORM

APPS.PJI_DIS_ORG_HRCHY_V is not referenced by any database object