diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-10-21 09:05:52 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-10-21 09:05:52 +0000 |
| commit | cf77558c0ccc5c0c1bc3cdd6edd9a0475e1970c8 (patch) | |
| tree | 32eded30db38fe321c288d55c7f3ee136a0b4723 /components/common/selectors/procurement-manager/README.md | |
| parent | 261c45877f58af5779ef796c0c9186ed021e028e (diff) | |
(대표님) 설계측 오류 및 스타일 등 수정
Diffstat (limited to 'components/common/selectors/procurement-manager/README.md')
| -rw-r--r-- | components/common/selectors/procurement-manager/README.md | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/components/common/selectors/procurement-manager/README.md b/components/common/selectors/procurement-manager/README.md new file mode 100644 index 00000000..5f8e4021 --- /dev/null +++ b/components/common/selectors/procurement-manager/README.md @@ -0,0 +1,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' +```
\ No newline at end of file |