62 lines
1.0 KiB
Markdown
62 lines
1.0 KiB
Markdown
|
삼보 관련사 업체 코드
|
||
|
|
|
||
|
|
보고 : 10467
|
||
|
|
대명-도장 : 12697
|
||
|
|
대명-조립 : 12812
|
||
|
|
|
||
|
|
TMP2020011552785
|
||
|
|
|
||
|
|
|
||
|
|
202201261001
|
||
|
|
|
||
|
|
---
|
||
|
|
|
||
|
|
|
||
|
|
TMP2020011552785
|
||
|
|
TMP2020051920930
|
||
|
|
TMP2020051920931
|
||
|
|
TMP2020060216557
|
||
|
|
TMP2020060216558
|
||
|
|
TMP2020082714371
|
||
|
|
TMP2020082714372
|
||
|
|
TMP2020082714373
|
||
|
|
TMP2020090918345
|
||
|
|
TMP2020090918346
|
||
|
|
TMP2020091115749
|
||
|
|
TMP2020091421407
|
||
|
|
TMP2021031126277
|
||
|
|
TMP2021122960071
|
||
|
|
TMP2021122960072
|
||
|
|
TMP2021122960073
|
||
|
|
TMP2021122960074
|
||
|
|
TMP2022010533833
|
||
|
|
TMP2022011438578
|
||
|
|
TMP2022011438579
|
||
|
|
TMP2022011812287
|
||
|
|
TMP2022011812288
|
||
|
|
TMP2022011812289
|
||
|
|
TMP2022011812290
|
||
|
|
TMP2022011812291
|
||
|
|
|
||
|
|
---
|
||
|
|
|
||
|
|
napreq ipdat update
|
||
|
|
dw_detail 단가
|
||
|
|
bogo imhist loteno
|
||
|
|
|
||
|
|
삭제 리스트 추가
|
||
|
|
select a.sudat
|
||
|
|
, substr(a.iojpno,1,12) as iojpno
|
||
|
|
, a.cvcod
|
||
|
|
, fun_get_cvnas(a.cvcod) as cvnas
|
||
|
|
, count(*) as cnt
|
||
|
|
, substr(scs_jpno,1,12) as jpno
|
||
|
|
from imhist a
|
||
|
|
where a.io_date >= :arg_sdate
|
||
|
|
and a.io_date <= :arg_edate
|
||
|
|
and a.cvcod like :ar_cvcod
|
||
|
|
and a.pgm_id like 'W_PU_IPGO_WOUT_E%'
|
||
|
|
group by a.sudat,substr(a.iojpno,1,12), a.cvcod, substr(scs_jpno,1,12)
|
||
|
|
|
||
|
|
---
|