View: IGS_AD_IMP_PAR_MATCHES_V

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_AD_IMP_PAR_MATCHES_V

View Text

SELECT NM.ROWID ROW_ID
, NM.INTERFACE_ID
, NM.PARTY_SITE_ID
, NM.ADDR_TYPE
, NM.PERSON_ID_TYPE
, NM.MATCH_SET_ID
, NM.MATCH_IND
, NM.PERSON_ID
, P.PERSON_NUMBER PERSON_NUMBER
, P.LAST_NAME
, P.FIRST_NAME
, P.GENDER
, DECODE ( P.GENDER
, NULL
, NULL
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE P.GENDER = LOOKUP_CODE
AND LOOKUP_TYPE = 'HZ_GENDER'
AND VIEW_APPLICATION_ID = 222
AND SECURITY_GROUP_ID = 0
AND LANGUAGE = USERENV('LANG') )) MEANING
, P.BIRTH_DATE
, PIT.API_PERSON_ID
, S.DECLARED_ETHNICITY
, DECODE ( S.DECLARED_ETHNICITY
, NULL
, NULL
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE S.DECLARED_ETHNICITY = LOOKUP_CODE
AND LOOKUP_TYPE = 'IGS_ETHNIC_ORIGIN'
AND VIEW_APPLICATION_ID = 8405
AND SECURITY_GROUP_ID = 0
AND LANGUAGE = USERENV('LANG') )) ETHNIC_ORIGIN_MEANING
, NM.CREATED_BY CREATED_BY
, NM.CREATION_DATE CREATION_DATE
, NM.LAST_UPDATED_BY LAST_UPDATED_BY
, NM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NM.REQUEST_ID REQUEST_ID
, NM.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, NM.PROGRAM_ID PROGRAM_ID
, NM.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, NM.NEAR_MTCH_ID NEAR_MTCH_ID
, NM.ACTION ACTION
FROM IGS_AD_IMP_NEAR_MTCH NM
, IGS_PE_PERSON_BASE_V P
, IGS_PE_PERSON_ID_TYPE_V PIT
, HZ_PERSON_PROFILES S
WHERE NM.PERSON_ID = P.PERSON_ID
AND P.PERSON_ID = S.PARTY_ID (+)
AND P.PERSON_ID = PIT.PE_PERSON_ID (+)
AND SYSDATE BETWEEN S.EFFECTIVE_START_DATE
AND NVL(S.EFFECTIVE_END_DATE
, SYSDATE)

Columns