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

VIEW: APPS.IGS_PE_DUP_MATCHES_PP_V

Object Details
Object Name: IGS_PE_DUP_MATCHES_PP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PE_DUP_MATCHES_PP_V
Subobject Name:
Status: VALID

View Type

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


IGS_PE_DUP_MATCHES_PP_V is used for the duplicate information about persons


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Person identifier
PERSON_NUMBER VARCHAR2 (30) Yes Person identifier
SURNAME VARCHAR2 (150)
Surname of the person
SURNAME_5_CHAR VARCHAR2 (0)
Obsolete
GIVEN_NAMES VARCHAR2 (150)
Given name of the person
GIVEN_NAME_1_CHAR VARCHAR2 (1)
Given name of the person
SEX VARCHAR2 (30)
Sex of the person
BIRTH_DT DATE

Birth date of the person
PREF_ALTERNATE_ID VARCHAR2 (20)
Preferable alternate identifier
API_PERSON_ID VARCHAR2 (20)
Alternate person identifier
PERSON_ID_TYPE VARCHAR2 (10)
Type of person identifier
PREFERRED_IND VARCHAR2 (0)
Flag indicates whether the person id type is preferred or not
ETHNIC_ORIGIN VARCHAR2 (60)
Ethnic origin of the person
STATUS VARCHAR2 (1) Yes Party status flag
API_START_DATE DATE

Start Date of the Alternate Person ID
API_END_DATE DATE

End Date of the Alternate Person ID
Query Text

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


SELECT PERSON_ID
,      PERSON_NUMBER
,      SURNAME
,      SURNAME_5_CHAR
,      GIVEN_NAMES
,      GIVEN_NAME_1_CHAR
,      SEX
,      BIRTH_DT
,      PREF_ALTERNATE_ID
,      API_PERSON_ID
,      PERSON_ID_TYPE
,      PREFERRED_IND
,      ETHNIC_ORIGIN
,      STATUS
,      API_START_DATE
,      API_END_DATE
FROM APPS.IGS_PE_DUP_MATCHES_PP_V;

Dependencies

[top of page]

APPS.IGS_PE_DUP_MATCHES_PP_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_PERSON_PROFILES
SynonymIGS_PE_ALT_PERS_ID
ViewIGS_PE_PERSON_ID_TYPE_V

APPS.IGS_PE_DUP_MATCHES_PP_V is not referenced by any database object