View: IGS_AD_DES_BATCH_DEF_DET_V

View Text

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 (+)

Columns