VIEW: APPS.IGS_DA_REQ_WIF_V

Source

View Text - Preformatted

SELECT drw.rowid , drw.batch_id, drw.wif_id, drw.program_code, pv.title , drw.catalog_cal_type, drw.catalog_ci_seq_num, ci.description , ci.alternate_code , drw.major_unit_set_cd1, igs_ge_gen_004.get_unit_set_title (drw.major_unit_set_cd1), drw.major_unit_set_cd2, igs_ge_gen_004.get_unit_set_title (drw.major_unit_set_cd2), drw.major_unit_set_cd3, igs_ge_gen_004.get_unit_set_title (drw.major_unit_set_cd3), drw.minor_unit_set_cd1, igs_ge_gen_004.get_unit_set_title (drw.minor_unit_set_cd1), drw.minor_unit_set_cd2, igs_ge_gen_004.get_unit_set_title (drw.minor_unit_set_cd2), drw.minor_unit_set_cd3, igs_ge_gen_004.get_unit_set_title (drw.minor_unit_set_cd3), drw.track_unit_set_cd1, igs_ge_gen_004.get_unit_set_title (drw.track_unit_set_cd1), drw.track_unit_set_cd2, igs_ge_gen_004.get_unit_set_title (drw.track_unit_set_cd2), drw.track_unit_set_cd3, igs_ge_gen_004.get_unit_set_title (drw.track_unit_set_cd3), drw.creation_date, drw.created_by, drw.last_updated_by, drw.last_update_login, drw.last_update_date FROM igs_da_req_wif drw, igs_ps_ver pv, igs_ca_inst ci WHERE drw.program_code = pv.course_cd AND pv.version_number = (SELECT version_number FROM igs_ps_ver pv_in , igs_ps_stat ps WHERE ps.course_status = pv_in.course_status AND ps.s_course_status = 'ACTIVE' AND pv_in.course_cd = pv.course_cd AND rownum < 2) AND ci.cal_type = drw.catalog_cal_type AND ci.sequence_number = drw.catalog_ci_seq_num

View Text - HTML Formatted

SELECT DRW.ROWID
, DRW.BATCH_ID
, DRW.WIF_ID
, DRW.PROGRAM_CODE
, PV.TITLE
, DRW.CATALOG_CAL_TYPE
, DRW.CATALOG_CI_SEQ_NUM
, CI.DESCRIPTION
, CI.ALTERNATE_CODE
, DRW.MAJOR_UNIT_SET_CD1
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MAJOR_UNIT_SET_CD1)
, DRW.MAJOR_UNIT_SET_CD2
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MAJOR_UNIT_SET_CD2)
, DRW.MAJOR_UNIT_SET_CD3
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MAJOR_UNIT_SET_CD3)
, DRW.MINOR_UNIT_SET_CD1
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MINOR_UNIT_SET_CD1)
, DRW.MINOR_UNIT_SET_CD2
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MINOR_UNIT_SET_CD2)
, DRW.MINOR_UNIT_SET_CD3
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MINOR_UNIT_SET_CD3)
, DRW.TRACK_UNIT_SET_CD1
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.TRACK_UNIT_SET_CD1)
, DRW.TRACK_UNIT_SET_CD2
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.TRACK_UNIT_SET_CD2)
, DRW.TRACK_UNIT_SET_CD3
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.TRACK_UNIT_SET_CD3)
, DRW.CREATION_DATE
, DRW.CREATED_BY
, DRW.LAST_UPDATED_BY
, DRW.LAST_UPDATE_LOGIN
, DRW.LAST_UPDATE_DATE
FROM IGS_DA_REQ_WIF DRW
, IGS_PS_VER PV
, IGS_CA_INST CI
WHERE DRW.PROGRAM_CODE = PV.COURSE_CD
AND PV.VERSION_NUMBER = (SELECT VERSION_NUMBER
FROM IGS_PS_VER PV_IN
, IGS_PS_STAT PS
WHERE PS.COURSE_STATUS = PV_IN.COURSE_STATUS
AND PS.S_COURSE_STATUS = 'ACTIVE'
AND PV_IN.COURSE_CD = PV.COURSE_CD
AND ROWNUM < 2)
AND CI.CAL_TYPE = DRW.CATALOG_CAL_TYPE
AND CI.SEQUENCE_NUMBER = DRW.CATALOG_CI_SEQ_NUM