ECC Discrete Quality, Corrective Actions, SQL1

Description
Columns: Tx Desc, Date Bucket, Template Plan Id, Collection Id, Occurrence, Parent Plan Id, Parent Collection Id, Parent Occurrence, Taxonomy Key, Parent Plan Name ...
Imported from ECC
SELECT * FROM ( SELECT TX_DESC,DATE_BUCKET,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,ECC_SPEC_ID,PLAN_NAME,PLAN_DESCRIPTION,PLAN_TYPE,PLAN_ID FROM QA_ECC_RESULTS_CA_V WHERE LANGUAGE IN ('US'))
                                     PIVOT ( MAX(ITEM_DESCRIPTION) AS ITEM_DESCRIPTION FOR LANGUAGE IN ('US' "US"))