采购接收选PO的LOV的sql

SELECT ph.segment1 , ph.po_header_id, ph.type_lookup_code, ph.displayed_field type, ph.vendor_name, ph.vendor_id, ph.full_name, 'Vendor' , ph.org_id, MO_GLOBAL.get_ou_name (ph.org_id) operating_unit FROM po_pos_val_trx_v ph WHERE (SEGMENT1 LIKE :1) AND ( exists ( SELECT 'Valid PO Shipments' FROM po_line_locations_trx_v poll WHERE ph.po_header_id = poll.po_header_id AND nvl(poll.approved_flag,'N') = 'Y' AND nvl(poll.cancel_flag,'N') = 'N' AND poll.shipment_type in ('STANDARD','BLANKET','SCHEDULED') AND poll.ship_to_organization_id = :2 ) AND rownum >= 1 AND ph.org_id = nvl(:3,ph.org_id) ) ORDER BY decode(rtrim(ph.segment1,'0123456789'),null,null,ph.segment1), decode(rtrim(ph.segment1,'0123456789'),null,to_number(ph.segment1),null)