RANGE SCAN

Hi All,

I have below query

SELECT

   

    msib.segment1    "HAT ITEM NUMBER",

    pha.segment1     "PO NUMBER",

    pv.vendor_name   "SUPPLIER",

    pra.release_num  ,

    pha.po_header_id,

    pla.po_line_id

FROM

    apps.rcv_transactions   rt,

    apps.po_headers_all          pha,

    apps.po_lines_all            pla,

    apps.po_vendors              pv,

    apps.PO_RELEASES_ALL         pra,

    apps.mtl_system_items_b      msib,

    apps.cst_item_costs          cic

WHERE

    1 = 1

  

  --  AND rt.transaction_type = 'DELIVER'

--    AND rt.DESTINATION_TYPE_CODE = 'INVENTORY'

    AND cic.cost_type_id = 7 --CTO

    AND rt.po_header_id = pha.po_header_id

    AND rt.vendor_id = pv.vendor_id