ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL6

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, SQL6 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
 
SELECT  gt.char1 ecc_spec_id
       ,ppf.full_name REQUESTER
FROM    okc_deliverables del
       ,po_session_gt gt
       ,per_all_people_f ppf
WHERE   del.deliverable_id = gt.num2
AND     ppf.person_id = del.requester_id
AND     ppf.effective_start_date <= SYSDATE
AND     (ppf.effective_end_date is NULL OR ppf.effective_end_date> sysdate)
AND     gt.key = 3218976
) x
where
2=2