Bug #1601
GOLIVE 24062025
Status:
New
Priority:
Normal
Assignee:
-
Start date:
06/24/2025
Due date:
% Done:
0%
Estimated time:
History
#1 Updated by Luc Tran Van about 1 month ago
- File FIX_TIMKIEMTOTRINH.txt FIX_TIMKIEMTOTRINH.txt added
#3 Updated by Luc Tran Van about 1 month ago
wwwroot/Reports/TRADE
#4 Updated by Luc Tran Van about 1 month ago
#5 Updated by Luc Tran Van about 1 month ago
SELECT A.*,BR.BRANCH_NAME, BR.BRANCH_TYPE
FROM dbo.PL_REQUEST_PROCESS A
INNER JOIN dbo.PL_REQUEST_DOC B ON A.REQ_ID=B.REQ_ID
INNER JOIN dbo.CM_BRANCH BR ON BR.BRANCH_ID = A.BRANCH_ID AND BR.BRANCH_TYPE = 'PGD'
WHERE A.PROCESS_ID='APPNEW' AND A.STATUS='C' AND B.REQ_ID LIKE 'PLRD%' AND A.ROLE_USER='GDDV'