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

VIEW: APPS.IGF_AP_PERSON_MATCH

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


Retrieves the list of ISIR or Profile records which had a partial match with the person record present in the system


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Holds the ROWID
APM_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
RECORD_STATUS VARCHAR2 (30)
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)
Query Text

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


SELECT ROW_ID
,      APM_ID
,      CSS_ID
,      SI_ID
,      RECORD_TYPE
,      DATE_RUN
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      RECORD_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGF_AP_PERSON_MATCH;

Dependencies

[top of page]

APPS.IGF_AP_PERSON_MATCH references the following:

SchemaAPPS
SynonymIGF_AP_PERSON_MATCH_ALL
APPS.IGF_AP_PERSON_MATCH is referenced by following:

SchemaAPPS
Package BodyIGF_AP_MATCHING_PROCESS_PKG - show dependent code
ViewIGF_AP_PERSON_MATCH_V
Package BodyIGF_AP_PROFILE_MATCHING_PKG - show dependent code
PL/SQL PackageIGF_AP_PROFILE_MATCHING_PKG - show dependent code
ViewIGF_AP_REVIEW_DET_V
ViewIGF_AP_REVIEW_MAST_V