[Home] [Help] [Dependency Information]
Object Name: | HRIBV_SUPV_HRCHY_X |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HRI.HRIBV_SUPV_HRCHY_X |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A Business Intelligence System view
This view allows Supervisor hierarchy Include Subordinate queries for all current Supervisor Hierarchies
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPERVISOR_BUSINESS_GROUP | VARCHAR2 | (240) | Yes | Business Group of the Supervisor |
SUPERVISOR_PERSON_NAME | VARCHAR2 | (240) | Person Name of the Supervisor | |
SUPERVISOR_LEVEL | NUMBER | (15) | Yes | Level of the Supervisor in the Supervisor Hierarchy |
SUPERVISOR_EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
SUBORDINATE_PERSON_NAME | VARCHAR2 | (240) | Person Name of the Supervised Person Assignment | |
SUBORDINATE_EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
SUBORDINATE_PRIMARY_ASG_FLAG | VARCHAR2 | (4000) | Primary Assignment Flag of the Supervised Person Assignment | |
SUBORD_PRIMARY_ASG_FLAG_CODE | VARCHAR2 | (1) | ||
SUBORDINATE_LEVEL | NUMBER | (15) | Yes | Level of the Supervised Person Assignment in the Supervisor Hierarchy |
SUPERVISOR_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group Identifier of the Supervisor |
SUPERVISOR_PERSON_ID | NUMBER | (15) | Yes | Person Identifier of the Supervisor |
SUPERVISOR_ASSIGNMENT_ID | NUMBER | (15) | Yes | |
SUBORDINATE_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
SUBORDINATE_PERSON_ID | NUMBER | (15) | Yes | Person Identifier of the Supervised Person Assignment |
SUBORDINATE_ASSIGNMENT_ID | NUMBER | (15) | Yes | Assignment Identifier of the Supervised Person Assignment |
Cut, paste (and edit) the following text to query this object:
SELECT SUPERVISOR_BUSINESS_GROUP
, SUPERVISOR_PERSON_NAME
, SUPERVISOR_LEVEL
, SUPERVISOR_EMPLOYEE_NUMBER
, SUBORDINATE_PERSON_NAME
, SUBORDINATE_EMPLOYEE_NUMBER
, SUBORDINATE_PRIMARY_ASG_FLAG
, SUBORD_PRIMARY_ASG_FLAG_CODE
, SUBORDINATE_LEVEL
, SUPERVISOR_BUSINESS_GROUP_ID
, SUPERVISOR_PERSON_ID
, SUPERVISOR_ASSIGNMENT_ID
, SUBORDINATE_BUSINESS_GROUP_ID
, SUBORDINATE_PERSON_ID
, SUBORDINATE_ASSIGNMENT_ID
FROM APPS.HRIBV_SUPV_HRCHY_X;
APPS.HRIBV_SUPV_HRCHY_X is not referenced by any database object
|
|
|