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_AD_MKADM_DES_INT_V

Source

View Text - Preformatted


SELECT mdi.rowid row_id, mdi.interface_mkdes_id interface_mkdes_id, mdi.interface_run_id interface_run_id, mdi.batch_id batch_id, abdd.description description, aa.acad_cal_type acad_cal_type, aa.acad_ci_sequence_number acad_ci_sequence_number, aa.adm_cal_type adm_cal_type, aa.adm_ci_sequence_number adm_ci_sequence_number, ci2.alternate_code adm_alternate_code, ci1.alternate_code acad_alternate_code, aa.admission_cat admission_cat, aa.s_admission_process_type s_admission_process_type, mdi.person_id person_id, mdi.sequence_number sequence_number, pp.person_number person_number, pp.full_name full_name, pit.api_person_id api_person_id, mdi.admission_appl_number admission_appl_number, mdi.nominated_course_cd nominated_course_cd, crv.title course_title, mdi.adm_outcome_status adm_outcome_status, mdi.error_text error_text, mdi.status status, mdi.error_code error_code, mdi.decision_make_id decision_make_id, ppv.person_number decision_maker_number, ppv.full_name decision_maker_name, mdi.decision_date decision_date, mdi.decision_reason_id decision_reason_id, cc1.name decision_reason, cc1.description decision_reason_desc, mdi.pending_reason_id pending_reason_id, cc2.name pending_reason, cc2.description pending_reason_desc, mdi.offer_dt offer_dt, mdi.offer_response_dt offer_response_dt, mdi.creation_date creation_date, mdi.created_by created_by, mdi.last_update_date last_update_date, mdi.last_updated_by last_updated_by, mdi.last_update_login last_update_login, mdi.request_id request_id, mdi.program_application_id program_application_id, mdi.program_id program_id, mdi.program_update_date program_update_date, apaiav.crv_version_number crv_version_number, apaiav.location_cd location_cd, apaiav.attendance_mode attendance_mode, apaiav.attendance_type attendance_type, apaiav.unit_set_cd unit_set_cd, apaiav.us_version_number us_version_number, mdi.reconsider_flag reconsider_flag, mdi. prpsd_commencement_date FROM igs_ad_admde_int mdi, igs_ad_batc_def_det abdd, igs_pe_person_base_v pp, igs_pe_person_base_v ppv, igs_ad_ps_appl_inst apaiav, igs_ps_ver crv, igs_ad_appl aa, igs_ca_inst ci1, igs_ca_inst ci2, igs_ad_code_classes cc1, igs_ad_code_classes cc2, igs_pe_person_id_type_v pit WHERE /* joining interface table and default decision details table */ mdi.batch_id = abdd.batch_id AND /* joining interface table and person table */ mdi.person_id = pp.person_id AND /* joining interface table and application instance table */ mdi.person_id = aa.person_id AND mdi.admission_appl_number = aa.admission_appl_number AND /* Joining application instance view and application interface view */ apaiav.person_id = mdi.person_id AND apaiav.nominated_course_cd = mdi.nominated_course_cd AND apaiav.admission_appl_number = mdi.admission_appl_number AND apaiav.sequence_number = mdi.sequence_number AND crv.course_cd = apaiav.course_cd AND crv.version_number = apaiav.crv_version_number AND ci1.cal_type = aa.acad_cal_type AND ci1.sequence_number = aa.acad_ci_sequence_number AND ci2.cal_type = aa.adm_cal_type AND ci2.sequence_number = aa.adm_ci_sequence_number AND ci2.cal_type = NVL(apaiav.ADM_CAL_TYPE, aa.ADM_CAL_TYPE) AND ci2.sequence_number = NVL(apaiav.ADM_CI_SEQUENCE_NUMBER, aa.ADM_CI_SEQUENCE_NUMBER ) AND /* Joining application interface view and Person view */ ppv.person_id (+) = mdi.decision_make_id AND /* Joining interface table and code classes table for decision reason*/ mdi.decision_reason_id = cc1.code_id (+) AND /* Joining interface table and code classes table for pending reason*/ mdi.pending_reason_id = cc2.code_id (+) AND /* joining interface table and lookups view */ pit.pe_person_id (+) = pp.person_id AND /* If all the APC/Calender Columns are null in batch table then select all the records from the decision interface table ELSE select all the records matching to APC/calender of batch record.*/ ( (abdd.ACAD_CAL_TYPE IS NULL AND abdd.ACAD_CI_SEQUENCE_NUMBER IS NULL AND abdd.ADM_CAL_TYPE IS NULL AND abdd.ADM_CI_SEQUENCE_NUMBER IS NULL AND abdd.ADMISSION_CAT IS NULL AND abdd.S_ADMISSION_PROCESS_TYPE IS NULL) OR (abdd.ACAD_CAL_TYPE = aa.ACAD_CAL_TYPE AND abdd.ACAD_CI_SEQUENCE_NUMBER = aa.ACAD_CI_SEQUENCE_NUMBER AND abdd.ADM_CAL_TYPE = NVL(apaiav.ADM_CAL_TYPE, aa.ADM_CAL_TYPE) AND abdd.ADM_CI_SEQUENCE_NUMBER = NVL(apaiav.ADM_CI_SEQUENCE_NUMBER, aa.ADM_CI_SEQUENCE_NUMBER ) AND abdd.ADMISSION_CAT = aa.ADMISSION_CAT AND abdd.S_ADMISSION_PROCESS_TYPE = aa.S_ADMISSION_PROCESS_TYPE) )

