问题是,对于每个事务,当系统存储被删除并替换为给定事务(或tran id)的供应商账单时,我将获得多个事务号。select ift.tranid, ift.transaction_number, a.full_name, sum(tl.amount) from ns.tbill iftmax(ift.transaction_number) from group by ift.tranid, a.full_name, ift
尝试存储以下过程时: my_zn IN NUMBER, my_verwaltung IN VARCHAR2, my_variante IN NUMBER, my_vp IN NUMBER
search_VP IFT_INFO_LAUF.VP%TYPE;found_VP IFT_INFO_LAUF.VP%TYPE;
BEGIN -- se
shipping_T sht on p.shippingIdx = sht.idxjoin itemFrom_T ifton st.custIdx = ift.custidxgroup by sl.pnumshipping_T sht on p.shippingIdx = sht.idx
join sales_T st on