VIEW: APPS.IGS_AD_DES_BATCH_DEF_DET_V

Source

View Text - Preformatted

SELECT abdd.rowid row_id, abdd.batch_id batch_id, abdd.description description, abdd.acad_cal_type acad_cal_type, abdd.acad_ci_sequence_number acad_ci_sequence_number, (SELECT ci1.alternate_code acad_alternate_code FROM igs_ca_inst ci1 WHERE ci1.cal_type = abdd.acad_cal_type AND ci1.sequence_number = abdd.acad_ci_sequence_number ) acad_alternate_code, abdd.adm_cal_type adm_cal_type, abdd.adm_ci_sequence_number adm_ci_sequence_number, ( SELECT ci1.alternate_code acad_alternate_code FROM igs_ca_inst ci1 WHERE ci1.cal_type = abdd.adm_cal_type AND ci1.sequence_number = abdd.adm_ci_sequence_number ) adm_alternate_code, abdd.admission_cat admission_cat, abdd.s_admission_process_type s_admission_process_type, abdd.decision_make_id decision_make_id, pe.person_number decision_make_number, pe.full_name decision_make_name, abdd.decision_date decision_date, abdd.decision_reason_id decision_reason_id, DECODE(ABDD.DECISION_REASON_ID,NULL,TO_CHAR(NULL), ( SELECT NAME FROM IGS_AD_CODE_CLASSES WHERE CODE_ID = ABDD.DECISION_REASON_ID)) decision_reason, DECODE(ABDD.DECISION_REASON_ID,NULL,TO_CHAR(NULL), ( SELECT DESCRIPTION FROM IGS_AD_CODE_CLASSES WHERE CODE_ID = ABDD.DECISION_REASON_ID)) decision_reason_desc, abdd.pending_reason_id pending_reason_id, DECODE(ABDD.PENDING_REASON_ID,NULL,TO_CHAR(NULL), ( SELECT NAME FROM IGS_AD_CODE_CLASSES WHERE CODE_ID = ABDD.PENDING_REASON_ID)) pending_reason, DECODE(ABDD.PENDING_REASON_ID,NULL,TO_CHAR(NULL), ( SELECT DESCRIPTION FROM IGS_AD_CODE_CLASSES WHERE CODE_ID = ABDD.PENDING_REASON_ID)) pending_reason_desc, abdd.offer_dt offer_dt, abdd.offer_response_dt offer_response_dt, abdd.creation_date creation_date, abdd.created_by created_by, abdd.last_update_date last_update_date, abdd.last_updated_by last_updated_by, abdd.last_update_login last_update_login FROM igs_ad_batc_def_det abdd, igs_pe_person_base_v pe WHERE abdd.decision_make_id = pe.person_id (+)

View Text - HTML Formatted

SELECT ABDD.ROWID ROW_ID
, ABDD.BATCH_ID BATCH_ID
, ABDD.DESCRIPTION DESCRIPTION
, ABDD.ACAD_CAL_TYPE ACAD_CAL_TYPE
, ABDD.ACAD_CI_SEQUENCE_NUMBER ACAD_CI_SEQUENCE_NUMBER
, (SELECT CI1.ALTERNATE_CODE ACAD_ALTERNATE_CODE
FROM IGS_CA_INST CI1
WHERE CI1.CAL_TYPE = ABDD.ACAD_CAL_TYPE
AND CI1.SEQUENCE_NUMBER = ABDD.ACAD_CI_SEQUENCE_NUMBER ) ACAD_ALTERNATE_CODE
, ABDD.ADM_CAL_TYPE ADM_CAL_TYPE
, ABDD.ADM_CI_SEQUENCE_NUMBER ADM_CI_SEQUENCE_NUMBER
, ( SELECT CI1.ALTERNATE_CODE ACAD_ALTERNATE_CODE
FROM IGS_CA_INST CI1
WHERE CI1.CAL_TYPE = ABDD.ADM_CAL_TYPE
AND CI1.SEQUENCE_NUMBER = ABDD.ADM_CI_SEQUENCE_NUMBER ) ADM_ALTERNATE_CODE
, ABDD.ADMISSION_CAT ADMISSION_CAT
, ABDD.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, ABDD.DECISION_MAKE_ID DECISION_MAKE_ID
, PE.PERSON_NUMBER DECISION_MAKE_NUMBER
, PE.FULL_NAME DECISION_MAKE_NAME
, ABDD.DECISION_DATE DECISION_DATE
, ABDD.DECISION_REASON_ID DECISION_REASON_ID
, DECODE(ABDD.DECISION_REASON_ID
, NULL
, TO_CHAR(NULL)
, ( SELECT NAME
FROM IGS_AD_CODE_CLASSES
WHERE CODE_ID = ABDD.DECISION_REASON_ID)) DECISION_REASON
, DECODE(ABDD.DECISION_REASON_ID
, NULL
, TO_CHAR(NULL)
, ( SELECT DESCRIPTION
FROM IGS_AD_CODE_CLASSES
WHERE CODE_ID = ABDD.DECISION_REASON_ID)) DECISION_REASON_DESC
, ABDD.PENDING_REASON_ID PENDING_REASON_ID
, DECODE(ABDD.PENDING_REASON_ID
, NULL
, TO_CHAR(NULL)
, ( SELECT NAME
FROM IGS_AD_CODE_CLASSES
WHERE CODE_ID = ABDD.PENDING_REASON_ID)) PENDING_REASON
, DECODE(ABDD.PENDING_REASON_ID
, NULL
, TO_CHAR(NULL)
, ( SELECT DESCRIPTION
FROM IGS_AD_CODE_CLASSES
WHERE CODE_ID = ABDD.PENDING_REASON_ID)) PENDING_REASON_DESC
, ABDD.OFFER_DT OFFER_DT
, ABDD.OFFER_RESPONSE_DT OFFER_RESPONSE_DT
, ABDD.CREATION_DATE CREATION_DATE
, ABDD.CREATED_BY CREATED_BY
, ABDD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ABDD.LAST_UPDATED_BY LAST_UPDATED_BY
, ABDD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_BATC_DEF_DET ABDD
, IGS_PE_PERSON_BASE_V PE
WHERE ABDD.DECISION_MAKE_ID = PE.PERSON_ID (+)