close

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

arrow
arrow
    全站熱搜

    oracleD2K 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