PO Vendor Purchase Summary

Description
Categories: BI Publisher
Application: Purchasing
Source: Vendor Purchase Summary Report (XML)
Short Name: POXPOVPS_XML
DB package: PO_POXPOVPS_XMLP_PKG
SELECT   decode (:P_ORDERBY,'VENDOR TYPE',pov.vendor_type_lookup_code,pov.vendor_name) sort_column
,	pov.vendor_name                           Vendor
,        pov.segment1                             Vendor_Number
,        pov.vendor_type_lookup_code               Vendor_Type,
        decode(pov.small_business_flag,'Y',
                :yes,:no)                          Small_Business
,        decode(pov.women_owned_flag,'Y',
                :yes,:no)                          Women_Owned
,        decode(psp1.manual_po_num_type, 'NUMERIC',
                null, poh.segment1)
,        decode(psp1.manual_po_num_type,