ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL2

➜ 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, SQL2 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT * FROM ( 
SELECT  gt.char1 ecc_spec_id
       ,flv.meaning category
       ,flv.language
FROM    okc_deliverables del
       ,po_session_gt gt
       ,fnd_lookup_values flv
WHERE   del.deliverable_id = gt.num2
AND     flv.view_application_id = 0
AND     flv.lookup_type  = 'OKC_DEL_CATEGORIES'
AND     flv.lookup_code  = del.del_category_code
AND     flv.language in ( 'US')
AND     gt.key = 3218976 ) PIVOT ( max(category) as category
                                             FOR language in ( 'US' "US"))
) x
where
2=2
Download
Related Blitz Reports
ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL1 ECC Procurement, Purchase Orders ECC Contract Lifecycle Management, CLM Deliverables, SQL2 ECC Procurement, Agreements ECC Contract Lifecycle Management, CLM Deliverables, SQL1 ECC Contract Lifecycle Management, Solicitation Forms ECC Contract Lifecycle Management, Acquisitions ECC Project Procurement, Deliverables ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL3
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™