Changes between Version 13 and Version 14 of common
- 날짜/시간:
- 2014-01-12 PM 5:40:27 (11 년 전)
Legend:
- 변경되지 않음
- 추가됨
- 제거됨
- 변경됨
-
common
v13 v14 15 15 16 16 {{{ 17 getHome(BuyerSelling01DetailJNDI,net.mtn.caps.buyer.ejb.BuyerSelling01DetailHome) 17 18 @ 판매처 상세 리스트==> select a.seq1, a.ticketCode, a.ticketName, 18 nvl((select b.isVat from ticketMessroom b where b.cateringcode=a.cateringco de and b.messroomcode=a.messroomcode and b 19 nvl((select b.isVat from ticketMessroom b where b.cateringcode=a.cateringco de and b.messroomcode=a.messroomcode and b.ticketcode=a.ticketcode),'U') isVat, a.saleQty, a.ticketPrice, a.sellingAmt, a.Vat, a.totalAmt, a.mealCode, a.cornerCode, a.remark, a.ticketNo1, a.ticketNo2 19 20 from buyerSelling01Detail a 20 21 where a.cateringcode= 'A99' 24 25 and a.seq = '1' 25 26 27 OPENERR717 26 28 }}}