VIEW: APPS.IGS_DA_REQ_STDNTS_V

Source

View Text - Preformatted

SELECT Dars.ROWID, dars.BATCH_ID, dars.IGS_DA_REQ_STDNTS_ID, dars.PERSON_ID, dars.PROGRAM_CODE, dars.WIF_PROGRAM_CODE, dars.SPECIAL_PROGRAM_CODE, dars.MAJOR_UNIT_SET_CD, dars.PROGRAM_MAJOR_CODE, dars.WIF_ID, dars.REPORT_TEXT, dars.ERROR_CODE, DECODE(dars.PROGRAM_CODE, NULL, NULL, ( SELECT title FROM igs_ps_Ver psv WHERE psv.course_cd = dars.program_code AND ROWNUM = 1) ) program_code_desc, DECODE (dars.wif_program_code, NULL, NULL, (SELECT title FROM igs_ps_ver psv WHERE psv.course_cd = dars.wif_program_code AND ROWNUM = 1) ) wif_program_code_desc, DECODE (dars.special_program_code, NULL, NULL, (SELECT meaning FROM igs_lookup_values lk WHERE lk.lookup_type = 'IGS_DA_SPCL_PRGMS' AND lk.lookup_code = dars.special_program_code) ) special_program_code_desc, igs_ge_gen_004.get_unit_set_title (dars.major_unit_set_cd) major_unit_set_code_desc, dars.creation_date, dars.created_by, dars.last_updated_by, dars.last_update_login, dars.last_update_date, pe.party_number, pe.party_name FROM igs_da_req_stdnts dars, hz_parties pe WHERE dars.person_id = pe.party_id

View Text - HTML Formatted

SELECT DARS.ROWID
, DARS.BATCH_ID
, DARS.IGS_DA_REQ_STDNTS_ID
, DARS.PERSON_ID
, DARS.PROGRAM_CODE
, DARS.WIF_PROGRAM_CODE
, DARS.SPECIAL_PROGRAM_CODE
, DARS.MAJOR_UNIT_SET_CD
, DARS.PROGRAM_MAJOR_CODE
, DARS.WIF_ID
, DARS.REPORT_TEXT
, DARS.ERROR_CODE
, DECODE(DARS.PROGRAM_CODE
, NULL
, NULL
, ( SELECT TITLE
FROM IGS_PS_VER PSV
WHERE PSV.COURSE_CD = DARS.PROGRAM_CODE
AND ROWNUM = 1) ) PROGRAM_CODE_DESC
, DECODE (DARS.WIF_PROGRAM_CODE
, NULL
, NULL
, (SELECT TITLE
FROM IGS_PS_VER PSV
WHERE PSV.COURSE_CD = DARS.WIF_PROGRAM_CODE
AND ROWNUM = 1) ) WIF_PROGRAM_CODE_DESC
, DECODE (DARS.SPECIAL_PROGRAM_CODE
, NULL
, NULL
, (SELECT MEANING
FROM IGS_LOOKUP_VALUES LK
WHERE LK.LOOKUP_TYPE = 'IGS_DA_SPCL_PRGMS'
AND LK.LOOKUP_CODE = DARS.SPECIAL_PROGRAM_CODE) ) SPECIAL_PROGRAM_CODE_DESC
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DARS.MAJOR_UNIT_SET_CD) MAJOR_UNIT_SET_CODE_DESC
, DARS.CREATION_DATE
, DARS.CREATED_BY
, DARS.LAST_UPDATED_BY
, DARS.LAST_UPDATE_LOGIN
, DARS.LAST_UPDATE_DATE
, PE.PARTY_NUMBER
, PE.PARTY_NAME
FROM IGS_DA_REQ_STDNTS DARS
, HZ_PARTIES PE
WHERE DARS.PERSON_ID = PE.PARTY_ID