DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.HRFV_GB_ADDRESSES

Object Details
Object Name: HRFV_GB_ADDRESSES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.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
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
PERSON_NAME VARCHAR2 (240)

ADDRESS_STYLE VARCHAR2 (80)

ADDRESS_TYPE VARCHAR2 (4000)

PRIMARY_FLAG VARCHAR2 (4000)

ADDR_DATE_FROM DATE
Yes
ADDR_DATE_TO DATE


ADDRESS_LINE1 VARCHAR2 (240)

ADDRESS_LINE2 VARCHAR2 (240)

ADDRESS_LINE3 VARCHAR2 (240)

ADDR_COMMENTS CLOB (4000)

COUNTRY VARCHAR2 (80)

POST_CODE VARCHAR2 (30)

COUNTY VARCHAR2 (4000)

TELEPHONE_NUMBER_1 VARCHAR2 (60)

TELEPHONE_NUMBER_2 VARCHAR2 (60)

TELEPHONE_NUMBER_3 VARCHAR2 (60)

TOWN VARCHAR2 (30)

EMPLOYEE_NUMBER VARCHAR2 (30)

CURRENT_EMPLOYEE_FLAG VARCHAR2 (4000)
CURRENT_APPLICANT_FLAG VARCHAR2 (4000)
PERSON_TYPE VARCHAR2 (80) Yes
EMPLOYEE_PERSON_TYPE VARCHAR2 (4000)
APPLICANT_PERSON_TYPE VARCHAR2 (4000)
USER_CONCAT_PERSON_TYPE VARCHAR2 (4000)
_DF CHAR (26)

ADDRESS_STYLE_CODE VARCHAR2 (30) Yes
ADDRESS_TYPE_CODE VARCHAR2 (30)
PRIMARY_FLAG_CODE VARCHAR2 (30) Yes
REGION1_CODE VARCHAR2 (120)
CURRENT_EMPLOYEE_FLAG_CODE VARCHAR2 (30)
CURRENT_APPLICANT_FLAG_CODE VARCHAR2 (30)
BUSINESS_GROUP_ID NUMBER (15)

PERSON_ID NUMBER (10)

PERSON_TYPE_ID NUMBER (15) Yes
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.HRFV_GB_ADDRESSES references the following:

SchemaAPPS
SynonymFND_TERRITORIES_TL
PL/SQL PackageHRI_BPL_PERSON_TYPE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ADDRESSES
ViewPER_PEOPLE_X
SynonymPER_PERSON_TYPES_TL

APPS.HRFV_GB_ADDRESSES is not referenced by any database object