2558: NVL(ps.vendor_site_code, -1) vendor_site_code
2559: FROM po_requisition_lines_all prl,
2560: pon_backing_requisitions ponbr,
2561: pon_auction_headers_all ponah,
2562: po_vendors pv,
2563: po_vendor_sites_all ps
2564: WHERE ponah.auction_header_id = p_document_number
2565: AND ponbr.auction_header_id = ponah.auction_header_id
2566: AND ponbr.requisition_header_id = prl.requisition_header_id