VIEW: APPS.IGF_GR_PERSON_V

Source

View Text - Preformatted

SELECT fa.row_id, fa.base_id, fa.person_id person_id, p.party_number person_number, P.PARTY_NAME PERSON_NAME, P.PERSON_LAST_NAME SURNAME, P.PERSON_FIRST_NAME GIVEN_NAMES, P.PERSON_MIDDLE_NAME MIDDLE_NAME, PP.DATE_OF_BIRTH BIRTH_DT, fa.ci_cal_type, fa.ci_sequence_number, API.API_PERSON_ID API_PERSON_ID, fa.created_by, fa.creation_date, fa.last_updated_by, fa.last_update_date, fa.last_update_login FROM igf_ap_fa_base_rec fa, HZ_PARTIES P, HZ_PERSON_PROFILES PP, IGS_PE_ALT_PERS_ID API, IGS_PE_PERSON_ID_TYP PIT WHERE fa.person_id = p.party_id and fa.person_id = PP.PARTY_ID (+) AND fa.person_id = API.PE_PERSON_ID(+) and ( SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE,SYSDATE)) AND ( SYSDATE BETWEEN NVL(API.START_DT,SYSDATE) AND NVL(API.END_DT,SYSDATE)) AND API.PERSON_ID_TYPE = PIT.PERSON_ID_TYPE AND PIT.S_PERSON_ID_TYPE = 'SSN'

View Text - HTML Formatted

SELECT FA.ROW_ID
, FA.BASE_ID
, FA.PERSON_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, P.PARTY_NAME PERSON_NAME
, P.PERSON_LAST_NAME SURNAME
, P.PERSON_FIRST_NAME GIVEN_NAMES
, P.PERSON_MIDDLE_NAME MIDDLE_NAME
, PP.DATE_OF_BIRTH BIRTH_DT
, FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, API.API_PERSON_ID API_PERSON_ID
, FA.CREATED_BY
, FA.CREATION_DATE
, FA.LAST_UPDATED_BY
, FA.LAST_UPDATE_DATE
, FA.LAST_UPDATE_LOGIN
FROM IGF_AP_FA_BASE_REC FA
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_PE_ALT_PERS_ID API
, IGS_PE_PERSON_ID_TYP PIT
WHERE FA.PERSON_ID = P.PARTY_ID
AND FA.PERSON_ID = PP.PARTY_ID (+)
AND FA.PERSON_ID = API.PE_PERSON_ID(+)
AND ( SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE))
AND ( SYSDATE BETWEEN NVL(API.START_DT
, SYSDATE)
AND NVL(API.END_DT
, SYSDATE))
AND API.PERSON_ID_TYPE = PIT.PERSON_ID_TYPE
AND PIT.S_PERSON_ID_TYPE = 'SSN'