SELECT unique un.unit_cd, uv.title, un.created_by, un.creation_date, un.last_updated_by, un.last_update_date, un.last_update_login from IGS_PS_UNIT_STAT us, IGS_PS_UNIT_VER uv, IGS_PS_UNIT un WHERE un.unit_cd = uv.unit_cd and uv.expiry_dt is null and uv.unit_status = us.unit_status and us.s_unit_status != 'INACTIVE'
SELECT UNIQUE UN.UNIT_CD
, UV.TITLE
, UN.CREATED_BY
, UN.CREATION_DATE
, UN.LAST_UPDATED_BY
, UN.LAST_UPDATE_DATE
, UN.LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_STAT US
, IGS_PS_UNIT_VER UV
, IGS_PS_UNIT UN
WHERE UN.UNIT_CD = UV.UNIT_CD
AND UV.EXPIRY_DT IS NULL
AND UV.UNIT_STATUS = US.UNIT_STATUS
AND US.S_UNIT_STATUS != 'INACTIVE'
|
|
|