From cf77558c0ccc5c0c1bc3cdd6edd9a0475e1970c8 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Tue, 21 Oct 2025 09:05:52 +0000
Subject: (대표님) 설계측 오류 및 스타일 등 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 .../common/selectors/procurement-manager/README.md     | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 components/common/selectors/procurement-manager/README.md

(limited to 'components/common')

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
-- 
cgit v1.2.3