ECC Contract Lifecycle Management, Solicitations, SQL6

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 PRO_ADMIN_OFFICE_HiddenAddType , EXT.HiddenLKPType AS PRO_ADMIN_OFFICE_HiddenLKPType , EXT.addresscode_DISP AS PRO_ADMIN_OFFICE_addresscode , EXT.addressdetails AS PRO_ADMIN_OFFICE_addressdetail , EXT.addressdtlsxml AS PRO_ADMIN_OFFICE_addressdtlsxm , EXT.addresstype_DISP AS PRO_ADMIN_OFFICE_addresstype , EXT.contact_DISP AS PRO_ADMIN_OFFICE_contact , EXT.contactdetails AS PRO_ADMIN_OFFICE_contactdetail , EXT.contactdtlsxml AS PRO_ADMIN_OFFICE_contactdtlsxm , EXT.hiddenCountry AS PRO_ADMIN_OFFICE_hiddenCountry , EXT.hiddenZipCode AS PRO_ADMIN_OFFICE_hiddenZipCode , EXT.location_DISP AS PRO_ADMIN_OFFICE_location FROM PO_SESSION_GT gt  ,  EXT WHERE  gt.key = 3197942 AND ext.AUCTION_HEADER_ID = gt.num1   AND ext.addresstype = 'PRO_ADMIN_OFFICE' 
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV