ECC Discrete Quality, Collection Results

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: qa-quality
Query Procedure: QA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: qa_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Discrete Quality, Collection Results and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT * FROM ( SELECT ECC_SPEC_ID,PLAN_NAME,PLAN_DESCRIPTION,PLAN_TYPE,PLAN_ID,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_BUCKET,WIP_NAVIGATION_LINK FROM QA_ECC_RESULTS_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