* [wiki:common/car car] * [wiki:common/river river] * [wiki:common/health health] * [wiki:common/발음 발음] * [wiki:common/alcol 술] * [wiki:common/eye 노안] * [wiki:common/가온팬션 가온팬션] * [wiki:common/상조회 상조회] * [wiki:common/족저근막염 족저근막염] * [wiki:common/게임 게임] * [wiki:common/sanjo/2013_3] * [wiki:common/sanjo/2013_4] {{{ getHome(BuyerSelling01DetailJNDI,net.mtn.caps.buyer.ejb.BuyerSelling01DetailHome) @ 판매처 상세 리스트==> select a.seq1, a.ticketCode, a.ticketName, 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 from buyerSelling01Detail a where a.cateringcode= 'A99' and a.messroomcode= '101' and a.buyerCode = '100003' and a.buyingDay = '20140130' and a.seq = '1' OPENERR717 }}}