VIEW: APPS.IGS_PR_SPRC_SCA_V

Source

View Text - Preformatted

SELECT SPRC.PERSON_ID, SPRC.COURSE_CD, SPRC.PRG_CAL_TYPE, SPRC.PRG_CI_SEQUENCE_NUMBER, SPRC.RULE_CHECK_DT, SPRC.PROGRESSION_RULE_CAT, SPRC.PRA_SEQUENCE_NUMBER, PE.PARTY_NUMBER FROM IGS_PR_SDT_PR_RU_CK sprc, HZ_PARTIES PE WHERE PE.PARTY_ID = sprc.PERSON_ID UNION SELECT SCA.PERSON_ID, SCA.COURSE_CD, CI.CAL_TYPE, CI.SEQUENCE_NUMBER, TO_DATE(NULL), TO_CHAR(NULL), TO_NUMBER(NULL), PE.PARTY_NUMBER FROM IGS_EN_STDNT_PS_ATT SCA, IGS_CA_TYPE CAT, IGS_CA_INST CI, HZ_PARTIES PE WHERE CI.CAL_TYPE = CAT.CAL_TYPE AND CAT.S_CAL_CAT = 'PROGRESS' AND PE.PARTY_ID = SCA.PERSON_ID

View Text - HTML Formatted

SELECT SPRC.PERSON_ID
, SPRC.COURSE_CD
, SPRC.PRG_CAL_TYPE
, SPRC.PRG_CI_SEQUENCE_NUMBER
, SPRC.RULE_CHECK_DT
, SPRC.PROGRESSION_RULE_CAT
, SPRC.PRA_SEQUENCE_NUMBER
, PE.PARTY_NUMBER
FROM IGS_PR_SDT_PR_RU_CK SPRC
, HZ_PARTIES PE
WHERE PE.PARTY_ID = SPRC.PERSON_ID UNION SELECT SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, PE.PARTY_NUMBER
FROM IGS_EN_STDNT_PS_ATT SCA
, IGS_CA_TYPE CAT
, IGS_CA_INST CI
, HZ_PARTIES PE
WHERE CI.CAL_TYPE = CAT.CAL_TYPE
AND CAT.S_CAL_CAT = 'PROGRESS'
AND PE.PARTY_ID = SCA.PERSON_ID