VIEW: APPS.IGS_FI_FD_SRC_RSTN_H_V

Source

View Text - Preformatted

SELECT fsrh1.course_cd, fsrh1.version_number, fsrh1.FUNDING_SOURCE, fsrh1.hist_start_dt, fsrh1.hist_end_dt, fsrh1.hist_who, NVL( fsrh1.dflt_ind, NVL( SUBSTR( IGS_AU_GEN_002.audp_get_fsrh_col( fsrh1.course_cd, fsrh1.version_number, fsrh1.FUNDING_SOURCE, 'DFLT_IND', fsrh1.hist_end_dt),1,1), fsr1.dflt_ind)) dflt_ind, NVL( fsrh1.restricted_ind, NVL( SUBSTR( IGS_AU_GEN_002.audp_get_fsrh_col( fsrh1.course_cd, fsrh1.version_number, fsrh1.FUNDING_SOURCE, 'RESTRICTED_IND', fsrh1.hist_end_dt),1,1), fsr1.restricted_ind)) restricted_ind, fsrh1.created_by, fsrh1.creation_date, fsrh1.last_updated_by, fsrh1.last_update_date, fsrh1.last_update_login FROM IGS_FI_FD_SRC_RSTN_H fsrh1, IGS_FI_FND_SRC_RSTN fsr1, IGS_PS_VER cv WHERE cv.course_cd = fsrh1.course_cd AND cv.version_number = fsrh1.version_number AND fsrh1.course_cd = fsr1.course_cd (+) AND fsrh1.version_number = fsr1.version_number (+) AND fsrh1.FUNDING_SOURCE = fsr1.FUNDING_SOURCE (+) UNION ALL SELECT fsr2.course_cd, fsr2.version_number, fsr2.FUNDING_SOURCE, NVL( MAX(fsrh2.hist_end_dt), fsr2.LAST_UPDATE_DATE) hist_start_dt, TO_DATE(NULL) hist_end_dt, fsr2.last_updated_by hist_who, fsr2.dflt_ind, fsr2.restricted_ind, fsr2.created_by, fsr2.creation_date, fsr2.last_updated_by, fsr2.last_update_date, fsr2.last_update_login FROM IGS_FI_FD_SRC_RSTN_H fsrh2, IGS_FI_FND_SRC_RSTN fsr2 WHERE fsr2.course_cd = fsrh2.course_cd (+) AND fsr2.version_number = fsrh2.version_number (+) AND fsr2.FUNDING_SOURCE = fsrh2.FUNDING_SOURCE (+) GROUP BY fsr2.course_cd, fsr2.version_number, fsr2.FUNDING_SOURCE, fsr2.dflt_ind, fsr2.restricted_ind, fsr2.created_by, fsr2.creation_date, fsr2.last_updated_by, fsr2.last_update_date, fsr2.last_update_login

View Text - HTML Formatted

SELECT FSRH1.COURSE_CD
, FSRH1.VERSION_NUMBER
, FSRH1.FUNDING_SOURCE
, FSRH1.HIST_START_DT
, FSRH1.HIST_END_DT
, FSRH1.HIST_WHO
, NVL( FSRH1.DFLT_IND
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_FSRH_COL( FSRH1.COURSE_CD
, FSRH1.VERSION_NUMBER
, FSRH1.FUNDING_SOURCE
, 'DFLT_IND'
, FSRH1.HIST_END_DT)
, 1
, 1)
, FSR1.DFLT_IND)) DFLT_IND
, NVL( FSRH1.RESTRICTED_IND
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_FSRH_COL( FSRH1.COURSE_CD
, FSRH1.VERSION_NUMBER
, FSRH1.FUNDING_SOURCE
, 'RESTRICTED_IND'
, FSRH1.HIST_END_DT)
, 1
, 1)
, FSR1.RESTRICTED_IND)) RESTRICTED_IND
, FSRH1.CREATED_BY
, FSRH1.CREATION_DATE
, FSRH1.LAST_UPDATED_BY
, FSRH1.LAST_UPDATE_DATE
, FSRH1.LAST_UPDATE_LOGIN
FROM IGS_FI_FD_SRC_RSTN_H FSRH1
, IGS_FI_FND_SRC_RSTN FSR1
, IGS_PS_VER CV
WHERE CV.COURSE_CD = FSRH1.COURSE_CD
AND CV.VERSION_NUMBER = FSRH1.VERSION_NUMBER
AND FSRH1.COURSE_CD = FSR1.COURSE_CD (+)
AND FSRH1.VERSION_NUMBER = FSR1.VERSION_NUMBER (+)
AND FSRH1.FUNDING_SOURCE = FSR1.FUNDING_SOURCE (+) UNION ALL SELECT FSR2.COURSE_CD
, FSR2.VERSION_NUMBER
, FSR2.FUNDING_SOURCE
, NVL( MAX(FSRH2.HIST_END_DT)
, FSR2.LAST_UPDATE_DATE) HIST_START_DT
, TO_DATE(NULL) HIST_END_DT
, FSR2.LAST_UPDATED_BY HIST_WHO
, FSR2.DFLT_IND
, FSR2.RESTRICTED_IND
, FSR2.CREATED_BY
, FSR2.CREATION_DATE
, FSR2.LAST_UPDATED_BY
, FSR2.LAST_UPDATE_DATE
, FSR2.LAST_UPDATE_LOGIN
FROM IGS_FI_FD_SRC_RSTN_H FSRH2
, IGS_FI_FND_SRC_RSTN FSR2
WHERE FSR2.COURSE_CD = FSRH2.COURSE_CD (+)
AND FSR2.VERSION_NUMBER = FSRH2.VERSION_NUMBER (+)
AND FSR2.FUNDING_SOURCE = FSRH2.FUNDING_SOURCE (+) GROUP BY FSR2.COURSE_CD
, FSR2.VERSION_NUMBER
, FSR2.FUNDING_SOURCE
, FSR2.DFLT_IND
, FSR2.RESTRICTED_IND
, FSR2.CREATED_BY
, FSR2.CREATION_DATE
, FSR2.LAST_UPDATED_BY
, FSR2.LAST_UPDATE_DATE
, FSR2.LAST_UPDATE_LOGIN