[Home] [Help] [Dependency Information]

VIEW: APPS.HR_ESTABLISHMENTS_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ESTABLISHMENT_ID
,      BUSINESS_GROUP_ID
,      NAME
,      DATE_FROM
,      DATE_TO
,      TYPE
,      INTERNAL_ADDRESS_LINE
,      COMMENTS
,      LOCATION_ID
,      EEO1_UNIT_NUMBER
,      VETS100_UNIT_NUMBER
,      EEO1_REPORTING_NAME
,      VETS100_REPORTING_NAME
,      SIC
,      ACTIVITY_LINE1
,      ACTIVITY_LINE2
,      ACTIVITY_LINE3
,      ACTIVITY_LINE4
,      APPRENTICES_EMPLOYED
,      NEW_ESTABLISHMENT
FROM APPS.HR_ESTABLISHMENTS_V;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS

HR_ORGANIZATION_INFORMATION

APPS

HR_PERSON_RECORD - show dependent code

HR_PERSON_RECORD - show dependent code

HR_PUMP_GET - show dependent code

HR_SCL_FLEX - show dependent code

HR_US_REPORTS - show dependent code

PER_US_VETC_TAP - show dependent code