ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL3

➜ Back to Library
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"))
Download
Related Blitz Reports
ECC Contract Lifecycle Management, CLM Deliverables, SQL3 ECC Project Procurement, Deliverables, SQL1 ECC Contract Lifecycle Management, Solicitation Deliverables, SQL1 ECC Contract Lifecycle Management, Acquisitions, SQL1 ECC Procurement, Purchase Orders, SQL1 ECC Procurement, Agreements, SQL1 ECC Procurement, Indirect Procurement, SQL1 ECC Procurement, Indirect Procurement, SQL3 PON Solicitation data template
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: