摘要: 1/收料CREATE OR REPLACE TRIGGER PO_APPROVED_AUTO_RECEIVE_sxafter UPDATE OF APPROVED_FLAG on po_line_locations_allREFERENCINGfor each rowWHEN (OLD.ship_to_organization_id = 1934and new.approved_flag ='Y')declarev_sysdate DATE := SYSDATE;v_vendor_id NUMBER;v_vendor_site_id NUMBER;--v_vendor_name 阅读全文
posted @ 2011-06-20 18:44 大卫.宋 阅读(1142) 评论(0) 推荐(0) 编辑