VIEW: APPS.IGS_AD_APPL_V

Source

View Text - Preformatted

SELECT A.ROW_ID ROW_ID, P.PERSON_NUMBER PERSON_NUMBER, A.PERSON_ID PERSON_ID, A.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER, A.APPL_DT APPL_DT, A.ACAD_CAL_TYPE ACAD_CAL_TYPE, A.ACAD_CI_SEQUENCE_NUMBER ACAD_CI_SEQUENCE_NUMBER, A.ADMISSION_CAT ADMISSION_CAT, A.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE, A.ADM_APPL_STATUS ADM_APPL_STATUS, A.ADM_FEE_STATUS ADM_FEE_STATUS, A.TAC_APPL_IND TAC_APPL_IND, A.COMMON_APP COMMON_APP, CC1.NAME SPCL_GRP_1, CC1.DESCRIPTION SPCL_GRP_1_DESC, CC2.NAME SPCL_GRP_2, CC2.DESCRIPTION SPCL_GRP_2_DESC, A.CREATED_BY CREATED_BY, A.CREATION_DATE CREATION_DATE, A.LAST_UPDATED_BY LAST_UPDATED_BY, A.LAST_UPDATE_DATE LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, A.REQUEST_ID REQUEST_ID, A.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, A.PROGRAM_ID PROGRAM_ID, A.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE ,A .application_type application_type, A.choice_number choice_number, A.routeb_pref routeb_pref, A.application_id application_id, A.alt_appl_id alt_appl_id, A.Appl_fee_amt Appl_fee_amt FROM IGS_AD_APPL A, IGS_PE_PERSON_BASE_V P, IGS_AD_CODE_CLASSES CC1, IGS_AD_CODE_CLASSES CC2 WHERE A.PERSON_ID = P.PERSON_ID AND A.SPCL_GRP_1 = CC1.CODE_ID(+) AND CC1.CLASS(+) = 'SPECIAL_GROUP1' AND A.SPCL_GRP_2 = CC2.CODE_ID(+) AND CC2.CLASS(+) = 'SPECIAL_GROUP2'

View Text - HTML Formatted

SELECT A.ROW_ID ROW_ID
, P.PERSON_NUMBER PERSON_NUMBER
, A.PERSON_ID PERSON_ID
, A.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, A.APPL_DT APPL_DT
, A.ACAD_CAL_TYPE ACAD_CAL_TYPE
, A.ACAD_CI_SEQUENCE_NUMBER ACAD_CI_SEQUENCE_NUMBER
, A.ADMISSION_CAT ADMISSION_CAT
, A.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, A.ADM_APPL_STATUS ADM_APPL_STATUS
, A.ADM_FEE_STATUS ADM_FEE_STATUS
, A.TAC_APPL_IND TAC_APPL_IND
, A.COMMON_APP COMMON_APP
, CC1.NAME SPCL_GRP_1
, CC1.DESCRIPTION SPCL_GRP_1_DESC
, CC2.NAME SPCL_GRP_2
, CC2.DESCRIPTION SPCL_GRP_2_DESC
, A.CREATED_BY CREATED_BY
, A.CREATION_DATE CREATION_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, A.REQUEST_ID REQUEST_ID
, A.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, A.PROGRAM_ID PROGRAM_ID
, A.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, A .APPLICATION_TYPE APPLICATION_TYPE
, A.CHOICE_NUMBER CHOICE_NUMBER
, A.ROUTEB_PREF ROUTEB_PREF
, A.APPLICATION_ID APPLICATION_ID
, A.ALT_APPL_ID ALT_APPL_ID
, A.APPL_FEE_AMT APPL_FEE_AMT
FROM IGS_AD_APPL A
, IGS_PE_PERSON_BASE_V P
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
WHERE A.PERSON_ID = P.PERSON_ID
AND A.SPCL_GRP_1 = CC1.CODE_ID(+)
AND CC1.CLASS(+) = 'SPECIAL_GROUP1'
AND A.SPCL_GRP_2 = CC2.CODE_ID(+)
AND CC2.CLASS(+) = 'SPECIAL_GROUP2'