摘要:
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 阅读全文