ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL3

Description
Columns: Ecc Spec Id, Responsible Party Name, Internal Contact, Us Internal Organization ...
Imported from ECC
SELECT * FROM ( 
SELECT  gt.char1 ecc_spec_id
       ,org.name RESPONSIBLE_PARTY_NAME
       ,org_tl.name INTERNAL_ORGANIZATION
       ,org_tl.language
       ,ppf.full_name INTERNAL_CONTACT
FROM    okc_deliverables del
       ,po_session_gt gt
       ,HR_ALL_ORGANIZATION_UNITS_TL org_tl
       ,HR_ALL_ORGANIZATION_UNITS org
       ,per_all_people_f ppf
WHERE   del.deliverable_id = gt.num2
AND     del.INTERNAL_PARTY_ID = org.ORGANIZATION_ID
AND     org.ORGANIZATION_ID = org_tl.ORGANIZATION_ID
AND     ppf.person_id = del.internal_party_contact_id
AND     ppf.effective_start_date <= SYSDATE
AND     (ppf.effective_end_date is NULL OR ppf.effective_end_date> sysdate)
AND     org_tl.language in ( 'US')
AND     gt.key = 3127026 ) PIVOT ( max(INTERNAL_ORGANIZATION) as INTERNAL_ORGANIZATION
                                             FOR language in ( 'US' "US"))