VIEW: APPS.IGS_AD_SBMAO_FN_AMTT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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