ECC Contract Lifecycle Management, CLM Protest, SQL2

➜ Back to Library
Description
Columns: Ecc Spec Id, Us Protest Status ...
Imported from ECC 
SELECT * FROM ( SELECT gt.char1 ecc_spec_id
        ,flv.meaning protest_status
        ,flv.language
FROM    po_protests prt,
        po_session_gt gt,
        fnd_lookup_values flv
WHERE   prt.document_id = gt.index_num2
AND     prt.protest_id = gt.num2
AND     flv.lookup_type = 'PO_PROTEST_STATUS'
AND     flv.lookup_code = prt.protest_status
AND     flv.view_application_id = 201
AND     flv.language in ( 'US')
AND     gt.key = 3127023 ) PIVOT ( max(protest_status) as protest_status
                                             FOR language in ( 'US' "US"))
Download
Related Blitz Reports
ECC Contract Lifecycle Management, CLM Protest, SQL3 ECC Contract Lifecycle Management, CLM Protest, SQL1 ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL1 ECC Procurement, Agreements, SQL3 ECC Procurement, Agreements, SQL2 ECC Procurement, Agreements, SQL1 ECC Contract Lifecycle Management, CLM Deliverables, SQL2 ECC Contract Lifecycle Management, CLM Deliverables, SQL1 ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL2
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: