1 Reply Latest reply on Feb 22, 2016 1:05 PM by Srini Chavali-Oracle

    Need help:Performance Problem in 3 way matching SQL Query

    1567114

      Helllo,

       

      The below Query for 3 way matching is having performance issues

       

      Please advise

       

       

      SELECT

            pha.segment1 po_number ,

            pha.po_header_id ,

            rcv_h.receipt_num receipt_number,

            pla.po_line_id ,

            pla.line_num po_line_num ,

            pla.unit_price ,

            pla.attribute10 condition,

            pla.quantity po_line_qty,

            nvl(rcv_l.quantity_received,0) po_qty_receive

        FROM

            po_headers_all pha ,

            po_lines_all pla ,

            rcv_shipment_headers rcv_h,

            rcv_shipment_lines rcv_l

        WHERE

              pla.po_line_id   = pha.po_header_id

          AND rcv_l.po_line_id      = pla.po_line_id

          AND rcv_h.shipment_header_id=rcv_l.shipment_header_id