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

VIEW: APPS.IGF_AP_PERSON_MATCH_V

Object Details
Object Name: IGF_AP_PERSON_MATCH_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AP_PERSON_MATCH_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
APM_ID NUMBER (15) Yes
AMD_ID NUMBER (15) Yes
CSS_ID NUMBER (15)
SI_ID NUMBER (15)
RECORD_TYPE VARCHAR2 (10) Yes
DATE_RUN DATE
Yes
CI_CAL_TYPE VARCHAR2 (10) Yes
CI_SEQUENCE_NUMBER NUMBER (15) Yes
PERSON_ID NUMBER (15)
NAME VARCHAR2 (301)
SSN_MATCH NUMBER (15)
GIVEN_NAME_MATCH NUMBER (15)
SURNAME_MATCH NUMBER (15)
DOB_MATCH NUMBER (15)
ADDRESS_MATCH NUMBER (15)
CITY_MATCH NUMBER (15)
ZIP_MATCH NUMBER (15)
MATCH_SCORE NUMBER
Yes
RECORD_STATUS VARCHAR2 (30) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PERSON_NUMBER VARCHAR2 (30) Yes Person Identifier
Query Text

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


SELECT APM_ID
,      AMD_ID
,      CSS_ID
,      SI_ID
,      RECORD_TYPE
,      DATE_RUN
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      PERSON_ID
,      NAME
,      SSN_MATCH
,      GIVEN_NAME_MATCH
,      SURNAME_MATCH
,      DOB_MATCH
,      ADDRESS_MATCH
,      CITY_MATCH
,      ZIP_MATCH
,      MATCH_SCORE
,      RECORD_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERSON_NUMBER
FROM APPS.IGF_AP_PERSON_MATCH_V;

Dependencies

[top of page]

APPS.IGF_AP_PERSON_MATCH_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGF_AP_MATCH_DETAILS
ViewIGF_AP_PERSON_MATCH

APPS.IGF_AP_PERSON_MATCH_V is not referenced by any database object