VIEW: APPS.IGSFV_PERSON_PARTY

Source

View Text - Preformatted

SELECT HP.PARTY_ID, HP.PARTY_NUMBER, HP.PARTY_NAME, '_LA:HP.VALIDATED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', HP.PERSON_PRE_NAME_ADJUNCT, HP.PERSON_FIRST_NAME, HP.PERSON_MIDDLE_NAME, HP.PERSON_LAST_NAME, HP.PERSON_NAME_SUFFIX, HP.PERSON_TITLE, HP.PERSON_ACADEMIC_TITLE, HP.PERSON_IDEN_TYPE, HP.PERSON_IDENTIFIER, HP.EMAIL_ADDRESS, HP.SALUTATION, '_LA:PHP.DECEASED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:PHP.ARCHIVE_EXCLUSION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', PHP.ARCHIVE_DT, '_LA:PHP.PURGE_EXCLUSION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', PHP.PURGE_DT, PHP.ORACLE_USERNAME, '_LA:PHP.PROOF_OF_INS:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:PHP.PROOF_OF_IMMU:IGS_LOOKUP_VALUES:YES_NO:MEANING', PHP.LEVEL_OF_QUAL, '_LA:PHP.MILITARY_SERVICE_REG:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:PHP.VETERAN:IGS_LOOKUP_VALUES:VETERAN_STATUS:MEANING', '_LA:PHP.FUND_AUTHORIZATION:IGS_LOOKUP_VALUES:YES_NO:MEANING', PHP.BIRTH_CITY, PHP.BIRTH_COUNTRY, PHP.CREATED_BY, PHP.CREATION_DATE, PHP.LAST_UPDATED_BY, PHP.LAST_UPDATE_DATE, PHP.LAST_UPDATE_LOGIN FROM IGS_PE_HZ_PARTIES PHP, HZ_PARTIES HP WHERE HP.PARTY_ID = PHP.PARTY_ID AND HP.PARTY_TYPE = 'PERSON' WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, '_LA:HP.VALIDATED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, HP.PERSON_PRE_NAME_ADJUNCT
, HP.PERSON_FIRST_NAME
, HP.PERSON_MIDDLE_NAME
, HP.PERSON_LAST_NAME
, HP.PERSON_NAME_SUFFIX
, HP.PERSON_TITLE
, HP.PERSON_ACADEMIC_TITLE
, HP.PERSON_IDEN_TYPE
, HP.PERSON_IDENTIFIER
, HP.EMAIL_ADDRESS
, HP.SALUTATION
, '_LA:PHP.DECEASED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:PHP.ARCHIVE_EXCLUSION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, PHP.ARCHIVE_DT
, '_LA:PHP.PURGE_EXCLUSION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, PHP.PURGE_DT
, PHP.ORACLE_USERNAME
, '_LA:PHP.PROOF_OF_INS:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:PHP.PROOF_OF_IMMU:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, PHP.LEVEL_OF_QUAL
, '_LA:PHP.MILITARY_SERVICE_REG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:PHP.VETERAN:IGS_LOOKUP_VALUES:VETERAN_STATUS:MEANING'
, '_LA:PHP.FUND_AUTHORIZATION:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, PHP.BIRTH_CITY
, PHP.BIRTH_COUNTRY
, PHP.CREATED_BY
, PHP.CREATION_DATE
, PHP.LAST_UPDATED_BY
, PHP.LAST_UPDATE_DATE
, PHP.LAST_UPDATE_LOGIN
FROM IGS_PE_HZ_PARTIES PHP
, HZ_PARTIES HP
WHERE HP.PARTY_ID = PHP.PARTY_ID
AND HP.PARTY_TYPE = 'PERSON' WITH READ ONLY