VIEW: APPS.IGSBV_AD_ADM_APPL

Source

View Text - Preformatted

SELECT apl.PERSON_ID, p.PARTY_NUMBER, pp.PERSON_NAME, apl.ADMISSION_APPL_NUMBER, apl.APPL_DT, apl.ACAD_CAL_TYPE, apl.ACAD_CI_SEQUENCE_NUMBER, apl.ADM_CAL_TYPE, apl.ADM_CI_SEQUENCE_NUMBER, apl.ADMISSION_CAT, '_LA:apl.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING', apl.ADM_APPL_STATUS, apl.ADM_FEE_STATUS, '_LA:apl.TAC_APPL_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', apl.SPCL_GRP_1, apl.SPCL_GRP_2, '_LA:apl.COMMON_APP:IGS_LOOKUP_VALUES:YES_NO:MEANING', apl.APPLICATION_TYPE, apl.CHOICE_NUMBER, apl.ROUTEB_PREF, apl.APPLICATION_ID, apl.ALT_APPL_ID, apl.created_by, apl.creation_date, apl.last_updated_by, apl.last_update_date FROM igs_ad_appl_all apl, HZ_PARTIES P, HZ_PERSON_PROFILES PP WHERE apl.PERSON_ID = p.PARTY_ID AND P.PARTY_ID = PP.PARTY_ID AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED' AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE,SYSDATE) WITH READ ONLY

View Text - HTML Formatted

SELECT APL.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, APL.ADMISSION_APPL_NUMBER
, APL.APPL_DT
, APL.ACAD_CAL_TYPE
, APL.ACAD_CI_SEQUENCE_NUMBER
, APL.ADM_CAL_TYPE
, APL.ADM_CI_SEQUENCE_NUMBER
, APL.ADMISSION_CAT
, '_LA:APL.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING'
, APL.ADM_APPL_STATUS
, APL.ADM_FEE_STATUS
, '_LA:APL.TAC_APPL_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APL.SPCL_GRP_1
, APL.SPCL_GRP_2
, '_LA:APL.COMMON_APP:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APL.APPLICATION_TYPE
, APL.CHOICE_NUMBER
, APL.ROUTEB_PREF
, APL.APPLICATION_ID
, APL.ALT_APPL_ID
, APL.CREATED_BY
, APL.CREATION_DATE
, APL.LAST_UPDATED_BY
, APL.LAST_UPDATE_DATE
FROM IGS_AD_APPL_ALL APL
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
WHERE APL.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE) WITH READ ONLY