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

VIEW: APPS.JTF_RS_EMP_ADDRESS_VL

Object Details
Object Name: JTF_RS_EMP_ADDRESS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_RS_EMP_ADDRESS_VL
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view has employee address.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (10) Yes person Identifier
OFFICE_LOCATION VARCHAR2 (45)
Office Location of Employee
OFFICE_NUMBER VARCHAR2 (4000)
office phone number of employee
OFFICE_FAX_NUMBER VARCHAR2 (60)
Office Fax Number of Employee
HOME_STREET_ADDRESS VARCHAR2 (722)
Employee Home Street Address
HOME_CITY VARCHAR2 (30)
City where Employee Residence is.
HOME_COUNTRY VARCHAR2 (60)
Country where Employee Residence is.
HOME_POSTAL_CODE VARCHAR2 (30)
Employee residence Postal code
HOME_PHONE_NUMBER VARCHAR2 (60)
Employee Home phone number
HOME_FAX VARCHAR2 (60)
Employee Home fax
PAGER_NUMBER VARCHAR2 (60)
Employee Pager Number
MOBILE_NUMBER VARCHAR2 (60)
Employee Cell phone number
EMAIL_ADDRESS VARCHAR2 (240)
Employee's Email
BUSINESS_GROUP_ID NUMBER (15) Yes Employee Organization id
Query Text

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


SELECT PERSON_ID
,      OFFICE_LOCATION
,      OFFICE_NUMBER
,      OFFICE_FAX_NUMBER
,      HOME_STREET_ADDRESS
,      HOME_CITY
,      HOME_COUNTRY
,      HOME_POSTAL_CODE
,      HOME_PHONE_NUMBER
,      HOME_FAX
,      PAGER_NUMBER
,      MOBILE_NUMBER
,      EMAIL_ADDRESS
,      BUSINESS_GROUP_ID
FROM APPS.JTF_RS_EMP_ADDRESS_VL;

Dependencies

[top of page]

APPS.JTF_RS_EMP_ADDRESS_VL references the following:

SchemaAPPS
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_F
SynonymPER_PHONES

APPS.JTF_RS_EMP_ADDRESS_VL is not referenced by any database object