[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_HR_ORGANIZATIONS

Object Details

Object Name:	HRFV_HR_ORGANIZATIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_HR_ORGANIZATIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows the HR Organizations that have been defined for your enterprise.
Employees are assigned to and Applicants make job applications to HR Organizations.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      ORGANIZATION_NAME
,      DATE_FROM
,      DATE_TO
,      INTERNAL_ADDRESS
,      COMMENTS
,      DEFAULT_START_TIME
,      DEFAULT_END_TIME
,      WORKING_HOURS_AMOUNT
,      WORKING_HOURS_FREQUENCY
,      INTERNAL_EXTERNAL_FLAG
,      ORGANIZATION_TYPE
,      LOCATION_NAME
,      _DF
,      BUSINESS_GROUP_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      SOFT_CODING_KEYFLEX_ID
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
FROM APPS.HRFV_HR_ORGANIZATIONS;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS

HR_ALL_ORGANIZATION_UNITS_TL

HR_BIS - show dependent code

HR_LOCATIONS_ALL_TL

HR_ORGANIZATION_INFORMATION

APPS.HRFV_HR_ORGANIZATIONS is not referenced by any database object