ECC Contract Lifecycle Management, CLM Deliverables, SQL2

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Us Category ...
Imported from Enterprise Command Center
Dataset Key: po-clm-deliverables
Query Procedure: PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesAwd
select
x.*
from
(
SELECT * FROM ( 
SELECT  gt.char1 ecc_spec_id
       ,flv.meaning category
       ,flv.language
FROM    okc_deliverables del
       ,po_session_gt gt
       ,fnd_lookup_values flv
WHERE   del.deliverable_id = gt.num2
AND     flv.view_application_id = 0
AND     flv.lookup_type  = 'OKC_DEL_CATEGORIES'
AND     flv.lookup_code  = del.del_category_code
AND     flv.language in ( 'US')
AND     gt.key = 3197934 ) PIVOT ( max(category) as category
                                             FOR language in ( 'US' "US"))
) x
where
2=2