ECC Quality Management, Recent Jobs

➜ Back to Library
Description
Categories: Enterprise Command Center
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
Run ECC Quality Management, Recent Jobs and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
ECC Quality Management, Quota and Attainment ECC Quality Management, Sales Transaction ECC Depot Repair, Depot Resolved Service Orders ECC Depot Repair, Depot Service Orders ECC Process Manufacturing, Outside Processing Batch ECC G-Invoicing, Projects: G-Invoicing ECC Projects, Projects Costing: Transactions, SQL1 JA Cash Flow Statement Program - Cash Flow Detail ECC Projects, Projects Costing: Transactions, SQL2
Blitz Report™

Blitz Report™ provides multiple benefits: