ECC Contract Lifecycle Management, Solicitations, SQL5

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: po-clm-solicitations
Query Procedure: po_pon_ecc_util_pvt.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesSol
select
x.*
from
(
 SELECT   gt.char1 ECC_SPEC_ID, EXT.HiddenAddType AS ISSUING_OFFICE_HiddenAddType , EXT.HiddenLKPType AS ISSUING_OFFICE_HiddenLKPType , EXT.addresscode_DISP AS ISSUING_OFFICE_addresscode , EXT.addressdetails AS ISSUING_OFFICE_addressdetails , EXT.addressdtlsxml AS ISSUING_OFFICE_addressdtlsxml , EXT.addresstype_DISP AS ISSUING_OFFICE_addresstype , EXT.contact_DISP AS ISSUING_OFFICE_contact , EXT.contactdetails AS ISSUING_OFFICE_contactdetails , EXT.contactdtlsxml AS ISSUING_OFFICE_contactdtlsxml , EXT.hiddenCountry AS ISSUING_OFFICE_hiddenCountry , EXT.hiddenZipCode AS ISSUING_OFFICE_hiddenZipCode , EXT.location_DISP AS ISSUING_OFFICE_location FROM PO_SESSION_GT gt  ,  EXT WHERE  gt.key = 3197942 AND ext.AUCTION_HEADER_ID = gt.num1   AND ext.addresstype = 'ISSUING_OFFICE' 
) x
where
2=2
Parameter NameSQL textValidation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV
Download
Related Blitz Reports
ECC Contract Lifecycle Management, Requisitions, SQL5 ECC Contract Lifecycle Management, Requisitions, SQL2 ECC Contract Lifecycle Management, Requisitions, SQL1 ECC Contract Lifecycle Management, Requisitions, SQL6 ECC Contract Lifecycle Management, Requisitions, SQL10 ECC Contract Lifecycle Management, Requisitions, SQL9 ECC Contract Lifecycle Management, Requisitions, SQL8 ECC Contract Lifecycle Management, Requisitions, SQL7 ECC Contract Lifecycle Management, Solicitations, SQL7
Blitz Report In Action
Blitz Report™