ECC Contract Lifecycle Management, Solicitations, SQL5
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
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 Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
| LOV |