VIEW: APPS.IGSFV_PR_SDT_PR_RU_CK

Source

View Text - Preformatted

SELECT HP.PARTY_NAME, HP.PARTY_NUMBER, CRV.TITLE, CI.DESCRIPTION, PRGC.DESCRIPTION, SPRC.COURSE_CD, SPRC.PRG_CAL_TYPE, SPRC.PRG_CI_SEQUENCE_NUMBER, SPRC.RULE_CHECK_DT, SPRC.PROGRESSION_RULE_CAT, '_LA:SPRC.PASSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', SPRC.RULE_MESSAGE_TEXT, SPRC.PERSON_ID, SPRC.PRA_SEQUENCE_NUMBER, SPRC.CREATED_BY, SPRC.CREATION_DATE, SPRC.LAST_UPDATED_BY, SPRC.LAST_UPDATE_DATE FROM IGS_PR_SDT_PR_RU_CK_ALL SPRC, IGS_EN_STDNT_PS_ATT_ALL SCA, HZ_PARTIES HP, IGS_PS_VER_ALL CRV, IGS_CA_INST_ALL CI, IGS_PR_RU_CAT PRGC WHERE SPRC.PERSON_ID = HP.PARTY_ID AND SPRC.PERSON_ID = SCA.PERSON_ID AND SPRC.COURSE_CD = SCA.COURSE_CD AND SCA.COURSE_CD = CRV.COURSE_CD AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER AND SPRC.PRG_CAL_TYPE = CI.CAL_TYPE AND SPRC.PRG_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND SPRC.PROGRESSION_RULE_CAT = PRGC.PROGRESSION_RULE_CAT WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, CRV.TITLE
, CI.DESCRIPTION
, PRGC.DESCRIPTION
, SPRC.COURSE_CD
, SPRC.PRG_CAL_TYPE
, SPRC.PRG_CI_SEQUENCE_NUMBER
, SPRC.RULE_CHECK_DT
, SPRC.PROGRESSION_RULE_CAT
, '_LA:SPRC.PASSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SPRC.RULE_MESSAGE_TEXT
, SPRC.PERSON_ID
, SPRC.PRA_SEQUENCE_NUMBER
, SPRC.CREATED_BY
, SPRC.CREATION_DATE
, SPRC.LAST_UPDATED_BY
, SPRC.LAST_UPDATE_DATE
FROM IGS_PR_SDT_PR_RU_CK_ALL SPRC
, IGS_EN_STDNT_PS_ATT_ALL SCA
, HZ_PARTIES HP
, IGS_PS_VER_ALL CRV
, IGS_CA_INST_ALL CI
, IGS_PR_RU_CAT PRGC
WHERE SPRC.PERSON_ID = HP.PARTY_ID
AND SPRC.PERSON_ID = SCA.PERSON_ID
AND SPRC.COURSE_CD = SCA.COURSE_CD
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SPRC.PRG_CAL_TYPE = CI.CAL_TYPE
AND SPRC.PRG_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SPRC.PROGRESSION_RULE_CAT = PRGC.PROGRESSION_RULE_CAT WITH READ ONLY