SELECT HZP.PARTY_NUMBER, '_LA:PAH.ACAD_HONOR_TYPE:IGS_LOOKUP_VALUES:PE_ACAD_HONORS:MEANING', PAH.HONOR_DATE, PAH.COMMENTS, PAH.ACAD_HONOR_ID, PAH.PERSON_ID, PAH.CREATION_DATE, PAH.CREATED_BY, PAH.LAST_UPDATED_BY, PAH.LAST_UPDATE_DATE FROM IGS_PE_ACAD_HONORS PAH, HZ_PARTIES HZP WHERE PAH.PERSON_ID=HZP.PARTY_ID WITH READ ONLY
SELECT HZP.PARTY_NUMBER
, '_LA:PAH.ACAD_HONOR_TYPE:IGS_LOOKUP_VALUES:PE_ACAD_HONORS:MEANING'
, PAH.HONOR_DATE
, PAH.COMMENTS
, PAH.ACAD_HONOR_ID
, PAH.PERSON_ID
, PAH.CREATION_DATE
, PAH.CREATED_BY
, PAH.LAST_UPDATED_BY
, PAH.LAST_UPDATE_DATE
FROM IGS_PE_ACAD_HONORS PAH
, HZ_PARTIES HZP
WHERE PAH.PERSON_ID=HZP.PARTY_ID WITH READ ONLY
|
|
|