ECC Contract Lifecycle Management, CLM Deliverables, SQL3

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Responsible Party Name, Internal Contact, Us Internal Organization ...
Imported from Enterprise Command Center
Dataset Key: po-clm-deliverables
Query Procedure: PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesAwd
select
x.*
from
(
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 = 3197934 ) PIVOT ( max(INTERNAL_ORGANIZATION) as INTERNAL_ORGANIZATION
                                             FOR language in ( 'US' "US"))
) x
where
2=2