Product: | IGS - Student System |
---|---|
Description: | This entity contains information about the person's credentials |
Implementation/DBA Data: | APPS.IGSFV_PERSON_CREDENTIALS |
SELECT '_LA:PEC.RATING_CODE:IGS_LOOKUP_VALUES:PE_CRE_RATING:MEANING'
, PEC.DATE_RECEIVED
, HZP2.PARTY_NUMBER
, PEC.REVIEWER_NOTES
, PEC.RECOMMENDER_NAME
, PEC.RECOMMENDER_TITLE
, PEC.RECOMMENDER_ORGANIZATION
, ADC.CREDENTIAL_TYPE
, ADC.DESCRIPTION
, HZP1.PARTY_NUMBER
, PEC.CREDENTIAL_ID
, PEC.PERSON_ID
, PEC.CREDENTIAL_TYPE_ID
, PEC.REVIEWER_ID
, PEC.CREATED_BY
, PEC.CREATION_DATE
, PEC.LAST_UPDATED_BY
, PEC.LAST_UPDATE_DATE
FROM IGS_PE_CREDENTIALS PEC
, HZ_PARTIES HZP1
, HZ_PARTIES HZP2
, IGS_AD_CRED_TYPES ADC
WHERE PEC.PERSON_ID=HZP1.PARTY_ID
AND PEC.CREDENTIAL_TYPE_ID=ADC.CREDENTIAL_TYPE_ID
AND PEC.REVIEWER_ID=HZP2.PARTY_ID(+) WITH READ ONLY