[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_GB_ADDRESSES

Object Details

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

View Type

A Business Intelligence System view

This view shows UK addresses for people in the enterprise,
displayed in a UK format. Only UK addresses are shown.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      ADDRESS_STYLE
,      ADDRESS_TYPE
,      PRIMARY_FLAG
,      ADDR_DATE_FROM
,      ADDR_DATE_TO
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDR_COMMENTS
,      COUNTRY
,      POST_CODE
,      COUNTY
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      TOWN
,      EMPLOYEE_NUMBER
,      CURRENT_EMPLOYEE_FLAG
,      CURRENT_APPLICANT_FLAG
,      PERSON_TYPE
,      EMPLOYEE_PERSON_TYPE
,      APPLICANT_PERSON_TYPE
,      USER_CONCAT_PERSON_TYPE
,      _DF
,      ADDRESS_STYLE_CODE
,      ADDRESS_TYPE_CODE
,      PRIMARY_FLAG_CODE
,      REGION1_CODE
,      CURRENT_EMPLOYEE_FLAG_CODE
,      CURRENT_APPLICANT_FLAG_CODE
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      PERSON_TYPE_ID
FROM APPS.HRFV_GB_ADDRESSES;

Dependencies

[top of page]

APPS

FND_TERRITORIES_TL

HRI_BPL_PERSON_TYPE - show dependent code

HR_ALL_ORGANIZATION_UNITS_TL

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PER_ADDRESSES

PER_PEOPLE_X

PER_PERSON_TYPES_TL

PUBLIC

HRFV_GB_ADDRESSES