°è»ê¼­ ÇÕ°èÇ¥(°©,À»)
¼¼±Ý°è»ê¼­ ÇÕ°èÇ¥(°©,À»)

LFMN1403¿¡¼­ Äõ¸®¹® °¡Á®´Ù°¡ ¸Í±Û¾úÀ½
¼¼±Ý°è»ê¼­ ¸ÅÃâÀÌ ¼ö»óÇϹǷΠformsºÎÅÍ °ËÅä¹Ù¶÷
(Ãâ·Â¹°Àº ¶È°°ÀÌ ÇßÀ¸´Ï±î °°ÀÌ °íÄ¥°Í)
: write_sttiv_sales_total(¼¼±Ý°è»ê¼­ÇÕ°èÇ¥ ¸ÅÃâÇÕ°è ¼ö»ó. ¾Æ·¡³»¿ªÀÌ ¾Æ´ÏÀÚ³ª
SELECT COUNT(DISTINCT NVL(c.bsn_no, c.pid)) AS cnt ,COUNT(*) AS num,sum(amt),sum(vat)
INTO ln_cnt,ln_num,ln_amt,ln_tax
FROM lfsgt610 a
, lfsgt100 b
, lfsgt100 c
WHERE a.cust_cd = b.cust_cd
AND nvl(b.credit_cust, b.cust_cd) = c.cust_cd
AND a.coop = :coop
AND a.issue_dt BETWEEN :yyyymmdd_f AND :yyyymmdd_t
AND a.amt != 0
;