Product: | IGS - Student System |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGSFV_ADM_PERD_ADM_CAT |
SELECT CI.DESCRIPTION
, PRC.ADM_CAL_TYPE
, PRC.ADM_CI_SEQUENCE_NUMBER
, PRC.ADMISSION_CAT
, AC.DESCRIPTION
, PRC.CI_START_DT
, PRC.CI_END_DT
, PRC.CREATED_BY
, PRC.CREATION_DATE
, PRC.LAST_UPDATED_BY
, PRC.LAST_UPDATE_DATE
FROM IGS_AD_PERD_AD_CAT PRC
, IGS_CA_INST_ALL CI
, IGS_AD_CAT_ALL AC
WHERE CI.CAL_TYPE = PRC.ADM_CAL_TYPE
AND CI.SEQUENCE_NUMBER = PRC.ADM_CI_SEQUENCE_NUMBER
AND AC.ADMISSION_CAT = PRC.ADMISSION_CAT WITH READ ONLY