[Home] [Help]
1845: v.freight_cost_g1,
1846: v.charge_periodicity_code,
1847: v.blanket_number,
1848: v.blanket_line_number
1849: FROM ISCBV_BOOK_SUM2_FCV v;
1850:
1851: l_total := sql%rowcount;
1852: COMMIT;
1853:
1887:
1888:
1889: MERGE INTO ISC_BOOK_SUM2_F f
1890: USING
1891: (select new.* from ISCBV_BOOK_SUM2_FCV new, ISC_BOOK_SUM2_F old
1892: where new.line_id = old.line_id(+)
1893: and new.batch_id = v_batch_id
1894: and (old.line_id is null
1895: or new.customer_id <> old.customer_id