ECC Contract Lifecycle Management, CLM Protest, SQL4
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: po-clm-protest
Query Procedure: PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesAwd
Dataset Key: po-clm-protest
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 Protest, SQL4 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 document_status, flv.language FROM po_headers_all poh, po_session_gt gt, fnd_lookup_values flv WHERE poh.po_header_id = gt.index_num2 AND poh.clm_closeout_status IS NOT NULL AND flv.view_application_id (+) = 201 AND flv.lookup_type = 'PO_CLM_CLOSEOUT_STATUS' AND flv.lookup_code = poh.clm_closeout_status AND flv.language in ( 'US') AND gt.key = 3218980 ) PIVOT ( max(document_status) as document_status FOR language in ( 'US' "US")) ) x where 2=2 |
Blitz Report™