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.

[Home] [Help]

View: IGS_AD_SS_PRC_CAT_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
ADMISSION_PROCESS_CATEGORY
ADMISSION_CAT
S_ADMISSION_PROCESS_TYPE