VIEW: APPS.IGS_AD_APPL_ARP_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)