Project

General

Profile

Support #1379

Support AMS

Added by Luc Tran Van almost 3 years ago.

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
08/09/2022
Due date:
% Done:

0%

Estimated time:

Description

UPDATE PL_REQUEST_DOC_DT SET SUP_ID ='CMS000000252861' WHERE REQDT_ID ='PLRDD0000245430'
UPDATE TR_REQUEST_DOC_DT SET SUP_ID ='CMS000000252861' WHERE PL_REQDT_ID ='PLRDD0000245430'
UPDATE TR_PO_MASTER SET SUP_ID ='CMS000000252861' WHERE REQ_DOC_ID =(SELECT REQ_DOC_ID FROM TR_REQUEST_DOC_DT WHERE PL_REQDT_ID ='PLRDD0000245430')

SELECT REQ_CODE, REQ_NAME, REQ_CONTENT, REQ_REASON, TOTAL_AMT, MAKER_ID FROM PL_REQUEST_DOC WHERE MAKER_ID IN ('datnqq','nhulnq1', 'tannh1','dungltm', 'khangpth', 'quoclnb', 'lancvt1', 'huongnpl')
UPDATE PL_REQUEST_DOC SET SIGN_USER ='xuanpt' WHERE WHERE MAKER_ID IN ('datnqq','nhulnq1', 'tannh1','dungltm', 'khangpth', 'quoclnb', 'lancvt1', 'huongnpl') AND (SIGN_USER ='' OR SIGN_USER IS NULL)

---202289

Also available in: Atom PDF