ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL4

Description
Columns: Ecc Spec Id, Responsible Party Name ...
Imported from ECC
SELECT  gt.char1 ecc_spec_id
       ,sup.vendor_name RESPONSIBLE_PARTY_NAME
FROM    okc_deliverables del
       ,po_session_gt gt
       ,AP_SUPPLIERS sup
WHERE   del.deliverable_id = gt.num2
AND     del.EXTERNAL_PARTY_ID = sup.vendor_id
AND     gt.key = 3127026