[Home] [Help]
View: IGS_AD_SS_TEST_CONF_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT STC.ROWID
, ASA.ADMISSION_APPLICATION_TYPE
, ASA.DESCRIPTION
, ATT.ADMISSION_TEST_TYPE
, ATT.DESCRIPTION
, STC.INACTIVE
, STC.CREATION_DATE
, STC.CREATED_BY
, STC.LAST_UPDATE_DATE
, STC.LAST_UPDATED_BY
, STC.LAST_UPDATE_LOGIN
FROM IGS_AD_SS_TEST_CONF STC
, IGS_AD_TEST_TYPE ATT
, IGS_AD_SS_APPL_TYP_V ASA
WHERE STC.ADMISSION_TEST_TYPE = ATT.ADMISSION_TEST_TYPE
AND STC.ADMISSION_APPLICATION_TYPE=ASA.ADMISSION_APPLICATION_TYPE
Columns
Name |
ROW_ID |
ADMISSION_APPLICATION_TYPE |
ADMISSION_APPL_TYP_DESC |
ADMISSION_TEST_TYPE |
DESCRIPTION |
INACTIVE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |