eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGSFV_STDNT_RECRUITMENT

Source

View Text - Preformatted


SELECT adr.RECRUITMENT_ID, adr.PERSON_ID, p.PARTY_NUMBER, pp.PERSON_NAME, adr.SPECIAL_INTEREST_ID, cc1.NAME, cc1.DESCRIPTION, 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, cc2.NAME, cc2.DESCRIPTION, adr.INSTITUTION_SIZE_ID, cc3.NAME, cc3.DESCRIPTION, adr.INSTITUTION_CONTROL_ID, cc4.NAME, cc4.DESCRIPTION, adr.INSTITUTION_SETTING_ID, cc5.NAME, cc5.DESCRIPTION, adr.INSTITUTION_LOCATION_ID, cc6.NAME, cc6.DESCRIPTION, adr.SPECIAL_SERVICES_ID, cc7.NAME, cc7.DESCRIPTION, adr.EMPLOYMENT_ID, cc8.NAME, cc8.DESCRIPTION, adr.HOUSING_ID, cc9.NAME, cc9.DESCRIPTION, adr.DEGREE_GOAL_ID, cc10.NAME, cc10.DESCRIPTION, adr.UNIT_SET_ID, cc11.NAME, cc11.DESCRIPTION, adr.CERTAINTY_OF_CHOICE_ID, cc12.NAME, cc12.DESCRIPTION, adr.RELIGION_ID, cc13.NAME, cc13.DESCRIPTION, 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, HZ_PARTIES p, HZ_PERSON_PROFILES pp, IGS_AD_CODE_CLASSES cc1, IGS_AD_CODE_CLASSES 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 WHERE cc1.CODE_ID(+) = adr.SPECIAL_INTEREST_ID AND cc2.CODE_ID(+) = adr.PROGRAM_INTEREST_ID AND cc3.CODE_ID(+) = adr.INSTITUTION_SIZE_ID AND cc4.CODE_ID(+) = adr.INSTITUTION_CONTROL_ID AND cc5.CODE_ID(+) = adr.INSTITUTION_SETTING_ID AND cc6.CODE_ID(+) = adr.INSTITUTION_LOCATION_ID AND cc7.CODE_ID(+) = adr.SPECIAL_SERVICES_ID AND cc8.CODE_ID(+) = adr.EMPLOYMENT_ID AND cc9.CODE_ID(+) = adr.HOUSING_ID AND cc10.CODE_ID(+) = adr.DEGREE_GOAL_ID AND cc11.CODE_ID(+) = adr.UNIT_SET_ID AND cc12.CODE_ID(+) = adr.CERTAINTY_OF_CHOICE_ID AND cc13.CODE_ID(+) = adr.RELIGION_ID AND adr.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 ADR.RECRUITMENT_ID
, ADR.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, ADR.SPECIAL_INTEREST_ID
, CC1.NAME
, CC1.DESCRIPTION
, 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
, CC2.NAME
, CC2.DESCRIPTION
, ADR.INSTITUTION_SIZE_ID
, CC3.NAME
, CC3.DESCRIPTION
, ADR.INSTITUTION_CONTROL_ID
, CC4.NAME
, CC4.DESCRIPTION
, ADR.INSTITUTION_SETTING_ID
, CC5.NAME
, CC5.DESCRIPTION
, ADR.INSTITUTION_LOCATION_ID
, CC6.NAME
, CC6.DESCRIPTION
, ADR.SPECIAL_SERVICES_ID
, CC7.NAME
, CC7.DESCRIPTION
, ADR.EMPLOYMENT_ID
, CC8.NAME
, CC8.DESCRIPTION
, ADR.HOUSING_ID
, CC9.NAME
, CC9.DESCRIPTION
, ADR.DEGREE_GOAL_ID
, CC10.NAME
, CC10.DESCRIPTION
, ADR.UNIT_SET_ID
, CC11.NAME
, CC11.DESCRIPTION
, ADR.CERTAINTY_OF_CHOICE_ID
, CC12.NAME
, CC12.DESCRIPTION
, ADR.RELIGION_ID
, CC13.NAME
, CC13.DESCRIPTION
, 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
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES 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
WHERE CC1.CODE_ID(+) = ADR.SPECIAL_INTEREST_ID
AND CC2.CODE_ID(+) = ADR.PROGRAM_INTEREST_ID
AND CC3.CODE_ID(+) = ADR.INSTITUTION_SIZE_ID
AND CC4.CODE_ID(+) = ADR.INSTITUTION_CONTROL_ID
AND CC5.CODE_ID(+) = ADR.INSTITUTION_SETTING_ID
AND CC6.CODE_ID(+) = ADR.INSTITUTION_LOCATION_ID
AND CC7.CODE_ID(+) = ADR.SPECIAL_SERVICES_ID
AND CC8.CODE_ID(+) = ADR.EMPLOYMENT_ID
AND CC9.CODE_ID(+) = ADR.HOUSING_ID
AND CC10.CODE_ID(+) = ADR.DEGREE_GOAL_ID
AND CC11.CODE_ID(+) = ADR.UNIT_SET_ID
AND CC12.CODE_ID(+) = ADR.CERTAINTY_OF_CHOICE_ID
AND CC13.CODE_ID(+) = ADR.RELIGION_ID
AND ADR.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