Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT ITT.ROWID ROW_ID
, ITT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE
, ITT.DESCRIPTION DESCRIPTION
, ITT.S_INTAKE_TARGET_TYPE S_INTAKE_TARGET_TYPE
, LKUPV.MEANING MEANING
, LKUPV.CLOSED_IND DSP_CLOSED_IND
, ITT.S_AMOUNT_TYPE S_AMOUNT_TYPE
, LKUPV2.MEANING MEANING_AMOUNT_TYPE
, ITT.COMMENTS COMMENTS
, ITT.CLOSED_IND CLOSED_IND
, ITT.CREATED_BY CREATED_BY
, ITT.CREATION_DATE CREATION_DATE
, ITT.LAST_UPDATED_BY LAST_UPDATED_BY
, ITT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ITT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_INTAK_TRG_TYP ITT
, IGS_LOOKUPS_VIEW LKUPV
, IGS_LOOKUPS_VIEW LKUPV2
WHERE LKUPV.LOOKUP_TYPE = 'INTAKE_TARGET_TYPE'
AND LKUPV.LOOKUP_CODE = ITT.S_INTAKE_TARGET_TYPE
AND LKUPV2.LOOKUP_TYPE = 'AMOUNT_TYPE'
AND LKUPV2.LOOKUP_CODE = ITT.S_AMOUNT_TYPE