ECC Discrete Quality, Nonconformances

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: qa-nc
Query Procedure: QA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: qa_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Discrete Quality, Nonconformances and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT * FROM ( SELECT TEMPLATE_PLAN_ID,COLLECTION_ID,OCCURRENCE,PARENT_PLAN_ID,PARENT_COLLECTION_ID,PARENT_OCCURRENCE,TAXONOMY_KEY,PARENT_PLAN_NAME,ROOT_PLAN_NAME,ROOT_OCCURRENCE,ORGANIZATION_ID,ORG_ID,ORGANIZATION_NAME,ORGANIZATION_CODE,ECC_CREATION_DATE,ECC_LAST_UPDATE_DATE,QA_CREATION_DATE,ITEM_DESCRIPTION,LANGUAGE,CREATED_BY,LAST_UPDATED_BY,TXN_GROUP,TXN_NUMEBR,TX_DESC,DATE_CLOSED,DATE_OPENED,DATE_BUCKET,DAYS_OPEN,WIP_NAVIGATION_LINK,ECC_SPEC_ID,PLAN_NAME,PLAN_DESCRIPTION,PLAN_TYPE,PLAN_ID FROM QA_ECC_RESULTS_NC_V WHERE LANGUAGE IN ('US'))
                                      PIVOT ( MAX(ITEM_DESCRIPTION) AS ITEM_DESCRIPTION, MAX(WIP_NAVIGATION_LINK) AS WIP_NAVIGATION_LINK FOR LANGUAGE IN ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Organization Code 
x.organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:organization_code)
 LOV
Download
Related Blitz Reports
ECC Discrete Quality, Collection Results ECC Discrete Quality, Corrective Actions ECC Discrete Manufacturing, Work Orders ECC Genealogy and Trace, Serial Numbers ECC Process Genealogy and Trace, Sales Orders ECC Genealogy and Trace, Lot Numbers ECC Genealogy and Trace, Work Orders ECC Process Genealogy and Trace, Lot Numbers ECC Process Genealogy and Trace, Serial Numbers
Blitz Report™

Blitz Report™ provides multiple benefits: