eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.HRIBV_SUPV_HRCHY_X

Object Details

Object Name:	HRIBV_SUPV_HRCHY_X
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HRI.HRIBV_SUPV_HRCHY_X
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

This view allows Supervisor hierarchy Include Subordinate queries for all current Supervisor Hierarchies

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.HRIBV_SUPV_HRCHY_X references the following:

APPS: HRI_CS_SUPH_X_V; HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PER_PEOPLE_X

APPS.HRIBV_SUPV_HRCHY_X is referenced by following:

PUBLIC: HRIBV_SUPV_HRCHY_X