VIEW: APPS.IGS_AD_RECRUITMENT_V

Source

View Text - Preformatted

SELECT R.ROWID ROW_ID, R.PERSON_ID PERSON_ID, R.RECRUITMENT_ID RECRUITMENT_ID, R.SPECIAL_INTEREST_ID SPECIAL_INTEREST_ID, CC1.NAME SPECIAL_INTEREST, CC1.DESCRIPTION SPECIAL_INTEREST_DESC, R.PRIORITY PRIORITY, R.PROBABILITY PROBABILITY, R.VIP VIP, R.DEACTIVATE_RECRUIT_STATUS DEACTIVATE_RECRUIT_STATUS, R.RELIGION_CD RELIGION, CC2.MEANING RELIGION_DESC, R.PROGRAM_INTEREST_ID PROGRAM_INTEREST_ID, CC3.NAME PROGRAM_INTEREST, CC3.DESCRIPTION PROGRAM_INTEREST_DESC, R.INSTITUTION_SIZE_ID INSTITUTION_SIZE_ID, CC4.NAME INSTITUTION_SIZE, CC4.DESCRIPTION INSTITUTION_SIZE_DESC, R.INSTITUTION_CONTROL_ID INSTITUTION_CONTROL_ID, CC5.NAME INSTITUTION_CONTROL, CC5. DESCRIPTION INSTITUTION_CONTROL_DESC, R.INSTITUTION_SETTING_ID INSTITUTION_SETTING_ID, CC6.NAME INSTITUTION_SETTING, CC6. DESCRIPTION INSTITUTION_SETTING_DESC, R.INSTITUTION_LOCATION_ID INSTITUTION_LOCATION_ID, CC7.NAME INSTITUTION_LOCATION, CC7.DESCRIPTION INSTITUTION_LOCATION_DESC, R.SPECIAL_SERVICES_ID SPECIAL_SERVICES_ID, CC8.NAME SPECIAL_SERVICES, CC8.DESCRIPTION SPECIAL_SERVICES_DESC, R.EMPLOYMENT_ID EMPLOYMENT_ID, CC9.NAME EMPLOYMENT, CC9.DESCRIPTION EMPLOYMENT_DESC, R.HOUSING_ID HOUSING_ID, CC10.NAME HOUSING, CC10.DESCRIPTION HOUSING_DESC, R.DEGREE_GOAL_ID DEGREE_GOAL_ID, CC11.NAME DEGREE_GOAL, CC11.DESCRIPTION DEGREE_GOAL_DESC, R.UNIT_SET_ID UNIT_SET_ID, CC12.NAME UNIT_SET, CC12.DESCRIPTION UNIT_SET_DESC, R.CERTAINTY_OF_CHOICE_ID CERTAINTY_OF_CHOICE_ID, CC13.NAME CERTAINTY_OF_CHOICE, CC13.DESCRIPTION CERTAINTY_OF_CHOICE_DESC, R.ADV_STUDIES_CLASSES ADV_STUDIES_CLASSES, R.HONORS_CLASSES HONORS_CLASSES, R.CLASS_SIZE CLASS_SIZE, R.SEC_SCHOOL_LOCATION_ID SEC_SCHOOL_LOCATION_ID, CC14.NAME SEC_SCHOOL_LOCATION, CC14.DESCRIPTION SEC_SCHOOL_LOCATION_DESC, R.PERCENT_PLAN_HIGHER_EDU PERCENT_PLAN_HIGHER_EDU, R.CREATED_BY CREATED_BY, R.CREATION_DATE CREATION_DATE, R.LAST_UPDATED_BY LAST_UPDATED_BY, R.LAST_UPDATE_DATE LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_RECRUITMENTS R, IGS_AD_CODE_CLASSES CC1, IGS_LOOKUP_VALUES CC2, IGS_AD_CODE_CLASSES CC3, IGS_AD_CODE_CLASSES CC4, IGS_AD_CODE_CLASSES CC5, IGS_AD_CODE_CLASSES CC6, IGS_AD_CODE_CLASSES CC7, IGS_AD_CODE_CLASSES CC8, IGS_AD_CODE_CLASSES CC9, IGS_AD_CODE_CLASSES CC10, IGS_AD_CODE_CLASSES CC11, IGS_AD_CODE_CLASSES CC12, IGS_AD_CODE_CLASSES CC13, IGS_AD_CODE_CLASSES CC14 WHERE R.SPECIAL_INTEREST_ID = CC1.CODE_ID(+) AND R.RELIGION_CD = CC2.LOOKUP_CODE(+) AND CC2.LOOKUP_TYPE(+) = 'PE_RELIGION' AND R.PROGRAM_INTEREST_ID = CC3.CODE_ID(+) AND R.INSTITUTION_SIZE_ID = CC4.CODE_ID(+) AND R.INSTITUTION_CONTROL_ID = CC5.CODE_ID(+) AND R.INSTITUTION_SETTING_ID = CC6.CODE_ID(+) AND R.INSTITUTION_LOCATION_ID = CC7.CODE_ID(+) AND R.SPECIAL_SERVICES_ID = CC8.CODE_ID(+) AND R.EMPLOYMENT_ID = CC9.CODE_ID(+) AND R.HOUSING_ID = CC10.CODE_ID(+) AND R.DEGREE_GOAL_ID = CC11.CODE_ID(+) AND R.UNIT_SET_ID = CC12.CODE_ID(+) AND R.CERTAINTY_OF_CHOICE_ID = CC13.CODE_ID(+) AND R.SEC_SCHOOL_LOCATION_ID = CC14.CODE_ID(+)

View Text - HTML Formatted

