View: IGS_AD_APPL_ARP_V

Product:	IGS - Student System
Description:	View which contains the details of Review Profile, Review Profile Group and Application Details.
Implementation/DBA Data:	APPS.IGS_AD_APPL_ARP_V

View Text

SELECT AA.ROWID
, AA.APPL_ARP_ID
, AA.PERSON_ID
, AA.ADMISSION_APPL_NUMBER
, AA.NOMINATED_COURSE_CD
, AA.SEQUENCE_NUMBER
, AA.APPL_REV_PROFILE_ID
, RP.REVIEW_PROFILE_NAME
, RP.ARP_GR_CODE_MEANING
, AA.APPL_REVPROF_REVGR_ID
, RG.REVPROF_REVGR_CD
, RG.REVPROF_REVGR_NAME
, AA.REQUEST_ID
, AA.PROGRAM_APPLICATION_ID
, AA.PROGRAM_ID
, AA.PROGRAM_UPDATE_DATE
, AA.CREATED_BY
, AA.CREATION_DATE
, AA.LAST_UPDATED_BY
, AA.LAST_UPDATE_DATE
, AA.LAST_UPDATE_LOGIN
FROM IGS_AD_APPL_ARP AA
, IGS_AD_APL_REV_PRF_V RP
, IGS_AD_APL_RPRF_RGR RG
WHERE AA.APPL_REV_PROFILE_ID = RP.APPL_REV_PROFILE_ID
AND AA.APPL_REVPROF_REVGR_ID = RG.APPL_REVPROF_REVGR_ID(+)

Columns