ECC Contract Lifecycle Management, CLM Protest, SQL3
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, SQL3 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 protest_category ,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_CATEGORY' AND flv.lookup_code = prt.protest_category AND flv.view_application_id = 201 AND flv.language in ( 'US') AND gt.key = 3218980 ) PIVOT ( max(protest_category) as protest_category FOR language in ( 'US' "US")) ) x where 2=2 |
Blitz Report™