SELECT R.ROWID ROW_ID
, R.PERSON_ID PERSON_ID
, R.RECRUITMENT_ID RECRUITMENT_ID
, R.SPECIAL_INTEREST_ID SPECIAL_INTEREST_ID
, CC1.NAME SPECIAL_INTEREST
, CC1.DESCRIPTION SPECIAL_INTEREST_DESC
, R.PRIORITY PRIORITY
, R.PROBABILITY PROBABILITY
, R.VIP VIP
, R.DEACTIVATE_RECRUIT_STATUS DEACTIVATE_RECRUIT_STATUS
, R.RELIGION_CD RELIGION
, CC2.MEANING RELIGION_DESC
, R.PROGRAM_INTEREST_ID PROGRAM_INTEREST_ID
, CC3.NAME PROGRAM_INTEREST
, CC3.DESCRIPTION PROGRAM_INTEREST_DESC
, R.INSTITUTION_SIZE_ID INSTITUTION_SIZE_ID
, CC4.NAME INSTITUTION_SIZE
, CC4.DESCRIPTION INSTITUTION_SIZE_DESC
, R.INSTITUTION_CONTROL_ID INSTITUTION_CONTROL_ID
, CC5.NAME INSTITUTION_CONTROL
, CC5. DESCRIPTION INSTITUTION_CONTROL_DESC
, R.INSTITUTION_SETTING_ID INSTITUTION_SETTING_ID
, CC6.NAME INSTITUTION_SETTING
, CC6. DESCRIPTION INSTITUTION_SETTING_DESC
, R.INSTITUTION_LOCATION_ID INSTITUTION_LOCATION_ID
, CC7.NAME INSTITUTION_LOCATION
, CC7.DESCRIPTION INSTITUTION_LOCATION_DESC
, R.SPECIAL_SERVICES_ID SPECIAL_SERVICES_ID
, CC8.NAME SPECIAL_SERVICES
, CC8.DESCRIPTION SPECIAL_SERVICES_DESC
, R.EMPLOYMENT_ID EMPLOYMENT_ID
, CC9.NAME EMPLOYMENT
, CC9.DESCRIPTION EMPLOYMENT_DESC
, R.HOUSING_ID HOUSING_ID
, CC10.NAME HOUSING
, CC10.DESCRIPTION HOUSING_DESC
, R.DEGREE_GOAL_ID DEGREE_GOAL_ID
, CC11.NAME DEGREE_GOAL
, CC11.DESCRIPTION DEGREE_GOAL_DESC
, R.UNIT_SET_ID UNIT_SET_ID
, CC12.NAME UNIT_SET
, CC12.DESCRIPTION UNIT_SET_DESC
, R.CERTAINTY_OF_CHOICE_ID CERTAINTY_OF_CHOICE_ID
, CC13.NAME CERTAINTY_OF_CHOICE
, CC13.DESCRIPTION CERTAINTY_OF_CHOICE_DESC
, R.ADV_STUDIES_CLASSES ADV_STUDIES_CLASSES
, R.HONORS_CLASSES HONORS_CLASSES
, R.CLASS_SIZE CLASS_SIZE
, R.SEC_SCHOOL_LOCATION_ID SEC_SCHOOL_LOCATION_ID
, CC14.NAME SEC_SCHOOL_LOCATION
, CC14.DESCRIPTION SEC_SCHOOL_LOCATION_DESC
, R.PERCENT_PLAN_HIGHER_EDU PERCENT_PLAN_HIGHER_EDU
, R.CREATED_BY CREATED_BY
, R.CREATION_DATE CREATION_DATE
, R.LAST_UPDATED_BY LAST_UPDATED_BY
, R.LAST_UPDATE_DATE LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_RECRUITMENTS R
, IGS_AD_CODE_CLASSES CC1
, IGS_LOOKUP_VALUES CC2
, IGS_AD_CODE_CLASSES CC3
, IGS_AD_CODE_CLASSES CC4
, IGS_AD_CODE_CLASSES CC5
, IGS_AD_CODE_CLASSES CC6
, IGS_AD_CODE_CLASSES CC7
, IGS_AD_CODE_CLASSES CC8
, IGS_AD_CODE_CLASSES CC9
, IGS_AD_CODE_CLASSES CC10
, IGS_AD_CODE_CLASSES CC11
, IGS_AD_CODE_CLASSES CC12
, IGS_AD_CODE_CLASSES CC13
, IGS_AD_CODE_CLASSES CC14
WHERE R.SPECIAL_INTEREST_ID = CC1.CODE_ID(+)
AND R.RELIGION_CD = CC2.LOOKUP_CODE(+)
AND CC2.LOOKUP_TYPE(+) = 'PE_RELIGION'
AND R.PROGRAM_INTEREST_ID = CC3.CODE_ID(+)
AND R.INSTITUTION_SIZE_ID = CC4.CODE_ID(+)
AND R.INSTITUTION_CONTROL_ID = CC5.CODE_ID(+)
AND R.INSTITUTION_SETTING_ID = CC6.CODE_ID(+)
AND R.INSTITUTION_LOCATION_ID = CC7.CODE_ID(+)
AND R.SPECIAL_SERVICES_ID = CC8.CODE_ID(+)
AND R.EMPLOYMENT_ID = CC9.CODE_ID(+)
AND R.HOUSING_ID = CC10.CODE_ID(+)
AND R.DEGREE_GOAL_ID = CC11.CODE_ID(+)
AND R.UNIT_SET_ID = CC12.CODE_ID(+)
AND R.CERTAINTY_OF_CHOICE_ID = CC13.CODE_ID(+)
AND R.SEC_SCHOOL_LOCATION_ID = CC14.CODE_ID(+)