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

VIEW: APPS.HRI_CS_SUPHRO_V

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

View Type

A Business Intelligence System view


Creates a structure linking 'PERSON' or 'ASSIGNMENT to Supervisor Level in the historic Supervisor Hierarchy with rollup..


[View Source]

Columns
Name Datatype Length Mandatory Comments
SUP_ABSOLUTE_LEVEL NUMBER (15) Yes
SUB_ABSOLUTE_LEVEL NUMBER (15) Yes
SUB_RELATIVE_LEVEL NUMBER
Yes
SUBRO_ABSOLUTE_LEVEL NUMBER (15) Yes
SUBRO_SUP_RELATIVE_LEVEL NUMBER
Yes
SUBRO_SUB_RELATIVE_LEVEL NUMBER

EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

PRIMARY_HIERARCHY_FLAG_CODE CHAR (1)
SUP_PERSON_ID NUMBER (15) Yes
SUP_ASSIGNMENT_ID NUMBER (15) Yes
SUB_ASSIGNMENT_ID NUMBER (15) Yes
SUB_PERSON_ID NUMBER (15) Yes
SUBRO_ASSIGNMENT_ID NUMBER (15) Yes
SUBRO_PERSON_ID NUMBER (15) Yes
SUP_BUSINESS_GROUP_ID NUMBER (15) Yes
SUB_BUSINESS_GROUP_ID NUMBER (15) Yes
SUBRO_BUSINESS_GROUP_ID NUMBER (15) Yes
LAST_CHANGE_DATE DATE

Query Text

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


SELECT SUP_ABSOLUTE_LEVEL
,      SUB_ABSOLUTE_LEVEL
,      SUB_RELATIVE_LEVEL
,      SUBRO_ABSOLUTE_LEVEL
,      SUBRO_SUP_RELATIVE_LEVEL
,      SUBRO_SUB_RELATIVE_LEVEL
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PRIMARY_HIERARCHY_FLAG_CODE
,      SUP_PERSON_ID
,      SUP_ASSIGNMENT_ID
,      SUB_ASSIGNMENT_ID
,      SUB_PERSON_ID
,      SUBRO_ASSIGNMENT_ID
,      SUBRO_PERSON_ID
,      SUP_BUSINESS_GROUP_ID
,      SUB_BUSINESS_GROUP_ID
,      SUBRO_BUSINESS_GROUP_ID
,      LAST_CHANGE_DATE
FROM APPS.HRI_CS_SUPHRO_V;

Dependencies

[top of page]

APPS.HRI_CS_SUPHRO_V references the following:

SchemaAPPS
ViewHRI_CS_SUPH_V
APPS.HRI_CS_SUPHRO_V is referenced by following:

SchemaAPPS
ViewPJI_DIS_SUP_ROHRCHY_V
SchemaPUBLIC
SynonymHRI_CS_SUPHRO_V