ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL2
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
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 |
Blitz Report™