Project

General

Profile

Support #471

Kiểm tra Tờ Trình số 0013/2020/0140007 (CN Nam BÌnh Dương) vì sao lên tới Phòng Hành Chính

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

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

0%

Estimated time:
TT ANH PHUONG HOI VI SAO LEN TOI PHONG HANH CHINH.jpg (1.93 MB) TT ANH PHUONG HOI VI SAO LEN TOI PHONG HANH CHINH.jpg Luc Tran Van, 10/15/2020 10:26 AM
TTCN BINH DUONG 0013 2020 TTR 0140007.xlsx (32 KB) TTCN BINH DUONG 0013 2020 TTR 0140007.xlsx Luc Tran Van, 10/16/2020 11:16 AM
TTCN BINH DUONG 0013 2020 TTR 0140007 - SAU KHI CAP NHAT.xlsx (27.4 KB) TTCN BINH DUONG 0013 2020 TTR 0140007 - SAU KHI CAP NHAT.xlsx Luc Tran Van, 10/16/2020 12:16 PM

History

#1 Updated by Luc Tran Van over 4 years ago

  • Subject changed from Kiểm tra Tờ Trình số 0007/2020/0140007 (CN Nam Sài Gòn) vì sao lên tới Phòng Hành Chính to Kiểm tra Tờ Trình số 0007/2020/0140007 (CN Nam BÌnh Dương) vì sao lên tới Phòng Hành Chính

#2 Updated by Luc Tran Van over 4 years ago

  • Subject changed from Kiểm tra Tờ Trình số 0007/2020/0140007 (CN Nam BÌnh Dương) vì sao lên tới Phòng Hành Chính to Kiểm tra Tờ Trình số 0013/2020/0140007 (CN Nam BÌnh Dương) vì sao lên tới Phòng Hành Chính

#3 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to In Progress

#5 Updated by Luc Tran Van over 4 years ago

  • Assignee set to Luc Tran Van

#6 Updated by Luc Tran Van over 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0013/2020/TTr-0140007'
select * from pl_request_doc_dt where req_id ='PLRD00000200310'
select * from pl_request_transfer where req_doc_id ='PLRD00000200310'
select * from pl_request_process where req_id ='PLRD00000200310'
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID ='PLT000000071538'
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID ='PLT000000071528'
--SELECT * FROM CM_GOODS WHERE GD_ID ='GOO000001062141'
--SELECT * FROM CM_GOODS WHERE GD_ID ='GOO000001062367'

--UPDATE PL_TRADEDETAIL SET AMT_RECEIVE_TF = ISNULL + 2585000.00, AMT_TF =0 WHERE TRADE_ID ='PLT000000071538'
--UPDATE PL_TRADEDETAIL SET AMT_TF = ISNULL + 2585000.00 WHERE TRADE_ID ='PLT000000071528'
--DELETE FROM pl_request_process WHERE ID ='3727'
--DELETE FROM pl_request_process WHERE ID =3728
--DELETE FROM pl_request_process WHERE ID =3729
--UPDATE pl_request_process SET STATUS ='C' WHERE ID =3730
--UPDATE PL_REQUEST_DOC SET AUTH_STATUS ='A', PROCESS_ID ='APPROVE' WHERE REQ_CODE ='0013/2020/TTr-0140007'
--EXEC PL_REQ_DOC_INS_TO_TR_REQ_DOC 'PLRD00000200310'

SELECT * FROM TR_REQUEST_DOC WHERE PL_REQ_ID ='PLRD00000200310'
SELECT * FROM TR_PO_MASTER WHERE REQ_DOC_ID ='TRRD00000251261'

#8 Updated by Luc Tran Van over 4 years ago

  • Status changed from In Progress to Closed

Also available in: Atom PDF