VIEW: APPS.IGS_AD_SS_PRC_CAT_V

Source

View Text - Preformatted

SELECT APC.ADMISSION_CAT||'/'|| ILV.MEANING ADMISSION_PROCESS_CATEGORY, APC.ADMISSION_CAT ADMISSION_CAT, APC.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE FROM IGS_AD_PRCS_CAT APC, IGS_AD_CAT AC, IGS_LOOKUPS_VIEW ILV WHERE APC.ADMISSION_CAT=AC.ADMISSION_CAT AND NVL(AC.CLOSED_IND,'N') = 'N' AND ILV.LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE' AND ILV.LOOKUP_CODE = APC.S_ADMISSION_PROCESS_TYPE

View Text - HTML Formatted

SELECT APC.ADMISSION_CAT||'/'|| ILV.MEANING ADMISSION_PROCESS_CATEGORY
, APC.ADMISSION_CAT ADMISSION_CAT
, APC.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
FROM IGS_AD_PRCS_CAT APC
, IGS_AD_CAT AC
, IGS_LOOKUPS_VIEW ILV
WHERE APC.ADMISSION_CAT=AC.ADMISSION_CAT
AND NVL(AC.CLOSED_IND
, 'N') = 'N'
AND ILV.LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE'
AND ILV.LOOKUP_CODE = APC.S_ADMISSION_PROCESS_TYPE