DBA Data[Home] [Help]

VIEW: APPS.IGS_SV_EDT_PRGM_BLK_V

Source

View Text - Preformatted

SELECT prgms.batch_id, prgms.person_id, prgms.print_form print_form, prgms.primary_major, prgms.secondary_major, prgms.minor, prgms.length_of_study, prgms.english_reqd english_required, prgms.english_reqd_met english_reqmt_met, prgms.not_reqd_reason not_reqd_reason, prgms.educ_lvl_remarks, prgms.EDUCATION_LEVEL FROM igs_sv_prgms_info prgms WHERE prgms.prgm_action_type = 'EP'
View Text - HTML Formatted

SELECT PRGMS.BATCH_ID
, PRGMS.PERSON_ID
, PRGMS.PRINT_FORM PRINT_FORM
, PRGMS.PRIMARY_MAJOR
, PRGMS.SECONDARY_MAJOR
, PRGMS.MINOR
, PRGMS.LENGTH_OF_STUDY
, PRGMS.ENGLISH_REQD ENGLISH_REQUIRED
, PRGMS.ENGLISH_REQD_MET ENGLISH_REQMT_MET
, PRGMS.NOT_REQD_REASON NOT_REQD_REASON
, PRGMS.EDUC_LVL_REMARKS
, PRGMS.EDUCATION_LEVEL
FROM IGS_SV_PRGMS_INFO PRGMS
WHERE PRGMS.PRGM_ACTION_TYPE = 'EP'