Changes between Version 12 and Version 13 of common

작성자:

anonymous (IP: 218.145.47.244)

날짜/시간:

2014-01-12 PM 5:39:04 (11 년 전)

설명:

--

common

@@ -12 +12 @@
- * [wiki:common/sanjo/2013_3]
- * [wiki:common/sanjo/2013_4]
+
+
+{{{
+@ 판매처 상세 리스트==> 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
+        from    buyerSelling01Detail a
+        where   a.cateringcode= 'A99'
+        and             a.messroomcode= '101'
+        and             a.buyerCode     = '100003'
+        and             a.buyingDay     = '20140130'
+        and             a.seq           = '1'
+
+}}}