diff options
Diffstat (limited to 'components/common/selectors/procurement-manager')
| -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 |