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
目前分類:庫存模組 (2)
- Apr 02 Thu 2009 14:59
收料單號.日期.數量 SQL
- Apr 02 Thu 2009 14:36
採購-收料 TABLE(轉)
一、採購訂單(路徑:PO/採購訂單/採購訂單)
1、po_headers_all 採購訂單頭表
2、po_lines_all 採購訂單行表
--po_header_id=po_headers_all.po_header_id
--此表是保存採購訂單的行資訊