Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View to obtain the values that have been choosen for Major , Minor and track options for explore program details. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PR.BATCH_ID
, PR.PROGRAM_CODE
, TR.TRACK_SEQ_NUM
, MJ.MAJOR_SEQ_NUM
, TR.TRACK_UNIT_SET
, TR.TRACK_OPTION_VERSION
, TR.TRACK_OPTION_CATALOG
, TR.ORG_UNIT_TRACK
, TR.TRACK_CAL_TYPE
, TR.TRACK_CI_SEQ_NUM
, MN1.MINOR_UNIT_SET MINOR_UNIT_SET1
, MN1.MINOR_VERSION
, MN1.MINOR_CATALOG
, MN1.ORG_UNIT_MINOR
, MN1.MINOR_CAL_TYPE
, MN1.MINOR_CI_SEQ_NUM
, MN2.MINOR_UNIT_SET MINOR_UNIT_SET2
, MN2.MINOR_VERSION
, MN2.MINOR_CATALOG
, MN2.ORG_UNIT_MINOR
, MN2.MINOR_CAL_TYPE
, MN2.MINOR_CI_SEQ_NUM
, MN3.MINOR_UNIT_SET MINOR_UNIT_SET3
, MN3.MINOR_VERSION
, MN3.MINOR_CATALOG
, MN3.ORG_UNIT_MINOR
, MN3.MINOR_CAL_TYPE
, MN3.MINOR_CI_SEQ_NUM
, MJ.MAJOR_UNIT_SET
, MJ.MAJOR_VERSION
, MJ.MAJOR_CATALOG
, MJ.ORG_UNIT_MAJOR
, MJ.MAJOR_CAL_TYPE
, MJ.MAJOR_CI_SEQ_NUM
, PR.PROGRAM_VERSION
FROM IGS_DA_REQ_WIFPRGS PR
, IGS_DA_REQ_WIFMJRS MJ
, IGS_DA_REQ_WIFMNRS MN1
, IGS_DA_REQ_WIFMNRS MN2
, IGS_DA_REQ_WIFMNRS MN3
, IGS_DA_REQ_WIFTRCKS TR
WHERE PR.BATCH_ID = MJ.BATCH_ID
AND MJ.BATCH_ID = MN1.BATCH_ID(+)
AND MJ.BATCH_ID = MN2.BATCH_ID(+)
AND MJ.BATCH_ID = MN3.BATCH_ID(+)
AND MJ.MAJOR_SEQ_NUM = MN1.MAJOR_SEQ_NUM(+)
AND MJ.MAJOR_SEQ_NUM = MN2.MAJOR_SEQ_NUM(+)
AND MJ.MAJOR_SEQ_NUM = MN3.MAJOR_SEQ_NUM(+)
AND MJ.MAJOR_SEQ_NUM = TR.MAJOR_SEQ_NUM(+)
AND MN1.MINOR_SEQ_NUM(+) = 1
AND MN2.MINOR_SEQ_NUM(+) = 2
AND MN3.MINOR_SEQ_NUM(+) = 3
AND MJ.BATCH_ID = TR.BATCH_ID(+) UNION SELECT PR.BATCH_ID
, PR.PROGRAM_CODE
, TR.TRACK_SEQ_NUM
, TR.MAJOR_SEQ_NUM
, TR.TRACK_UNIT_SET
, TR.TRACK_OPTION_VERSION
, TR.TRACK_OPTION_CATALOG
, TR.ORG_UNIT_TRACK
, TR.TRACK_CAL_TYPE
, TR.TRACK_CI_SEQ_NUM
, MN1.MINOR_UNIT_SET MINOR_UNIT_SET1
, MN1.MINOR_VERSION MINOR_VERSION1
, MN1.MINOR_CATALOG MINOR_CATALOG1
, MN1.ORG_UNIT_MINOR ORG_UNIT_MINOR1
, MN1.MINOR_CAL_TYPE MINOR_CAL_TYPE1
, MN1.MINOR_CI_SEQ_NUM MINOR_CI_SEQ_NUM1
, MN2.MINOR_UNIT_SET MINOR_UNIT_SET2
, MN2.MINOR_VERSION MINOR_VERSION2
, MN2.MINOR_CATALOG MINOR_CATALOG2
, MN2.ORG_UNIT_MINOR ORG_UNIT_MINOR2
, MN2.MINOR_CAL_TYPE MINOR_CAL_TYPE2
, MN2.MINOR_CI_SEQ_NUM MINOR_CI_SEQ_NUM2
, MN3.MINOR_UNIT_SET MINOR_UNIT_SET3
, MN3.MINOR_VERSION MINOR_VERSION3
, MN3.MINOR_CATALOG MINOR_CATALOG3
, MN3.ORG_UNIT_MINOR ORG_UNIT_MINOR3
, MN3.MINOR_CAL_TYPE MINOR_CAL_TYPE3
, MN3.MINOR_CI_SEQ_NUM MINOR_CI_SEQ_NUM3
, ''
, TO_NUMBER(NULL)
, ''
, ''
, ''
, TO_NUMBER(NULL)
, PR.PROGRAM_VERSION
FROM IGS_DA_REQ_WIFPRGS PR
, IGS_DA_REQ_WIFMNRS MN1
, IGS_DA_REQ_WIFMNRS MN2
, IGS_DA_REQ_WIFMNRS MN3
, IGS_DA_REQ_WIFTRCKS TR
WHERE PR.BATCH_ID = MN1.BATCH_ID(+)
AND PR.BATCH_ID = MN2.BATCH_ID(+)
AND PR.BATCH_ID = MN3.BATCH_ID(+)
AND MN1.MINOR_SEQ_NUM(+) = 1
AND MN2.MINOR_SEQ_NUM(+) = 2
AND MN3.MINOR_SEQ_NUM(+) = 3
AND PR.BATCH_ID = TR.BATCH_ID(+)
AND NOT EXISTS (SELECT 1
FROM IGS_DA_REQ_WIFMJRS MJ
WHERE PR.BATCH_ID = MJ.BATCH_ID )