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

VIEW: APPS.PER_CONTACT_EXTRA_INFO_D

Object Details
Object Name: PER_CONTACT_EXTRA_INFO_D
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_CONTACT_EXTRA_INFO_D
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
Name Datatype Length Mandatory Comments
CONTACT_EXTRA_INFO_ID NUMBER (15) Yes System-generated primary key column.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
EMPLOYEE VARCHAR2 (240)
The full name of employee.
CONTACT VARCHAR2 (240)
The full name of contact person.
CONTACT_TYPE VARCHAR2 (80)
Relationship between employee and contact.
INFORMATION_TYPE VARCHAR2 (240)
Description of the contact information type.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_BY VARCHAR2 (100)
The name of user who update the row last.
Query Text

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


SELECT CONTACT_EXTRA_INFO_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EMPLOYEE
,      CONTACT
,      CONTACT_TYPE
,      INFORMATION_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.PER_CONTACT_EXTRA_INFO_D;

Dependencies

[top of page]

APPS.PER_CONTACT_EXTRA_INFO_D references the following:

SchemaAPPS
SynonymFND_USER
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPER_ALL_PEOPLE_F
SynonymPER_CONTACT_EXTRA_INFO_F
SynonymPER_CONTACT_INFO_TYPES_TL
SynonymPER_CONTACT_RELATIONSHIPS
APPS.PER_CONTACT_EXTRA_INFO_D is referenced by following:

SchemaPUBLIC
SynonymPER_CONTACT_EXTRA_INFO_D