72 lines
1.1 KiB
Markdown
72 lines
1.1 KiB
Markdown
|
삭제리스트
|
||
|
|
|
||
|
|
select a.sudat
|
||
|
|
, substr(a.iojpno,1,12) as iojpno
|
||
|
|
, a.cvcod
|
||
|
|
, fun_get_cvnas(a.cvcod) as cvnas
|
||
|
|
, a.napvnd
|
||
|
|
, fun_get_cvnas(a.napvnd) as cvnas
|
||
|
|
, count(*) as cnt
|
||
|
|
, substr(scs_jpno,1,12) as jpno
|
||
|
|
, io_empno as dbgbn
|
||
|
|
from imhist a
|
||
|
|
where a.io_date >= :arg_sdate
|
||
|
|
and a.io_date <= :arg_edate
|
||
|
|
and a.napvnd like :ar_cvcod
|
||
|
|
and a.pgm_id like 'W_PU_IPGO_WOUT_E%'
|
||
|
|
group by a.sudat,substr(a.iojpno,1,12), a.cvcod, a.napvnd, substr(scs_jpno,1,12)
|
||
|
|
|
||
|
|
|
||
|
|
imhist.napvnd 에 직납처 셋팅
|
||
|
|
imhist.io_emnpno 에 db구분 셋팅
|
||
|
|
|
||
|
|
napreq ipdat update
|
||
|
|
dw_detail 단가
|
||
|
|
bogo imhist loteno
|
||
|
|
검사일자, 합격수량
|
||
|
|
|
||
|
|
자동출고 확인 (O23), erp000000400
|
||
|
|
|
||
|
|
---
|
||
|
|
|
||
|
|
삼보 입고, 출고 napreq.jpno연결컬럼 확인
|
||
|
|
wout.imhist.pjt_cd
|
||
|
|
napreq.jpno = scm_barcode.tmp_jpno
|
||
|
|
|
||
|
|
입고 : IMHIST_PUR.JPNO
|
||
|
|
출고 : IMHIST_SAL.IP_JPNO
|
||
|
|
|
||
|
|
보고 입고 : imhist.scs_jpno
|
||
|
|
|
||
|
|
---
|
||
|
|
|
||
|
|
|
||
|
|
W02201262865
|
||
|
|
|
||
|
|
|
||
|
|
---
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
select *
|
||
|
|
from imhist_pur
|
||
|
|
where jpno like 'W02201262865%'
|
||
|
|
|
||
|
|
|
||
|
|
select *
|
||
|
|
from IMHIST_SAL
|
||
|
|
where IP_JPNO like 'W02201262865%'
|
||
|
|
|
||
|
|
|
||
|
|
select *
|
||
|
|
from scm_barcode
|
||
|
|
where tmp_jpno ='W02201262865'
|
||
|
|
|
||
|
|
|
||
|
|
select *
|
||
|
|
from napreq
|
||
|
|
where jpno like 'W02201262865%'
|
||
|
|
|
||
|
|
|
||
|
|
---
|