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

VIEW: APPS.HRI_CS_SUPH_V

Object Details
Object Name: HRI_CS_SUPH_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.


[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
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
PRIMARY_HIERARCHY_FLAG_CODE CHAR (1)
SUP_PERSON_ID NUMBER (15) Yes
SUP_ASSIGNMENT_ID NUMBER (15) Yes
SUB_PERSON_ID NUMBER (15) Yes
SUB_ASSIGNMENT_ID NUMBER (15) Yes
SUP_BUSINESS_GROUP_ID NUMBER (15) Yes
SUB_BUSINESS_GROUP_ID NUMBER (15) Yes
SUP_ASSIGNMENT_STATUS_TYPE_ID NUMBER

SUB_ASSIGNMENT_STATUS_TYPE_ID NUMBER

SUP_INVALID_FLAG_CODE VARCHAR2 (30)
SUB_INVALID_FLAG_CODE VARCHAR2 (30)
SUB_LEAF_FLAG_CODE VARCHAR2 (30)
LAST_CHANGE_DATE DATE
Yes
Query Text

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


SELECT SUP_ABSOLUTE_LEVEL
,      SUB_ABSOLUTE_LEVEL
,      SUB_RELATIVE_LEVEL
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PRIMARY_HIERARCHY_FLAG_CODE
,      SUP_PERSON_ID
,      SUP_ASSIGNMENT_ID
,      SUB_PERSON_ID
,      SUB_ASSIGNMENT_ID
,      SUP_BUSINESS_GROUP_ID
,      SUB_BUSINESS_GROUP_ID
,      SUP_ASSIGNMENT_STATUS_TYPE_ID
,      SUB_ASSIGNMENT_STATUS_TYPE_ID
,      SUP_INVALID_FLAG_CODE
,      SUB_INVALID_FLAG_CODE
,      SUB_LEAF_FLAG_CODE
,      LAST_CHANGE_DATE
FROM APPS.HRI_CS_SUPH_V;

Dependencies

[top of page]

APPS.HRI_CS_SUPH_V references the following:

SchemaAPPS
SynonymHRI_CS_SUPH
APPS.HRI_CS_SUPH_V is referenced by following:

SchemaAPPS
ViewHRI_CS_SUPHRO_V