[Home] [Help] [Dependency Information]

VIEW: APPS.HRIBV_ASGMVORGHRCHY

Object Details

Object Name:	HRIBV_ASGMVORGHRCHY
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HRI.HRIBV_ASGMVORGHRCHY
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 business view shows all employee assignment organization changes for all organization hierarchies in which the organization the assignment is moving from appears.

[View Source]

Columns

Query Text

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

SELECT MOVE_TYPE
,      GAIN_TYPE
,      LOSS_TYPE
,      ORGANIZATION_HRCHY_NAME
,      ORG_HIERARCHY_VERSION
,      TOP_ORGANIZATION_NAME
,      ORGANIZATION_NAME
,      OTHER_ORGANIZATION_NAME
,      FROM_ORGANIZATION_NAME
,      TO_ORGANIZATION_NAME
,      EMPLOYEE_NAME
,      ASSIGNMENT_NUMBER
,      CHANGE_DATE
,      ASG_EFFECTIVE_START_DATE
,      ASG_EFFECTIVE_END_DATE
,      OTHER_ASG_EFFECTIVE_START_DATE
,      OTHER_ASG_EFFECTIVE_END_DATE
,      HIERARCHY_VERSION_DATE_FROM
,      HIERARCHY_VERSION_DATE_TO
,      HIERARCHY_VERSION_DATE_TO_NN
,      MOVE_TYPE_CODE
,      GAIN_TYPE_CODE
,      LOSS_TYPE_CODE
,      ORGANIZATION_STRUCTURE_ID
,      ORG_STRUCTURE_VERSION_ID
,      PARENT_ORG_ID
,      ASSIGNMENT_ID
,      ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      OTHER_ORGANIZATION_ID
,      OTHER_BUSINESS_GROUP_ID
,      ORGANIZATION_FROM_ID
,      ORGANIZATION_TO_ID
FROM APPS.HRIBV_ASGMVORGHRCHY;

Dependencies

[top of page]

APPS

HRI_ORG_HRCHY_SUMMARY

HR_ALL_ORGANIZATION_UNITS_TL

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_SECURITY - show dependent code

PER_ALL_PEOPLE_F

PER_ASSIGNMENTS_F

PER_ORGANIZATION_STRUCTURES

PER_ORG_STRUCTURE_VERSIONS

APPS.HRIBV_ASGMVORGHRCHY is not referenced by any database object