ECC Quality Management, Recent Jobs, SQL1

Description
Columns: Ecc Spec Id, Org Id, Start Period Id, End Period Id, Start Period Name, End Period Name, Ecc Last Update Date, Start Date, End Date, Request Id ...
Imported from ECC
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"))