고객센터
Home < 고객지원 < 일반자료실
 

제목

남호씨 매출마감 문장
(No.926) Name : 김현태 | View : 1191 | Date : 2007-03-20

loop
if :cb2.act_cd_c in ('15','30','11','62','13','10','41','61','49') then --추가
if :system.last_record = 'TRUE' then--추가
delete_record;--추가
exit;--추가
else--추가
delete_record;--추가
end if; --추가
else --추가
if :slip_div = '10' then
:dr_cash_cnt1 := nvl(:dr_cash_cnt1,0) + nvl(:dr_cash_cnt,0);
:dr_cash_amt1 := nvl(:dr_cash_amt1,0) + nvl(:dr_cash_amt,0);
:dr_tran_cnt1 := nvl(:dr_tran_cnt1,0) + nvl(:dr_tran_cnt,0);
:dr_tran_amt1 := nvl(:dr_tran_amt1,0) + nvl(:dr_tran_amt,0);
:cr_cash_cnt1 := nvl(:cr_cash_cnt1,0) + nvl(:cr_cash_cnt,0);
:cr_cash_amt1 := nvl(:cr_cash_amt1,0) + nvl(:cr_cash_amt,0);
:cr_tran_cnt1 := nvl(:cr_tran_cnt1,0) + nvl(:cr_tran_cnt,0);
:cr_tran_amt1 := nvl(:cr_tran_amt1,0) + nvl(:cr_tran_amt,0);
else
:dr_cash_cnt2 := nvl(:dr_cash_cnt2,0) + nvl(:dr_cash_cnt,0);
:dr_cash_amt2 := nvl(:dr_cash_amt2,0) + nvl(:dr_cash_amt,0);
:dr_tran_cnt2 := nvl(:dr_tran_cnt2,0) + nvl(:dr_tran_cnt,0);
:dr_tran_amt2 := nvl(:dr_tran_amt2,0) + nvl(:dr_tran_amt,0);
:cr_cash_cnt2 := nvl(:cr_cash_cnt2,0) + nvl(:cr_cash_cnt,0);
:cr_cash_amt2 := nvl(:cr_cash_amt2,0) + nvl(:cr_cash_amt,0);
:cr_tran_cnt2 := nvl(:cr_tran_cnt2,0) + nvl(:cr_tran_cnt,0);
:cr_tran_amt2 := nvl(:cr_tran_amt2,0) + nvl(:cr_tran_amt,0);
end if;
exit when :system.last_record = 'TRUE';
next_record;
end if; --추가
end loop;


 
이 름 비밀번호