VIEW: APPS.IGS_FI_FUND_SRC_HIST_V

Source

View Text - Preformatted

SELECT fsh1.FUNDING_SOURCE, fsh1.hist_start_dt, fsh1.hist_end_dt, fsh1.hist_who, NVL( fsh1.description, NVL( SUBSTR( IGS_AU_GEN_002.audp_get_fsh_col( fsh1.FUNDING_SOURCE, 'DESCRIPTION', fsh1.hist_end_dt), 1, 60), fs1.description)) description, NVL( fsh1.GOVT_FUNDING_SOURCE, NVL( TO_NUMBER( IGS_AU_GEN_002.audp_get_fsh_col( fsh1.FUNDING_SOURCE, 'GOVT_FUNDING_SOURCE', fsh1.hist_end_dt)), fs1.GOVT_FUNDING_SOURCE)) GOVT_FUNDING_SOURCE, NVL( fsh1.closed_ind, NVL( SUBSTR( IGS_AU_GEN_002.audp_get_fsh_col( fsh1.FUNDING_SOURCE, 'CLOSED_IND', fsh1.hist_end_dt), 1, 1), fs1.closed_ind)) closed_ind, fsh1.created_by, fsh1.creation_date, fsh1.last_updated_by, fsh1.last_update_date, fsh1.last_update_login FROM IGS_FI_FUND_SRC_HIST fsh1, IGS_FI_FUND_SRC fs1 WHERE fs1.FUNDING_SOURCE = fsh1.FUNDING_SOURCE UNION ALL SELECT fs2.FUNDING_SOURCE, NVL( MAX(fsh2.hist_end_dt), fs2.last_update_date) hist_start_dt, TO_DATE(NULL) hist_end_dt, fs2.last_updated_by hist_who, fs2.description, fs2.GOVT_FUNDING_SOURCE, fs2.closed_ind, fs2.created_by, fs2.creation_date, fs2.last_updated_by, fs2.last_update_date, fs2.last_update_login FROM IGS_FI_FUND_SRC_HIST fsh2, IGS_FI_FUND_SRC fs2 WHERE fs2.FUNDING_SOURCE = fsh2.FUNDING_SOURCE (+) GROUP BY fs2.FUNDING_SOURCE, fs2.description, fs2.GOVT_FUNDING_SOURCE, fs2.closed_ind, fs2.created_by, fs2.creation_date, fs2.last_updated_by, fs2.last_update_date, fs2.last_update_login

View Text - HTML Formatted

SELECT FSH1.FUNDING_SOURCE
, FSH1.HIST_START_DT
, FSH1.HIST_END_DT
, FSH1.HIST_WHO
, NVL( FSH1.DESCRIPTION
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_FSH_COL( FSH1.FUNDING_SOURCE
, 'DESCRIPTION'
, FSH1.HIST_END_DT)
, 1
, 60)
, FS1.DESCRIPTION)) DESCRIPTION
, NVL( FSH1.GOVT_FUNDING_SOURCE
, NVL( TO_NUMBER( IGS_AU_GEN_002.AUDP_GET_FSH_COL( FSH1.FUNDING_SOURCE
, 'GOVT_FUNDING_SOURCE'
, FSH1.HIST_END_DT))
, FS1.GOVT_FUNDING_SOURCE)) GOVT_FUNDING_SOURCE
, NVL( FSH1.CLOSED_IND
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_FSH_COL( FSH1.FUNDING_SOURCE
, 'CLOSED_IND'
, FSH1.HIST_END_DT)
, 1
, 1)
, FS1.CLOSED_IND)) CLOSED_IND
, FSH1.CREATED_BY
, FSH1.CREATION_DATE
, FSH1.LAST_UPDATED_BY
, FSH1.LAST_UPDATE_DATE
, FSH1.LAST_UPDATE_LOGIN
FROM IGS_FI_FUND_SRC_HIST FSH1
, IGS_FI_FUND_SRC FS1
WHERE FS1.FUNDING_SOURCE = FSH1.FUNDING_SOURCE UNION ALL SELECT FS2.FUNDING_SOURCE
, NVL( MAX(FSH2.HIST_END_DT)
, FS2.LAST_UPDATE_DATE) HIST_START_DT
, TO_DATE(NULL) HIST_END_DT
, FS2.LAST_UPDATED_BY HIST_WHO
, FS2.DESCRIPTION
, FS2.GOVT_FUNDING_SOURCE
, FS2.CLOSED_IND
, FS2.CREATED_BY
, FS2.CREATION_DATE
, FS2.LAST_UPDATED_BY
, FS2.LAST_UPDATE_DATE
, FS2.LAST_UPDATE_LOGIN
FROM IGS_FI_FUND_SRC_HIST FSH2
, IGS_FI_FUND_SRC FS2
WHERE FS2.FUNDING_SOURCE = FSH2.FUNDING_SOURCE (+) GROUP BY FS2.FUNDING_SOURCE
, FS2.DESCRIPTION
, FS2.GOVT_FUNDING_SOURCE
, FS2.CLOSED_IND
, FS2.CREATED_BY
, FS2.CREATION_DATE
, FS2.LAST_UPDATED_BY
, FS2.LAST_UPDATE_DATE
, FS2.LAST_UPDATE_LOGIN