ECC Quality Management, Recent Jobs

Description
Categories: Enterprise Command Center
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 Enterprise Command Center
Description: Recent Jobs Data Set
Dataset Key: cn-cp
Query Procedure: CN_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: CN_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
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
Parameter Name SQL text Validation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV