blob: 5f8e40211479f11e8d32eacfd0f84513b2238974 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
# 조달담당자 선택기
```sql
-- oracle code
SELECT NM.CD -- "조달코드",
NM.CDNM -- "담당자명",
NM.GRP_DSC -- "부서명",
USR_DF_CHAR_1 -- "사번",
USR_DF_CHAR_2 -- "부서코드",
USR_DF_CHK_1 -- "사용"
FROM CMCTB_CD CD,
CMCTB_CDNM NM
WHERE CD.CD_CLF = NM.CD_CLF
AND CD.CD = NM.CD
AND CD.CD2 = NM.CD2
AND CD.CD3 = NM.CD3
AND CD.CD_CLF = 'MMK010'
```
|
