VIEW: APPS.IGS_AD_SBMAO_FN_UITT_V

Source

View Text - Preformatted

SELECT SAFUT.ROWID ROW_ID, SAFUT.SUBMISSION_YR SUBMISSION_YR, SAFUT.SUBMISSION_NUMBER SUBMISSION_NUMBER, SAFUT.ORG_UNIT_CD ORG_UNIT_CD, SAFUT.OU_START_DT OU_START_DT, SAFUT.FUNDING_SOURCE FUNDING_SOURCE, SAFUT.UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CD, SAFUT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE, SAFUT.TARGET TARGET, SAFUT.MAX_TARGET MAX_TARGET, SAFUT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE, LKUPV.MEANING DSP_OVERRIDE_S_AMOUNT_TYPE, SAFUT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT, SAFUT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT, SAFUT.CREATED_BY CREATED_BY, SAFUT.CREATION_DATE CREATION_DATE, SAFUT.LAST_UPDATED_BY LAST_UPDATED_BY, SAFUT.LAST_UPDATE_DATE LAST_UPDATE_DATE, SAFUT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_SBMAO_FN_UITT SAFUT, IGS_LOOKUP_VALUES LKUPV WHERE LKUPV.LOOKUP_TYPE(+) = 'AMOUNT_TYPE' AND LKUPV.LOOKUP_CODE(+) = SAFUT.OVERRIDE_S_AMOUNT_TYPE

View Text - HTML Formatted

SELECT SAFUT.ROWID ROW_ID
, SAFUT.SUBMISSION_YR SUBMISSION_YR
, SAFUT.SUBMISSION_NUMBER SUBMISSION_NUMBER
, SAFUT.ORG_UNIT_CD ORG_UNIT_CD
, SAFUT.OU_START_DT OU_START_DT
, SAFUT.FUNDING_SOURCE FUNDING_SOURCE
, SAFUT.UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CD
, SAFUT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE
, SAFUT.TARGET TARGET
, SAFUT.MAX_TARGET MAX_TARGET
, SAFUT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE
, LKUPV.MEANING DSP_OVERRIDE_S_AMOUNT_TYPE
, SAFUT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT
, SAFUT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT
, SAFUT.CREATED_BY CREATED_BY
, SAFUT.CREATION_DATE CREATION_DATE
, SAFUT.LAST_UPDATED_BY LAST_UPDATED_BY
, SAFUT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SAFUT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_SBMAO_FN_UITT SAFUT
, IGS_LOOKUP_VALUES LKUPV
WHERE LKUPV.LOOKUP_TYPE(+) = 'AMOUNT_TYPE'
AND LKUPV.LOOKUP_CODE(+) = SAFUT.OVERRIDE_S_AMOUNT_TYPE