VIEW: APPS.IGS_AD_SBMPS_FN_ITTT_V

Source

View Text - Preformatted

SELECT SCFIT.ROWID ROW_ID, SCFIT.SUBMISSION_YR SUBMISSION_YR, SCFIT.SUBMISSION_NUMBER SUBMISSION_NUMBER, SCFIT.COURSE_CD COURSE_CD, SCFIT.CRV_VERSION_NUMBER CRV_VERSION_NUMBER, SCFIT.FUNDING_SOURCE FUNDING_SOURCE, SCFIT.PRIORITY_OF_TARGET PRIORITY_OF_TARGET, SCFIT.SEQUENCE_NUMBER SEQUENCE_NUMBER, SCFIT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE, SCFIT.TARGET TARGET, SCFIT.MAX_TARGET MAX_TARGET, SCFIT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE, LKUPV.MEANING DSP_OVERRIDE_S_AMOUNT_TYPE, SCFIT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT, SCFIT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT, SCFIT.CREATED_BY CREATED_BY, SCFIT.CREATION_DATE CREATION_DATE, SCFIT.LAST_UPDATED_BY LAST_UPDATED_BY, SCFIT.LAST_UPDATE_DATE LAST_UPDATE_DATE, SCFIT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_SBMPS_FN_ITTT SCFIT, IGS_LOOKUPS_VIEW LKUPV WHERE LKUPV.LOOKUP_TYPE (+) = 'AMOUNT_TYPE' AND LKUPV.LOOKUP_CODE(+) = SCFIT.OVERRIDE_S_AMOUNT_TYPE

View Text - HTML Formatted

SELECT SCFIT.ROWID ROW_ID
, SCFIT.SUBMISSION_YR SUBMISSION_YR
, SCFIT.SUBMISSION_NUMBER SUBMISSION_NUMBER
, SCFIT.COURSE_CD COURSE_CD
, SCFIT.CRV_VERSION_NUMBER CRV_VERSION_NUMBER
, SCFIT.FUNDING_SOURCE FUNDING_SOURCE
, SCFIT.PRIORITY_OF_TARGET PRIORITY_OF_TARGET
, SCFIT.SEQUENCE_NUMBER SEQUENCE_NUMBER
, SCFIT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE
, SCFIT.TARGET TARGET
, SCFIT.MAX_TARGET MAX_TARGET
, SCFIT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE
, LKUPV.MEANING DSP_OVERRIDE_S_AMOUNT_TYPE
, SCFIT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT
, SCFIT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT
, SCFIT.CREATED_BY CREATED_BY
, SCFIT.CREATION_DATE CREATION_DATE
, SCFIT.LAST_UPDATED_BY LAST_UPDATED_BY
, SCFIT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SCFIT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_SBMPS_FN_ITTT SCFIT
, IGS_LOOKUPS_VIEW LKUPV
WHERE LKUPV.LOOKUP_TYPE (+) = 'AMOUNT_TYPE'
AND LKUPV.LOOKUP_CODE(+) = SCFIT.OVERRIDE_S_AMOUNT_TYPE