• car
• river
• health
• 발음
• 술
• 노안
• 가온팬션
• 상조회
• 족저근막염
• 게임
• common/sanjo/2013_3
• 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