ECC Contract Lifecycle Management, CLM Protest, SQL3

select
x.*
from
(
SELECT * FROM ( SELECT gt.char1 ecc_spec_id
        ,flv.meaning protest_category
        ,flv.language
FROM    po_protests prt,
        po_session_gt gt,
        fnd_lookup_values flv
WHERE   prt.document_id = gt.index_num2
AND     prt.protest_id = gt.num2
AND     flv.lookup_type = 'PO_PROTEST_CATEGORY'
AND     flv.lookup_code = prt.protest_category
AND     flv.view_application_id = 201
AND     flv.language in ( 'US')
AND     gt.key = 3218980 ) PIVOT ( max(protest_category) as protest_category
                                             FOR language in ( 'US' "US"))
) x
where
2=2