Project

General

Profile

Support #764

Hỗ trợ đưa DMMS từ HO về Đơn Vị (YC nghiệp vụ)

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/25/2020
Due date:
% Done:

0%

Estimated time:

Description

Dear Lực,
Nhờ Lực hỗ trợ giúp Chi nhánh Tiền Giang chuyển phiếu yêu cầu mua sắm số PUR/2020/000920 chuyển về lại Chi nhánh tự duyệt, cám ơn.
Trân trọng.
Châu Nhật Hùng (Ông)
Nhân Viên Hành Chính
Phòng Hành Chính

NGÂN HÀNG BẢN VIỆT
A: 412 Nguyễn Thị Minh Khai, Phường 5, Quận 3, Tp.Hồ Chí Minh, Việt Nam
T: (+84 028) 62679679 | ext: 190 | F: (+84 028) 62638668
M: (+84) 902882496 | E:

W: www.vietcapitalbank.com.vn | Hotline: 1900 555 596

History

#1 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR, @BRANCH_CREATE VARCHAR
SET @REQ_ID =(SELECT TOP 1 REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0001/2020/TTr-0260005')
UPDATE PL_REQUEST_DOC SET APPROVE_DT ='2020-09-15', EFFEC_DT = '2020-09-15' WHERE REQ_ID =@REQ_ID
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='2020-09-15' WHERE REQ_ID =@REQ_ID

SET @REQ_ID =(SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000365')
UPDATE TR_REQUEST_DOC_DT SET REQ_DT ='2020-09-30' WHERE REQ_DOC_ID =@REQ_ID

SET @REQ_ID =(SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000903')
UPDATE TR_REQUEST_DOC_DT SET REQ_DT ='2020-10-01' WHERE REQ_DOC_ID =@REQ_ID

SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000920')
SET @BRANCH_CREATE =(SELECT TOP 1 BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000920')
UPDATE TR_REQUEST_DOC SET DMMS_ID =(SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE BRANCH_ID =@BRANCH_CREATE), BRANCH_DVMS = @BRANCH_CREATE WHERE REQ_CODE ='PUR/2020/000920' AND REQ_ID =@REQ_ID

SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000828')
UPDATE PL_REQUEST_PROCESS_CHILD SET TLNAME ='vanpt2' WHERE REQ_ID =@REQ_ID AND TYPE_JOB ='KS' AND STATUS_JOB='C' AND TLNAME ='tungnt3'

SET @REQ_ID =(SELECT TOP 1 REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0117/2020/TTr-0690604')
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)
@p_AUTH_STATUS = 'A', -- varchar(1)
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
@p_APPROVE_DT = '2020-12-25 11:30:56 PM', -- datetime
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

#2 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF