VIEW: APPS.IGS_PS_TCH_RESP_HIST_V

Source

View Text - Preformatted

SELECT trh1.unit_cd, trh1.version_number, trh1.org_unit_cd, trh1.ou_start_dt, trh1.hist_start_dt, trh1.hist_end_dt, trh1.hist_who, NVL( trh1.percentage, NVL( TO_NUMBER( IGS_AU_GEN_004.audp_get_trh_col( trh1.unit_cd, trh1.version_number, trh1.org_unit_cd, trh1.ou_start_dt, trh1.hist_end_dt)), tr1.percentage)), trh1.created_by, trh1.creation_date, trh1.last_updated_by, trh1.last_update_date, trh1.last_update_login FROM IGS_PS_TCH_RESP_HIST trh1, IGS_PS_TCH_RESP tr1, IGS_PS_UNIT_VER uv WHERE uv.unit_cd = trh1.unit_cd AND uv.version_number = trh1.version_number AND trh1.unit_cd = tr1.unit_cd (+) AND trh1.version_number = tr1.version_number (+) AND trh1.org_unit_cd = tr1.org_unit_cd (+) AND trh1.ou_start_dt = tr1.ou_start_dt (+) UNION ALL SELECT tr2.unit_cd, tr2.version_number, tr2.org_unit_cd, tr2.ou_start_dt, NVL( MAX(trh2.hist_end_dt), tr2.last_update_date), TO_DATE(NULL), tr2.last_updated_by, tr2.percentage, tr2.created_by, tr2.creation_date, tr2.last_updated_by, tr2.last_update_date, tr2.last_update_login FROM IGS_PS_TCH_RESP_HIST trh2, IGS_PS_TCH_RESP tr2 WHERE tr2.unit_cd = trh2.unit_cd (+) AND tr2.version_number = trh2.version_number (+) AND tr2.org_unit_cd = trh2.org_unit_cd (+) AND tr2.ou_start_dt = trh2.ou_start_dt (+) GROUP BY tr2.unit_cd, tr2.version_number, tr2.org_unit_cd, tr2.ou_start_dt, tr2.percentage, tr2.created_by, tr2.creation_date, tr2.last_updated_by, tr2.last_update_date, tr2.last_update_login

View Text - HTML Formatted

SELECT TRH1.UNIT_CD
, TRH1.VERSION_NUMBER
, TRH1.ORG_UNIT_CD
, TRH1.OU_START_DT
, TRH1.HIST_START_DT
, TRH1.HIST_END_DT
, TRH1.HIST_WHO
, NVL( TRH1.PERCENTAGE
, NVL( TO_NUMBER( IGS_AU_GEN_004.AUDP_GET_TRH_COL( TRH1.UNIT_CD
, TRH1.VERSION_NUMBER
, TRH1.ORG_UNIT_CD
, TRH1.OU_START_DT
, TRH1.HIST_END_DT))
, TR1.PERCENTAGE))
, TRH1.CREATED_BY
, TRH1.CREATION_DATE
, TRH1.LAST_UPDATED_BY
, TRH1.LAST_UPDATE_DATE
, TRH1.LAST_UPDATE_LOGIN
FROM IGS_PS_TCH_RESP_HIST TRH1
, IGS_PS_TCH_RESP TR1
, IGS_PS_UNIT_VER UV
WHERE UV.UNIT_CD = TRH1.UNIT_CD
AND UV.VERSION_NUMBER = TRH1.VERSION_NUMBER
AND TRH1.UNIT_CD = TR1.UNIT_CD (+)
AND TRH1.VERSION_NUMBER = TR1.VERSION_NUMBER (+)
AND TRH1.ORG_UNIT_CD = TR1.ORG_UNIT_CD (+)
AND TRH1.OU_START_DT = TR1.OU_START_DT (+) UNION ALL SELECT TR2.UNIT_CD
, TR2.VERSION_NUMBER
, TR2.ORG_UNIT_CD
, TR2.OU_START_DT
, NVL( MAX(TRH2.HIST_END_DT)
, TR2.LAST_UPDATE_DATE)
, TO_DATE(NULL)
, TR2.LAST_UPDATED_BY
, TR2.PERCENTAGE
, TR2.CREATED_BY
, TR2.CREATION_DATE
, TR2.LAST_UPDATED_BY
, TR2.LAST_UPDATE_DATE
, TR2.LAST_UPDATE_LOGIN
FROM IGS_PS_TCH_RESP_HIST TRH2
, IGS_PS_TCH_RESP TR2
WHERE TR2.UNIT_CD = TRH2.UNIT_CD (+)
AND TR2.VERSION_NUMBER = TRH2.VERSION_NUMBER (+)
AND TR2.ORG_UNIT_CD = TRH2.ORG_UNIT_CD (+)
AND TR2.OU_START_DT = TRH2.OU_START_DT (+) GROUP BY TR2.UNIT_CD
, TR2.VERSION_NUMBER
, TR2.ORG_UNIT_CD
, TR2.OU_START_DT
, TR2.PERCENTAGE
, TR2.CREATED_BY
, TR2.CREATION_DATE
, TR2.LAST_UPDATED_BY
, TR2.LAST_UPDATE_DATE
, TR2.LAST_UPDATE_LOGIN