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.

VIEW: APPS.IGS_PS_OFR_PAT_APCOOD_PAT_V

Source

View Text - Preformatted


SELECT cop.course_cd, cop.version_number, cop.cal_type, cop.location_cd, cop.attendance_mode, cop.attendance_type, dai.dt_alias, IGS_AD_GEN_003.admp_get_adm_perd_dt( dai.dt_alias, apapc.adm_cal_type, apapc.adm_ci_sequence_number, apapc.admission_cat, apapc.s_admission_process_type, cop.course_cd, cop.version_number, cop.cal_type, cop.location_cd, cop.attendance_mode, cop.attendance_type), apapc.adm_cal_type, apapc.adm_ci_sequence_number, apapc.admission_cat, apapc.s_admission_process_type, crv.title, crv.short_title, crv.responsible_org_unit_cd, crv.responsible_ou_start_dt , cop.created_by , cop.creation_date , cop.last_updated_by , cop.last_update_date , cop.last_update_login FROM IGS_PS_OFR_PAT cop, IGS_CA_INST_REL cir, IGS_AD_PRD_AD_PRC_CA apapc, IGS_PS_VER crv, IGS_CA_DA_INST dai WHERE cop.cal_type = cir.sup_cal_type AND cop.ci_sequence_number = cir.sup_ci_sequence_number AND apapc.adm_cal_type = cir.sub_cal_type AND apapc.adm_ci_sequence_number = cir.sub_ci_sequence_number AND ((cop.course_cd, cop.version_number, cop.cal_type) IN (SELECT cooac.course_cd, cooac.version_number, cooac.cal_type FROM IGS_PS_OF_OPT_AD_CAT cooac WHERE cooac.course_cd = cop.course_cd AND cooac.version_number = cop.version_number AND cooac.cal_type = cop.cal_type AND cooac.location_cd = cop.location_cd AND cooac.attendance_mode = cop.attendance_mode AND cooac.attendance_type = cop.attendance_type AND cooac.admission_cat = apapc.admission_cat AND (IGS_AD_GEN_013.adms_get_coo_crv( cooac.course_cd, cooac.version_number, apapc.s_admission_process_type, 'N') = 'Y') AND (IGS_AD_GEN_013.adms_get_coo_admperd( apapc.adm_cal_type, apapc.adm_ci_sequence_number, apapc.admission_cat, apapc.s_admission_process_type, cooac.course_cd, cooac.version_number, cooac.cal_type, cooac.location_cd, cooac.attendance_mode, cooac.attendance_type) = 'Y') )) AND cop.offered_ind = 'Y' AND cop.entry_point_ind = 'Y' AND (crv.course_cd = cop.course_cd AND crv.version_number = cop.version_number) AND (dai.cal_type = apapc.adm_cal_type AND dai.ci_sequence_number = apapc.adm_ci_sequence_number)

View Text - HTML Formatted

SELECT COP.COURSE_CD
, COP.VERSION_NUMBER
, COP.CAL_TYPE
, COP.LOCATION_CD
, COP.ATTENDANCE_MODE
, COP.ATTENDANCE_TYPE
, DAI.DT_ALIAS
, IGS_AD_GEN_003.ADMP_GET_ADM_PERD_DT( DAI.DT_ALIAS
, APAPC.ADM_CAL_TYPE
, APAPC.ADM_CI_SEQUENCE_NUMBER
, APAPC.ADMISSION_CAT
, APAPC.S_ADMISSION_PROCESS_TYPE
, COP.COURSE_CD
, COP.VERSION_NUMBER
, COP.CAL_TYPE
, COP.LOCATION_CD
, COP.ATTENDANCE_MODE
, COP.ATTENDANCE_TYPE)
, APAPC.ADM_CAL_TYPE
, APAPC.ADM_CI_SEQUENCE_NUMBER
, APAPC.ADMISSION_CAT
, APAPC.S_ADMISSION_PROCESS_TYPE
, CRV.TITLE
, CRV.SHORT_TITLE
, CRV.RESPONSIBLE_ORG_UNIT_CD
, CRV.RESPONSIBLE_OU_START_DT
, COP.CREATED_BY
, COP.CREATION_DATE
, COP.LAST_UPDATED_BY
, COP.LAST_UPDATE_DATE
, COP.LAST_UPDATE_LOGIN
FROM IGS_PS_OFR_PAT COP
, IGS_CA_INST_REL CIR
, IGS_AD_PRD_AD_PRC_CA APAPC
, IGS_PS_VER CRV
, IGS_CA_DA_INST DAI
WHERE COP.CAL_TYPE = CIR.SUP_CAL_TYPE
AND COP.CI_SEQUENCE_NUMBER = CIR.SUP_CI_SEQUENCE_NUMBER
AND APAPC.ADM_CAL_TYPE = CIR.SUB_CAL_TYPE
AND APAPC.ADM_CI_SEQUENCE_NUMBER = CIR.SUB_CI_SEQUENCE_NUMBER
AND ((COP.COURSE_CD
, COP.VERSION_NUMBER
, COP.CAL_TYPE) IN (SELECT COOAC.COURSE_CD
, COOAC.VERSION_NUMBER
, COOAC.CAL_TYPE
FROM IGS_PS_OF_OPT_AD_CAT COOAC
WHERE COOAC.COURSE_CD = COP.COURSE_CD
AND COOAC.VERSION_NUMBER = COP.VERSION_NUMBER
AND COOAC.CAL_TYPE = COP.CAL_TYPE
AND COOAC.LOCATION_CD = COP.LOCATION_CD
AND COOAC.ATTENDANCE_MODE = COP.ATTENDANCE_MODE
AND COOAC.ATTENDANCE_TYPE = COP.ATTENDANCE_TYPE
AND COOAC.ADMISSION_CAT = APAPC.ADMISSION_CAT
AND (IGS_AD_GEN_013.ADMS_GET_COO_CRV( COOAC.COURSE_CD
, COOAC.VERSION_NUMBER
, APAPC.S_ADMISSION_PROCESS_TYPE
, 'N') = 'Y')
AND (IGS_AD_GEN_013.ADMS_GET_COO_ADMPERD( APAPC.ADM_CAL_TYPE
, APAPC.ADM_CI_SEQUENCE_NUMBER
, APAPC.ADMISSION_CAT
, APAPC.S_ADMISSION_PROCESS_TYPE
, COOAC.COURSE_CD
, COOAC.VERSION_NUMBER
, COOAC.CAL_TYPE
, COOAC.LOCATION_CD
, COOAC.ATTENDANCE_MODE
, COOAC.ATTENDANCE_TYPE) = 'Y') ))
AND COP.OFFERED_IND = 'Y'
AND COP.ENTRY_POINT_IND = 'Y'
AND (CRV.COURSE_CD = COP.COURSE_CD
AND CRV.VERSION_NUMBER = COP.VERSION_NUMBER)
AND (DAI.CAL_TYPE = APAPC.ADM_CAL_TYPE
AND DAI.CI_SEQUENCE_NUMBER = APAPC.ADM_CI_SEQUENCE_NUMBER)