View: IGS_DA_REQ_STDNTS_V

Product:	IGS - Student System
Description:	View on top of igs_da_req_Stdnts
Implementation/DBA Data:	APPS.IGS_DA_REQ_STDNTS_V

View Text

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

Columns