[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SIT.ROWID ROW_ID
, SIT.SUBMISSION_YR SUBMISSION_YR
, SIT.SUBMISSION_NUMBER SUBMISSION_NUMBER
, SIT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE
, SIT.PRIORITY_OF_TARGET PRIORITY_OF_TARGET
, SIT.TARGET TARGET
, SIT.MAX_TARGET MAX_TARGET
, LKUPV2.MEANING DSP_S_AMOUNT_TYPE
, SIT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE
, LKUPV1.MEANING DSP_OVERRIDE_S_AMOUNT_TYPE
, SIT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT
, SIT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT
, SIT.CREATED_BY CREATED_BY
, SIT.CREATION_DATE CREATION_DATE
, SIT.LAST_UPDATED_BY LAST_UPDATED_BY
, SIT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SIT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_SBMINTAK_TRGT SIT
, IGS_LOOKUPS_VIEW LKUPV1
, IGS_LOOKUPS_VIEW LKUPV2
, IGS_AD_INTAK_TRG_TYP ITT
WHERE LKUPV1.LOOKUP_TYPE (+) = 'AMOUNT_TYPE'
AND LKUPV1.LOOKUP_CODE (+) = SIT.OVERRIDE_S_AMOUNT_TYPE
AND (ITT.INTAKE_TARGET_TYPE = SIT.INTAKE_TARGET_TYPE
AND (LKUPV2.LOOKUP_CODE = ITT.S_AMOUNT_TYPE
AND LKUPV2.LOOKUP_TYPE = 'AMOUNT_TYPE'))