View Text - HTML Formatted

SELECT MDI.ROWID ROW_ID
, MDI.INTERFACE_MKDES_ID INTERFACE_MKDES_ID
, MDI.INTERFACE_RUN_ID INTERFACE_RUN_ID
, MDI.BATCH_ID BATCH_ID
, ABDD.DESCRIPTION DESCRIPTION
, AA.ACAD_CAL_TYPE ACAD_CAL_TYPE
, AA.ACAD_CI_SEQUENCE_NUMBER ACAD_CI_SEQUENCE_NUMBER
, AA.ADM_CAL_TYPE ADM_CAL_TYPE
, AA.ADM_CI_SEQUENCE_NUMBER ADM_CI_SEQUENCE_NUMBER
, CI2.ALTERNATE_CODE ADM_ALTERNATE_CODE
, CI1.ALTERNATE_CODE ACAD_ALTERNATE_CODE
, AA.ADMISSION_CAT ADMISSION_CAT
, AA.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, MDI.PERSON_ID PERSON_ID
, MDI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PP.PERSON_NUMBER PERSON_NUMBER
, PP.FULL_NAME FULL_NAME
, PIT.API_PERSON_ID API_PERSON_ID
, MDI.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, MDI.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, CRV.TITLE COURSE_TITLE
, MDI.ADM_OUTCOME_STATUS ADM_OUTCOME_STATUS
, MDI.ERROR_TEXT ERROR_TEXT
, MDI.STATUS STATUS
, MDI.ERROR_CODE ERROR_CODE
, MDI.DECISION_MAKE_ID DECISION_MAKE_ID
, PPV.PERSON_NUMBER DECISION_MAKER_NUMBER
, PPV.FULL_NAME DECISION_MAKER_NAME
, MDI.DECISION_DATE DECISION_DATE
, MDI.DECISION_REASON_ID DECISION_REASON_ID
, CC1.NAME DECISION_REASON
, CC1.DESCRIPTION DECISION_REASON_DESC
, MDI.PENDING_REASON_ID PENDING_REASON_ID
, CC2.NAME PENDING_REASON
, CC2.DESCRIPTION PENDING_REASON_DESC
, MDI.OFFER_DT OFFER_DT
, MDI.OFFER_RESPONSE_DT OFFER_RESPONSE_DT
, MDI.CREATION_DATE CREATION_DATE
, MDI.CREATED_BY CREATED_BY
, MDI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MDI.LAST_UPDATED_BY LAST_UPDATED_BY
, MDI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MDI.REQUEST_ID REQUEST_ID
, MDI.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MDI.PROGRAM_ID PROGRAM_ID
, MDI.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, APAIAV.CRV_VERSION_NUMBER CRV_VERSION_NUMBER
, APAIAV.LOCATION_CD LOCATION_CD
, APAIAV.ATTENDANCE_MODE ATTENDANCE_MODE
, APAIAV.ATTENDANCE_TYPE ATTENDANCE_TYPE
, APAIAV.UNIT_SET_CD UNIT_SET_CD
, APAIAV.US_VERSION_NUMBER US_VERSION_NUMBER
, MDI.RECONSIDER_FLAG RECONSIDER_FLAG
, MDI. PRPSD_COMMENCEMENT_DATE
FROM IGS_AD_ADMDE_INT MDI
, IGS_AD_BATC_DEF_DET ABDD
, IGS_PE_PERSON_BASE_V PP
, IGS_PE_PERSON_BASE_V PPV
, IGS_AD_PS_APPL_INST APAIAV
, IGS_PS_VER CRV
, IGS_AD_APPL AA
, IGS_CA_INST CI1
, IGS_CA_INST CI2
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, IGS_PE_PERSON_ID_TYPE_V PIT
WHERE /* JOINING INTERFACE TABLE
AND DEFAULT DECISION DETAILS TABLE */ MDI.BATCH_ID = ABDD.BATCH_ID
AND /* JOINING INTERFACE TABLE
AND PERSON TABLE */ MDI.PERSON_ID = PP.PERSON_ID
AND /* JOINING INTERFACE TABLE
AND APPLICATION INSTANCE TABLE */ MDI.PERSON_ID = AA.PERSON_ID
AND MDI.ADMISSION_APPL_NUMBER = AA.ADMISSION_APPL_NUMBER
AND /* JOINING APPLICATION INSTANCE VIEW
AND APPLICATION INTERFACE VIEW */ APAIAV.PERSON_ID = MDI.PERSON_ID
AND APAIAV.NOMINATED_COURSE_CD = MDI.NOMINATED_COURSE_CD
AND APAIAV.ADMISSION_APPL_NUMBER = MDI.ADMISSION_APPL_NUMBER
AND APAIAV.SEQUENCE_NUMBER = MDI.SEQUENCE_NUMBER
AND CRV.COURSE_CD = APAIAV.COURSE_CD
AND CRV.VERSION_NUMBER = APAIAV.CRV_VERSION_NUMBER
AND CI1.CAL_TYPE = AA.ACAD_CAL_TYPE
AND CI1.SEQUENCE_NUMBER = AA.ACAD_CI_SEQUENCE_NUMBER
AND CI2.CAL_TYPE = AA.ADM_CAL_TYPE
AND CI2.SEQUENCE_NUMBER = AA.ADM_CI_SEQUENCE_NUMBER
AND CI2.CAL_TYPE = NVL(APAIAV.ADM_CAL_TYPE
, AA.ADM_CAL_TYPE)
AND CI2.SEQUENCE_NUMBER = NVL(APAIAV.ADM_CI_SEQUENCE_NUMBER
, AA.ADM_CI_SEQUENCE_NUMBER )
AND /* JOINING APPLICATION INTERFACE VIEW
AND PERSON VIEW */ PPV.PERSON_ID (+) = MDI.DECISION_MAKE_ID
AND /* JOINING INTERFACE TABLE
AND CODE CLASSES TABLE FOR DECISION REASON*/ MDI.DECISION_REASON_ID = CC1.CODE_ID (+)
AND /* JOINING INTERFACE TABLE
AND CODE CLASSES TABLE FOR PENDING REASON*/ MDI.PENDING_REASON_ID = CC2.CODE_ID (+)
AND /* JOINING INTERFACE TABLE
AND LOOKUPS VIEW */ PIT.PE_PERSON_ID (+) = PP.PERSON_ID
AND /* IF ALL THE APC/CALENDER COLUMNS ARE NULL IN BATCH TABLE THEN SELECT ALL THE RECORDS
FROM THE DECISION INTERFACE TABLE ELSE SELECT ALL THE RECORDS MATCHING TO APC/CALENDER OF BATCH RECORD.*/ ( (ABDD.ACAD_CAL_TYPE IS NULL
AND ABDD.ACAD_CI_SEQUENCE_NUMBER IS NULL
AND ABDD.ADM_CAL_TYPE IS NULL
AND ABDD.ADM_CI_SEQUENCE_NUMBER IS NULL
AND ABDD.ADMISSION_CAT IS NULL
AND ABDD.S_ADMISSION_PROCESS_TYPE IS NULL) OR (ABDD.ACAD_CAL_TYPE = AA.ACAD_CAL_TYPE
AND ABDD.ACAD_CI_SEQUENCE_NUMBER = AA.ACAD_CI_SEQUENCE_NUMBER
AND ABDD.ADM_CAL_TYPE = NVL(APAIAV.ADM_CAL_TYPE
, AA.ADM_CAL_TYPE)
AND ABDD.ADM_CI_SEQUENCE_NUMBER = NVL(APAIAV.ADM_CI_SEQUENCE_NUMBER
, AA.ADM_CI_SEQUENCE_NUMBER )
AND ABDD.ADMISSION_CAT = AA.ADMISSION_CAT
AND ABDD.S_ADMISSION_PROCESS_TYPE = AA.S_ADMISSION_PROCESS_TYPE) )