ECC Discrete Quality, Nonconformances

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-nc
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 WIP_NAVIGATION_LINK,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,DAYS_OPEN 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