[Home] [Help] [Dependency Information]

VIEW: APPS.HR_FR_COMPANIES_V

Object Details

Object Name:	HR_FR_COMPANIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_FR_COMPANIES_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 ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      NAME
,      DATE_FROM
,      DATE_TO
,      INTERNAL_ADDRESS_LINE
,      LOCATION_ID
,      LOCATION_CODE
,      COMMENTS
,      SIREN
,      NAF_CODE
,      URSSAF_ORG_ID
,      URSSAF_NAME
,      DADS_ESTAB_ORG_ID
,      DADS_ESTAB_NAME
,      HQ_ESTABLISHMENTS_ID
,      HQ_ESTABLISHMENTS_NAME
,      PREVIOUS_SIREN
,      PREVIOUS_LOCATION_ID
,      PREVIOUS_LOCATION_END
,      PREVIOUS_NAF_CODE
,      PREVIOUS_NAME
,      ENABLED
FROM APPS.HR_FR_COMPANIES_V;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS

HR_ALL_ORGANIZATION_UNITS_TL

HR_GENERAL - show dependent code

HR_LOCATIONS

HR_ORGANIZATION_INFORMATION

PUBLIC

HR_FR_COMPANIES_V