oracle園地

SELECT
 /*+ INDEX(  
       rsh  rcv_shipment_headers,
       rsl  rcv_shipment_lines,
       ph   po_headers_all,
       pl   po_lines_all,
       msi  mtl_system_items_b,
       pv   po_vendors
     )  
   */
rsh.receipt_num,rsh.last_update_date receipt_date,rsl.QUANTITY_RECEIVED,ph.SEGMENT1 po_number,Pl.ITEM_DESCRIPTION,rsl.VENDOR_LOT_NUM,pv.VENDOR_NAME
FROM rcv_shipment_headers rsh,rcv_shipment_lines rsl,po_headers_all ph,po_lines_all pl,mtl_system_items_b msi,po_vendors pv
WHERE rsh.receipt_source_code = 'VENDOR'
AND rsh.creation_date >= ADD_MONTHS (TRUNC (SYSDATE, 'DD'), -12)
AND rsh.ship_to_org_id = 127
and rsh.SHIPMENT_HEADER_ID = rsl.SHIPMENT_HEADER_ID
and rsl.PO_HEADER_ID=ph.PO_HEADER_ID
and ph.PO_HEADER_ID=pl.PO_HEADER_ID
and pl.ITEM_ID=msi.inventory_item_id
and msi.ORGANIZATION_ID=127
and ph.ORG_ID=125
and ph.vendor_id=pv.vendor_id
and pv.ENABLED_FLAG='Y'
ORDER BY rsh.creation_date desc