ECC Discrete Quality, Collection Results

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Plan Name, Plan Description, Plan Type, Plan Id, Template Plan Id, Collection Id, Occurrence, Parent Plan Id, Parent Collection Id ...
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
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