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

VIEW: APPS.HRI_CS_ORGHRO_V

Object Details
Object Name: HRI_CS_ORGHRO_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Creates a flattened Hierarchy Structure giving the relationships between 3 Organizations called:
1) Highest Organization - Superior Organization
2) Intermeditae Organization - Subordinate Organization
3) Lowest Oragnization - Subordinate Rollup Organization
for every Organizaiton Hierarchy version.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SUP_ORG_ABSOLUTE_LEVEL NUMBER (15) Yes
SUB_ORG_ABSOLUTE_LEVEL NUMBER (15) Yes
SUB_ORG_RELATIVE_LEVEL NUMBER

SUBRO_ORG_ABSOLUTE_LEVEL NUMBER (15) Yes
SUBRO_SUP_ORG_RELATIVE_LEVEL NUMBER

SUBRO_SUB_ORG_RELATIVE_LEVEL NUMBER

ORG_HIERARCHY_VERSION_ID NUMBER (15) Yes
SUP_ORGANIZATION_ID NUMBER (15) Yes
SUB_ORGANIZATION_ID NUMBER (15) Yes
SUBRO_ORGANIZATION_ID NUMBER (15) Yes
SUP_ORG_BUSINESS_GROUP_ID NUMBER (15)
SUB_ORG_BUSINESS_GROUP_ID NUMBER (15)
SUBRO_ORG_BUSINESS_GROUP_ID NUMBER (15)
LAST_CHANGE_DATE DATE

Query Text

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


SELECT SUP_ORG_ABSOLUTE_LEVEL
,      SUB_ORG_ABSOLUTE_LEVEL
,      SUB_ORG_RELATIVE_LEVEL
,      SUBRO_ORG_ABSOLUTE_LEVEL
,      SUBRO_SUP_ORG_RELATIVE_LEVEL
,      SUBRO_SUB_ORG_RELATIVE_LEVEL
,      ORG_HIERARCHY_VERSION_ID
,      SUP_ORGANIZATION_ID
,      SUB_ORGANIZATION_ID
,      SUBRO_ORGANIZATION_ID
,      SUP_ORG_BUSINESS_GROUP_ID
,      SUB_ORG_BUSINESS_GROUP_ID
,      SUBRO_ORG_BUSINESS_GROUP_ID
,      LAST_CHANGE_DATE
FROM APPS.HRI_CS_ORGHRO_V;

Dependencies

[top of page]

APPS.HRI_CS_ORGHRO_V references the following:

SchemaAPPS
SynonymHRI_ORG_HRCHY_SUMMARY

APPS.HRI_CS_ORGHRO_V is not referenced by any database object