eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGS_PS_OWN_HIST_V

Source

View Text - Preformatted


SELECT coh1.course_cd, coh1.version_number, coh1.org_unit_cd, coh1.ou_start_dt, coh1.hist_start_dt, coh1.hist_end_dt, coh1.hist_who, NVL( coh1.percentage, NVL( TO_NUMBER( IGS_AU_GEN_001.audp_get_coh_col( coh1.course_cd, coh1.version_number, coh1.org_unit_cd, coh1.ou_start_dt, coh1.hist_end_dt)), cow1.percentage)), coh1.created_by, coh1.creation_date, coh1.last_updated_by, coh1.last_update_date, coh1.last_update_login FROM IGS_PS_OWN_HIST coh1, IGS_PS_OWN cow1, IGS_PS_VER cv1 WHERE cv1.course_cd = coh1.course_cd AND cv1.version_number = coh1.version_number AND coh1.course_cd = cow1.course_cd (+) AND coh1.version_number = cow1.version_number (+) AND coh1.org_unit_cd = cow1.org_unit_cd (+) AND coh1.ou_start_dt = cow1.ou_start_dt (+) UNION ALL SELECT cow2.course_cd, cow2.version_number, cow2.org_unit_cd, cow2.ou_start_dt, NVL( MAX(coh2.hist_end_dt), cow2.last_update_date), TO_DATE(NULL), cow2.last_updated_by, cow2.percentage, cow2.created_by, cow2.creation_date, cow2.last_updated_by, cow2.last_update_date, cow2.last_update_login FROM IGS_PS_OWN_HIST coh2, IGS_PS_OWN cow2 WHERE cow2.course_cd = coh2.course_cd (+) AND cow2.version_number = coh2.version_number (+) AND cow2.org_unit_cd = coh2.org_unit_cd (+) AND cow2.ou_start_dt = coh2.ou_start_dt (+) GROUP BY cow2.course_cd, cow2.version_number, cow2.org_unit_cd, cow2.ou_start_dt, cow2.percentage, cow2.created_by, cow2.creation_date, cow2.last_updated_by, cow2.last_update_date, cow2.last_update_login

View Text - HTML Formatted

SELECT COH1.COURSE_CD
, COH1.VERSION_NUMBER
, COH1.ORG_UNIT_CD
, COH1.OU_START_DT
, COH1.HIST_START_DT
, COH1.HIST_END_DT
, COH1.HIST_WHO
, NVL( COH1.PERCENTAGE
, NVL( TO_NUMBER( IGS_AU_GEN_001.AUDP_GET_COH_COL( COH1.COURSE_CD
, COH1.VERSION_NUMBER
, COH1.ORG_UNIT_CD
, COH1.OU_START_DT
, COH1.HIST_END_DT))
, COW1.PERCENTAGE))
, COH1.CREATED_BY
, COH1.CREATION_DATE
, COH1.LAST_UPDATED_BY
, COH1.LAST_UPDATE_DATE
, COH1.LAST_UPDATE_LOGIN
FROM IGS_PS_OWN_HIST COH1
, IGS_PS_OWN COW1
, IGS_PS_VER CV1
WHERE CV1.COURSE_CD = COH1.COURSE_CD
AND CV1.VERSION_NUMBER = COH1.VERSION_NUMBER
AND COH1.COURSE_CD = COW1.COURSE_CD (+)
AND COH1.VERSION_NUMBER = COW1.VERSION_NUMBER (+)
AND COH1.ORG_UNIT_CD = COW1.ORG_UNIT_CD (+)
AND COH1.OU_START_DT = COW1.OU_START_DT (+) UNION ALL SELECT COW2.COURSE_CD
, COW2.VERSION_NUMBER
, COW2.ORG_UNIT_CD
, COW2.OU_START_DT
, NVL( MAX(COH2.HIST_END_DT)
, COW2.LAST_UPDATE_DATE)
, TO_DATE(NULL)
, COW2.LAST_UPDATED_BY
, COW2.PERCENTAGE
, COW2.CREATED_BY
, COW2.CREATION_DATE
, COW2.LAST_UPDATED_BY
, COW2.LAST_UPDATE_DATE
, COW2.LAST_UPDATE_LOGIN
FROM IGS_PS_OWN_HIST COH2
, IGS_PS_OWN COW2
WHERE COW2.COURSE_CD = COH2.COURSE_CD (+)
AND COW2.VERSION_NUMBER = COH2.VERSION_NUMBER (+)
AND COW2.ORG_UNIT_CD = COH2.ORG_UNIT_CD (+)
AND COW2.OU_START_DT = COH2.OU_START_DT (+) GROUP BY COW2.COURSE_CD
, COW2.VERSION_NUMBER
, COW2.ORG_UNIT_CD
, COW2.OU_START_DT
, COW2.PERCENTAGE
, COW2.CREATED_BY
, COW2.CREATION_DATE
, COW2.LAST_UPDATED_BY
, COW2.LAST_UPDATE_DATE
, COW2.LAST_UPDATE_LOGIN