VIEW: APPS.IGSBV_STDNT_RECRUITMENT

Source

View Text - Preformatted

SELECT adr.RECRUITMENT_ID, adr.PERSON_ID, adr.SPECIAL_INTEREST_ID, adr.PRIORITY, adr.PROBABILITY, '_LA:adr.VIP:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:adr.DEACTIVATE_RECRUIT_STATUS:IGS_LOOKUP_VALUES:YES_NO:MEANING', adr.PROGRAM_INTEREST_ID, adr.INSTITUTION_SIZE_ID, adr.INSTITUTION_CONTROL_ID, adr.INSTITUTION_SETTING_ID, adr.INSTITUTION_LOCATION_ID, adr.SPECIAL_SERVICES_ID, adr.EMPLOYMENT_ID, adr.HOUSING_ID, adr.DEGREE_GOAL_ID, adr.UNIT_SET_ID, adr.CERTAINTY_OF_CHOICE_ID, adr.RELIGION_ID, adr.ADV_STUDIES_CLASSES, adr.HONORS_CLASSES, adr.CLASS_SIZE, adr.SEC_SCHOOL_LOCATION_ID, adr.PERCENT_PLAN_HIGHER_EDU, adr.RELIGION_CD, adr.CREATED_BY, adr.CREATION_DATE, adr.LAST_UPDATED_BY, adr.LAST_UPDATE_DATE FROM IGS_AD_RECRUITMENTS adr WITH READ ONLY

View Text - HTML Formatted

SELECT ADR.RECRUITMENT_ID
, ADR.PERSON_ID
, ADR.SPECIAL_INTEREST_ID
, ADR.PRIORITY
, ADR.PROBABILITY
, '_LA:ADR.VIP:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:ADR.DEACTIVATE_RECRUIT_STATUS:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ADR.PROGRAM_INTEREST_ID
, ADR.INSTITUTION_SIZE_ID
, ADR.INSTITUTION_CONTROL_ID
, ADR.INSTITUTION_SETTING_ID
, ADR.INSTITUTION_LOCATION_ID
, ADR.SPECIAL_SERVICES_ID
, ADR.EMPLOYMENT_ID
, ADR.HOUSING_ID
, ADR.DEGREE_GOAL_ID
, ADR.UNIT_SET_ID
, ADR.CERTAINTY_OF_CHOICE_ID
, ADR.RELIGION_ID
, ADR.ADV_STUDIES_CLASSES
, ADR.HONORS_CLASSES
, ADR.CLASS_SIZE
, ADR.SEC_SCHOOL_LOCATION_ID
, ADR.PERCENT_PLAN_HIGHER_EDU
, ADR.RELIGION_CD
, ADR.CREATED_BY
, ADR.CREATION_DATE
, ADR.LAST_UPDATED_BY
, ADR.LAST_UPDATE_DATE
FROM IGS_AD_RECRUITMENTS ADR WITH READ ONLY