VIEW: APPS.IGS_PS_UNT_DSCP_HIST_V

Source

View Text - Preformatted

SELECT udh1.unit_cd, udh1.version_number, udh1.discipline_group_cd, udh1.hist_start_dt, udh1.hist_end_dt, udh1.hist_who, NVL( udh1.percentage, NVL( TO_NUMBER( IGS_AU_GEN_004.audp_get_udh_col( udh1.unit_cd, udh1.version_number, udh1.discipline_group_cd, udh1.hist_end_dt)), ud1.percentage)), udh1.created_by, udh1.creation_date, udh1.last_updated_by, udh1.last_update_date, udh1.last_update_login FROM IGS_PS_UNT_DSCP_HIST udh1, IGS_PS_UNIT_DSCP ud1, IGS_PS_UNIT_VER uv WHERE uv.unit_cd = udh1.unit_cd AND uv.version_number = udh1.version_number AND udh1.unit_cd = ud1.unit_cd (+) AND udh1.version_number = ud1.version_number (+) AND udh1.discipline_group_cd = ud1.discipline_group_cd (+) UNION ALL SELECT ud2.unit_cd, ud2.version_number, ud2.discipline_group_cd, NVL( MAX(udh2.hist_end_dt), ud2.last_update_date), TO_DATE(NULL), ud2.last_updated_by, ud2.percentage, ud2.created_by, ud2.creation_date, ud2.last_updated_by, ud2.last_update_date, ud2.last_update_login FROM IGS_PS_UNT_DSCP_HIST udh2, IGS_PS_UNIT_DSCP ud2 WHERE ud2.unit_cd = udh2.unit_cd (+) AND ud2.version_number = udh2.version_number (+) AND ud2.discipline_group_cd = udh2.discipline_group_cd (+) GROUP BY ud2.unit_cd, ud2.version_number, ud2.discipline_group_cd, ud2.percentage, ud2.created_by, ud2.creation_date, ud2.last_updated_by, ud2.last_update_date, ud2.last_update_login

View Text - HTML Formatted

SELECT UDH1.UNIT_CD
, UDH1.VERSION_NUMBER
, UDH1.DISCIPLINE_GROUP_CD
, UDH1.HIST_START_DT
, UDH1.HIST_END_DT
, UDH1.HIST_WHO
, NVL( UDH1.PERCENTAGE
, NVL( TO_NUMBER( IGS_AU_GEN_004.AUDP_GET_UDH_COL( UDH1.UNIT_CD
, UDH1.VERSION_NUMBER
, UDH1.DISCIPLINE_GROUP_CD
, UDH1.HIST_END_DT))
, UD1.PERCENTAGE))
, UDH1.CREATED_BY
, UDH1.CREATION_DATE
, UDH1.LAST_UPDATED_BY
, UDH1.LAST_UPDATE_DATE
, UDH1.LAST_UPDATE_LOGIN
FROM IGS_PS_UNT_DSCP_HIST UDH1
, IGS_PS_UNIT_DSCP UD1
, IGS_PS_UNIT_VER UV
WHERE UV.UNIT_CD = UDH1.UNIT_CD
AND UV.VERSION_NUMBER = UDH1.VERSION_NUMBER
AND UDH1.UNIT_CD = UD1.UNIT_CD (+)
AND UDH1.VERSION_NUMBER = UD1.VERSION_NUMBER (+)
AND UDH1.DISCIPLINE_GROUP_CD = UD1.DISCIPLINE_GROUP_CD (+) UNION ALL SELECT UD2.UNIT_CD
, UD2.VERSION_NUMBER
, UD2.DISCIPLINE_GROUP_CD
, NVL( MAX(UDH2.HIST_END_DT)
, UD2.LAST_UPDATE_DATE)
, TO_DATE(NULL)
, UD2.LAST_UPDATED_BY
, UD2.PERCENTAGE
, UD2.CREATED_BY
, UD2.CREATION_DATE
, UD2.LAST_UPDATED_BY
, UD2.LAST_UPDATE_DATE
, UD2.LAST_UPDATE_LOGIN
FROM IGS_PS_UNT_DSCP_HIST UDH2
, IGS_PS_UNIT_DSCP UD2
WHERE UD2.UNIT_CD = UDH2.UNIT_CD (+)
AND UD2.VERSION_NUMBER = UDH2.VERSION_NUMBER (+)
AND UD2.DISCIPLINE_GROUP_CD = UDH2.DISCIPLINE_GROUP_CD (+) GROUP BY UD2.UNIT_CD
, UD2.VERSION_NUMBER
, UD2.DISCIPLINE_GROUP_CD
, UD2.PERCENTAGE
, UD2.CREATED_BY
, UD2.CREATION_DATE
, UD2.LAST_UPDATED_BY
, UD2.LAST_UPDATE_DATE
, UD2.LAST_UPDATE_LOGIN