VIEW: APPS.IGS_AD_PERD_PS_OF_PAT1_V

Source

View Text - Preformatted

SELECT APCOODV.ROW_ID ROW_ID, APCOODV.ADM_CAL_TYPE ADM_CAL_TYPE, APCOODV.ADM_CI_SEQUENCE_NUMBER ADM_CI_SEQUENCE_NUMBER, APCOODV.ADMISSION_CAT ADMISSION_CAT, APCOODV.DT_ALIAS DT_ALIAS, APCOODV.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER, APCOODV.SEQUENCE_NUMBER SEQUENCE_NUMBER, APCOODV.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE, APCOODV.COURSE_CD COURSE_CD, APCOODV.VERSION_NUMBER VERSION_NUMBER, APCOODV.ACAD_CAL_TYPE ACAD_CAL_TYPE, APCOODV.LOCATION_CD LOCATION_CD, APCOODV.ATTENDANCE_MODE ATTENDANCE_MODE, APCOODV.ATTENDANCE_TYPE ATTENDANCE_TYPE, APCOODV.ALIAS_VAL ALIAS_VAL, APCOODV.ROLLOVER_INCLUSION_IND ROLLOVER_INCLUSION_IND, DECODE( APCOODV.S_ADMISSION_PROCESS_TYPE , NULL , NULL, (SELECT lkup.meaning FROM igs_lookup_values lkup WHERE lkup.lookup_type = 'ADMISSION_PROCESS_TYPE' and lkup.lookup_code = APCOODV.S_ADMISSION_PROCESS_TYPE )) MEANING, APCOODV.CREATED_BY CREATED_BY , APCOODV.CREATION_DATE CREATION_DATE , APCOODV.LAST_UPDATED_BY LAST_UPDATED_BY , APCOODV.LAST_UPDATE_DATE LAST_UPDATE_DATE , APCOODV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from IGS_AD_PERD_PS_OF_PAT_V APCOODV

View Text - HTML Formatted

SELECT APCOODV.ROW_ID ROW_ID
, APCOODV.ADM_CAL_TYPE ADM_CAL_TYPE
, APCOODV.ADM_CI_SEQUENCE_NUMBER ADM_CI_SEQUENCE_NUMBER
, APCOODV.ADMISSION_CAT ADMISSION_CAT
, APCOODV.DT_ALIAS DT_ALIAS
, APCOODV.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER
, APCOODV.SEQUENCE_NUMBER SEQUENCE_NUMBER
, APCOODV.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, APCOODV.COURSE_CD COURSE_CD
, APCOODV.VERSION_NUMBER VERSION_NUMBER
, APCOODV.ACAD_CAL_TYPE ACAD_CAL_TYPE
, APCOODV.LOCATION_CD LOCATION_CD
, APCOODV.ATTENDANCE_MODE ATTENDANCE_MODE
, APCOODV.ATTENDANCE_TYPE ATTENDANCE_TYPE
, APCOODV.ALIAS_VAL ALIAS_VAL
, APCOODV.ROLLOVER_INCLUSION_IND ROLLOVER_INCLUSION_IND
, DECODE( APCOODV.S_ADMISSION_PROCESS_TYPE
, NULL
, NULL
, (SELECT LKUP.MEANING
FROM IGS_LOOKUP_VALUES LKUP
WHERE LKUP.LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE'
AND LKUP.LOOKUP_CODE = APCOODV.S_ADMISSION_PROCESS_TYPE )) MEANING
, APCOODV.CREATED_BY CREATED_BY
, APCOODV.CREATION_DATE CREATION_DATE
, APCOODV.LAST_UPDATED_BY LAST_UPDATED_BY
, APCOODV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, APCOODV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_PERD_PS_OF_PAT_V APCOODV