ECC Contract Lifecycle Management, CLM Deliverables, SQL5

select
x.*
from
(
 
SELECT  gt.char1 ecc_spec_id
       ,hz.party_name SUPPLIER_CONTACT
FROM    okc_deliverables del
       ,po_session_gt gt
       ,hz_parties hz
WHERE   del.deliverable_id = gt.num2
AND     del.EXTERNAL_PARTY_CONTACT_ID = hz.party_id
AND     gt.key = 3197934
) x
where
2=2