oracle園地

SELECT   rsh.receipt_num,rsh.last_update_date receipt_date,rsl.QUANTITY_RECEIVED,rsl.UNIT_OF_MEASURE
    FROM rcv_shipment_headers rsh,rcv_shipment_lines rsl
   WHERE rsh.receipt_source_code = 'VENDOR'
         AND rsh.creation_date >= ADD_MONTHS (TRUNC (SYSDATE, 'DD'), -12)
         AND rsh.ship_to_org_id = 55
         AND rsh.receipt_num='90003610'
         and rsh.SHIPMENT_HEADER_ID = rsl.SHIPMENT_HEADER_ID
ORDER BY rsh.creation_date desc

一、採購訂單（路徑：PO/採購訂單/採購訂單）
1、po_headers_all 採購訂單頭表