VIEW: APPS.IGS_PS_TCH_RESP_UOO_V

Source

View Text - Preformatted

SELECT uoo.unit_cd, uoo.version_number, uoo.CAL_TYPE, uoo.ci_sequence_number, uoo.location_cd, uoo.unit_class, tr.org_unit_cd, tr.ou_start_dt, uoo.uoo_id, tr.percentage, uoo.created_by, uoo.creation_date, uoo.last_updated_by, uoo.last_update_date, uoo.last_update_login FROM IGS_PS_UNIT_OFR_OPT uoo, IGS_PS_TCH_RESP tr WHERE NOT EXISTS ( SELECT unit_cd FROM IGS_PS_TCH_RESP_OVRD WHERE uoo_id = uoo.uoo_id ) AND tr.unit_cd = uoo.unit_cd AND tr.version_number = uoo.version_number UNION ALL SELECT uoo.unit_cd, uoo.version_number, uoo.CAL_TYPE, uoo.ci_sequence_number, uoo.location_cd, uoo.unit_class, tro.org_unit_cd, tro.ou_start_dt, uoo.uoo_id, tro.percentage, uoo.created_by, uoo.creation_date, uoo.last_updated_by, uoo.last_update_date, uoo.last_update_login FROM IGS_PS_UNIT_OFR_OPT uoo, IGS_PS_TCH_RESP_OVRD tro WHERE tro.uoo_id = uoo.uoo_id

View Text - HTML Formatted

SELECT UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, UOO.LOCATION_CD
, UOO.UNIT_CLASS
, TR.ORG_UNIT_CD
, TR.OU_START_DT
, UOO.UOO_ID
, TR.PERCENTAGE
, UOO.CREATED_BY
, UOO.CREATION_DATE
, UOO.LAST_UPDATED_BY
, UOO.LAST_UPDATE_DATE
, UOO.LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_TCH_RESP TR
WHERE NOT EXISTS ( SELECT UNIT_CD
FROM IGS_PS_TCH_RESP_OVRD
WHERE UOO_ID = UOO.UOO_ID )
AND TR.UNIT_CD = UOO.UNIT_CD
AND TR.VERSION_NUMBER = UOO.VERSION_NUMBER UNION ALL SELECT UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, UOO.LOCATION_CD
, UOO.UNIT_CLASS
, TRO.ORG_UNIT_CD
, TRO.OU_START_DT
, UOO.UOO_ID
, TRO.PERCENTAGE
, UOO.CREATED_BY
, UOO.CREATION_DATE
, UOO.LAST_UPDATED_BY
, UOO.LAST_UPDATE_DATE
, UOO.LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_TCH_RESP_OVRD TRO
WHERE TRO.UOO_ID = UOO.UOO_ID