ECC Quality Management, Recent Jobs
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
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 |
|
LOV |