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
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