ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL3

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: po-clm-close-out
Query Procedure: PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesAwd
Run ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL3 and other Oracle EBS reports with Blitz Report™ on our demo environment
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 = 3218976 ) PIVOT ( max(INTERNAL_ORGANIZATION) as INTERNAL_ORGANIZATION
                                             FOR language in ( 'US' "US"))
) x
where
2=2
Download
Related Blitz Reports
ECC Procurement, Purchase Orders ECC Procurement, Agreements ECC Contract Lifecycle Management, CLM Deliverables, SQL3 ECC Contract Lifecycle Management, Acquisitions ECC Project Procurement, Deliverables ECC Contract Lifecycle Management, Solicitation Deliverables ECC Contract Lifecycle Management, Requisitions, SQL9 ECC Procurement, Indirect Procurement, SQL3 ECC Procurement, Indirect Procurement, SQL1
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™