ECC Quality Management, Recent Jobs

select
x.*
from
(
SELECT * FROM (SELECT * FROM CN_ECC_CR_V WHERE LANGUAGE IN ('US')) PIVOT
                                        (max(OPERATING_UNIT) as OPERATING_UNIT,
										 max(JOB_NAME)       as JOB_NAME,
										 max(PROGRAM_NAME)   as PROGRAM_NAME,
										 max(JOB_STATUS)     as JOB_STATUS
										 for LANGUAGE in ('US' "US"))
) x
where
2=2