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: APPS.IGS_AD_SBMINTAK_TRGT_V

Source

View Text - Preformatted


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'))

View Text - HTML Formatted

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'))