# 조달담당자 선택기

```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'
```