VIEW: APPS.IGS_AD_SBM_AOU_FNDTT_V

Source

View Text - Preformatted

SELECT SAFT.ROWID ROW_ID, SAFT.SUBMISSION_YR SUBMISSION_YR, SAFT.SUBMISSION_NUMBER SUBMISSION_NUMBER, SAFT.ORG_UNIT_CD ORG_UNIT_CD, SAFT.OU_START_DT OU_START_DT, SAFT.FUNDING_SOURCE FUNDING_SOURCE, SAFT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE, SAFT.TARGET TARGET, SAFT.MAX_TARGET MAX_TARGET, SAFT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE, DECODE (SAFT.OVERRIDE_S_AMOUNT_TYPE,NULL, NULL, (SELECT MEANING FROM IGS_LOOKUP_VALUES WHERE LOOKUP_CODE = SAFT.OVERRIDE_S_AMOUNT_TYPE AND LOOKUP_TYPE = 'AMOUNT_TYPE' )) DSP_OVERRIDE_S_AMOUNT_TYPE, SAFT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT, SAFT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT, SAFT.CREATED_BY CREATED_BY, SAFT.CREATION_DATE CREATION_DATE, SAFT.LAST_UPDATED_BY LAST_UPDATED_BY, SAFT.LAST_UPDATE_DATE LAST_UPDATE_DATE, SAFT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_SBM_AOU_FNDTT SAFT

View Text - HTML Formatted

SELECT SAFT.ROWID ROW_ID
, SAFT.SUBMISSION_YR SUBMISSION_YR
, SAFT.SUBMISSION_NUMBER SUBMISSION_NUMBER
, SAFT.ORG_UNIT_CD ORG_UNIT_CD
, SAFT.OU_START_DT OU_START_DT
, SAFT.FUNDING_SOURCE FUNDING_SOURCE
, SAFT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE
, SAFT.TARGET TARGET
, SAFT.MAX_TARGET MAX_TARGET
, SAFT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE
, DECODE (SAFT.OVERRIDE_S_AMOUNT_TYPE
, NULL
, NULL
, (SELECT MEANING
FROM IGS_LOOKUP_VALUES
WHERE LOOKUP_CODE = SAFT.OVERRIDE_S_AMOUNT_TYPE
AND LOOKUP_TYPE = 'AMOUNT_TYPE' )) DSP_OVERRIDE_S_AMOUNT_TYPE
, SAFT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT
, SAFT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT
, SAFT.CREATED_BY CREATED_BY
, SAFT.CREATION_DATE CREATION_DATE
, SAFT.LAST_UPDATED_BY LAST_UPDATED_BY
, SAFT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SAFT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_SBM_AOU_FNDTT SAFT