ECC Contract Lifecycle Management, CLM Deliverables, SQL5

➜ Back to Library
Description
Categories: Enterprise Command Center
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
Run ECC Contract Lifecycle Management, CLM Deliverables, SQL5 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
 
SELECT  gt.char1 ecc_spec_id
       ,hz.party_name SUPPLIER_CONTACT
FROM    okc_deliverables del
       ,po_session_gt gt
       ,hz_parties hz
WHERE   del.deliverable_id = gt.num2
AND     del.EXTERNAL_PARTY_CONTACT_ID = hz.party_id
AND     gt.key = 3218977
) x
where
2=2
Download
Related Blitz Reports
ECC Procurement, Agreements ECC Procurement, Purchase Orders ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL5 ECC Procurement, Purchase Orders (2) ECC Procurement, Purchase Orders (1) ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL1 ECC Contract Lifecycle Management, CLM Deliverables, SQL1 ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL3 ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL2
Blitz Report™

Blitz Report™ provides multiple benefits: