ECC Contract Lifecycle Management, CLM Protest, SQL2
Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Us Protest Status ...
Columns: Ecc Spec Id, Us Protest Status ...
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
select x.* from ( 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 = 3197937 ) PIVOT ( max(protest_status) as protest_status FOR language in ( 'US' "US")) ) x where 2=2 |