VIEW: APPS.IGS_SS_PERSON_SEARCH_V

Source

View Text - Preformatted

SELECT pe.person_id, pe.person_number, pe.full_name, pe.surname, pe.middle_name, pe.given_names, pe.preferred_name, pe.preferred_given_name, pe.sex_meaning sex, pe.birth_dt, pe.email_addr, pe.title, pe.suffix, pe.pre_name_adjunct prefix, pe.salutation, pe.deceased_ind, api.start_dt, api.end_dt, api.api_person_id, api.person_id_type, pid.description, pid.preferred_ind, igs_pe_val_pigm.merged_ind (pe.person_id) display_ob_ind, addr.addr_type, addr.addr_line_1, addr.addr_line_2, addr.addr_line_3, addr.addr_line_4, addr.city, addr.state, addr.province, addr.county, addr.country, addr.postal_code, addr.start_dt, addr.end_dt, pe.created_by, pe.creation_date, pe.last_updated_by, pe.last_update_date, pe.last_update_login FROM igs_pe_person pe, igs_pe_alt_pers_id api, igs_pe_person_id_typ pid, igs_pe_person_addr addr WHERE pe.person_id = api.pe_person_id(+) AND pe.person_id = addr.person_id(+) AND api.person_id_type = pid.person_id_type(+)

View Text - HTML Formatted

SELECT PE.PERSON_ID
, PE.PERSON_NUMBER
, PE.FULL_NAME
, PE.SURNAME
, PE.MIDDLE_NAME
, PE.GIVEN_NAMES
, PE.PREFERRED_NAME
, PE.PREFERRED_GIVEN_NAME
, PE.SEX_MEANING SEX
, PE.BIRTH_DT
, PE.EMAIL_ADDR
, PE.TITLE
, PE.SUFFIX
, PE.PRE_NAME_ADJUNCT PREFIX
, PE.SALUTATION
, PE.DECEASED_IND
, API.START_DT
, API.END_DT
, API.API_PERSON_ID
, API.PERSON_ID_TYPE
, PID.DESCRIPTION
, PID.PREFERRED_IND
, IGS_PE_VAL_PIGM.MERGED_IND (PE.PERSON_ID) DISPLAY_OB_IND
, ADDR.ADDR_TYPE
, ADDR.ADDR_LINE_1
, ADDR.ADDR_LINE_2
, ADDR.ADDR_LINE_3
, ADDR.ADDR_LINE_4
, ADDR.CITY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.COUNTY
, ADDR.COUNTRY
, ADDR.POSTAL_CODE
, ADDR.START_DT
, ADDR.END_DT
, PE.CREATED_BY
, PE.CREATION_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON PE
, IGS_PE_ALT_PERS_ID API
, IGS_PE_PERSON_ID_TYP PID
, IGS_PE_PERSON_ADDR ADDR
WHERE PE.PERSON_ID = API.PE_PERSON_ID(+)
AND PE.PERSON_ID = ADDR.PERSON_ID(+)
AND API.PERSON_ID_TYPE = PID.PERSON_ID_TYPE(+)