ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL2

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 = 3127026 ) PIVOT ( max(category) as category
                                             FOR language in ( 'US' "US"))