VIEW: APPS.IGS_AD_ENQ_PERSON_V

Source

View Text - Preformatted

SELECT PE.ROW_ID, PE.PERSON_ID, PE.PERSON_NUMBER, PE.STAFF_MEMBER_IND, PE.STUDENT_IND, PE.ENCUMBERED_IND, PE.DECEASED_IND, PE.SURNAME, PE.MIDDLE_NAME, PE.SUFFIX, PE.PRE_NAME_ADJUNCT, PE.PRE_NAME_ADJUNCT_MEANING, PE.DECEASED_DATE, PE.GIVEN_NAMES, PE.SEX, PE.SEX_MEANING, PE.TITLE, PE.BIRTH_DT, PE.SALUTATION, PE.ORACLE_USERNAME, PE.EMAIL_ADDR, PE.ARCHIVE_EXCLUSION_IND, PE.ARCHIVE_DT, PE.PURGE_EXCLUSION_IND, PE.PURGE_DT, PE.FULL_NAME, PE. PREFERRED_NAME, PE.TITLE_NAME, PE.INITIAL_NAME, PE.INITIAL_LAST_NAME, PE.CONTEXT_BLOCK_NAME, PE.PREFERRED_GIVEN_NAME, PE.VETERAN, PE.MILITARY_SERVICE_REG, PE.LEVEL_OF_QUAL_ID, PE.LEVEL_OF_QUAL, PE.PROOF_OF_INS, PE.PROOF_OF_IMMU, PE.PERSON_ID_TYPE, PE.API_PERSON_ID, P.FUNNEL_STATUS, P.FUNNEL_STATUS_MEANING, PE.ATTRIBUTE_CATEGORY, PE.ATTRIBUTE1, PE.ATTRIBUTE2, PE.ATTRIBUTE3, PE.ATTRIBUTE4, PE.ATTRIBUTE5, PE.ATTRIBUTE6, PE.ATTRIBUTE7, PE.ATTRIBUTE8, PE.ATTRIBUTE9, PE.ATTRIBUTE10, PE.ATTRIBUTE11, PE.ATTRIBUTE12, PE.ATTRIBUTE13, PE.ATTRIBUTE14, PE.ATTRIBUTE15, PE.ATTRIBUTE16, PE.ATTRIBUTE17, PE.ATTRIBUTE18, PE.ATTRIBUTE19, PE.ATTRIBUTE20, PE.ATTRIBUTE21, PE.ATTRIBUTE22, PE.ATTRIBUTE23, PE.ATTRIBUTE24, PE.CREATED_BY, PE.CREATION_DATE, PE.LAST_UPDATED_BY, PE.LAST_UPDATE_DATE, PE.LAST_UPDATE_LOGIN FROM IGS_PE_PERSON_V PE, IGS_AD_PROSPECT_V P WHERE PE.PERSON_ID = P.PERSON_ID (+)

View Text - HTML Formatted

SELECT PE.ROW_ID
, PE.PERSON_ID
, PE.PERSON_NUMBER
, PE.STAFF_MEMBER_IND
, PE.STUDENT_IND
, PE.ENCUMBERED_IND
, PE.DECEASED_IND
, PE.SURNAME
, PE.MIDDLE_NAME
, PE.SUFFIX
, PE.PRE_NAME_ADJUNCT
, PE.PRE_NAME_ADJUNCT_MEANING
, PE.DECEASED_DATE
, PE.GIVEN_NAMES
, PE.SEX
, PE.SEX_MEANING
, PE.TITLE
, PE.BIRTH_DT
, PE.SALUTATION
, PE.ORACLE_USERNAME
, PE.EMAIL_ADDR
, PE.ARCHIVE_EXCLUSION_IND
, PE.ARCHIVE_DT
, PE.PURGE_EXCLUSION_IND
, PE.PURGE_DT
, PE.FULL_NAME
, PE. PREFERRED_NAME
, PE.TITLE_NAME
, PE.INITIAL_NAME
, PE.INITIAL_LAST_NAME
, PE.CONTEXT_BLOCK_NAME
, PE.PREFERRED_GIVEN_NAME
, PE.VETERAN
, PE.MILITARY_SERVICE_REG
, PE.LEVEL_OF_QUAL_ID
, PE.LEVEL_OF_QUAL
, PE.PROOF_OF_INS
, PE.PROOF_OF_IMMU
, PE.PERSON_ID_TYPE
, PE.API_PERSON_ID
, P.FUNNEL_STATUS
, P.FUNNEL_STATUS_MEANING
, PE.ATTRIBUTE_CATEGORY
, PE.ATTRIBUTE1
, PE.ATTRIBUTE2
, PE.ATTRIBUTE3
, PE.ATTRIBUTE4
, PE.ATTRIBUTE5
, PE.ATTRIBUTE6
, PE.ATTRIBUTE7
, PE.ATTRIBUTE8
, PE.ATTRIBUTE9
, PE.ATTRIBUTE10
, PE.ATTRIBUTE11
, PE.ATTRIBUTE12
, PE.ATTRIBUTE13
, PE.ATTRIBUTE14
, PE.ATTRIBUTE15
, PE.ATTRIBUTE16
, PE.ATTRIBUTE17
, PE.ATTRIBUTE18
, PE.ATTRIBUTE19
, PE.ATTRIBUTE20
, PE.ATTRIBUTE21
, PE.ATTRIBUTE22
, PE.ATTRIBUTE23
, PE.ATTRIBUTE24
, PE.CREATED_BY
, PE.CREATION_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON_V PE
, IGS_AD_PROSPECT_V P
WHERE PE.PERSON_ID = P.PERSON_ID (+)