Project

General

Profile

Bug #1483

Support Vận hành 03/04/2023

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

Status:
New
Priority:
Normal
Assignee:
-
Start date:
04/03/2023
Due date:
% Done:

0%

Estimated time:
innhan_03042023.txt (3.87 KB) innhan_03042023.txt Luc Tran Van, 04/03/2023 10:07 AM
Upd_User_04032023.txt (298 Bytes) Upd_User_04032023.txt Luc Tran Van, 04/03/2023 02:40 PM
rpt_ass_master.xlsx (13.5 KB) rpt_ass_master.xlsx Luc Tran Van, 04/03/2023 02:56 PM
MAU_LIET_KE_CHUNG_TU_VietBank.xlsx (220 KB) MAU_LIET_KE_CHUNG_TU_VietBank.xlsx Luc Tran Van, 04/03/2023 02:58 PM
branch_search.txt (6.8 KB) branch_search.txt Luc Tran Van, 04/04/2023 09:34 AM
ASS_MASTER_Search.txt (48.5 KB) ASS_MASTER_Search.txt Luc Tran Van, 04/04/2023 09:38 AM
UPDATE ASSGROUP.txt (1.71 KB) UPDATE ASSGROUP.txt Luc Tran Van, 04/04/2023 10:03 AM
gen_dvcm_ktht.txt (6.79 KB) gen_dvcm_ktht.txt Luc Tran Van, 04/04/2023 10:21 AM
Upd_Search_PYC_DoiMau.txt (36.2 KB) Upd_Search_PYC_DoiMau.txt Luc Tran Van, 04/04/2023 01:13 PM
Upd_Search_PYC_DoiMau.txt (65.8 KB) Upd_Search_PYC_DoiMau.txt Luc Tran Van, 04/04/2023 01:18 PM
import_user_tramttb.txt (2.29 KB) import_user_tramttb.txt Luc Tran Van, 04/04/2023 02:22 PM
DC.txt (12.4 KB) DC.txt Luc Tran Van, 04/04/2023 02:33 PM
Gen_6_User_05F03_05I01.txt (7.92 KB) Gen_6_User_05F03_05I01.txt Luc Tran Van, 04/04/2023 03:14 PM
ALTER_TABLE&&DONGBO_NHANVIEN.txt (12.4 KB) ALTER_TABLE&&DONGBO_NHANVIEN.txt Luc Tran Van, 04/04/2023 03:45 PM
DATA_BRANCH_DEP_MAP.txt (6.65 KB) DATA_BRANCH_DEP_MAP.txt Luc Tran Van, 04/04/2023 03:48 PM
ALTER_TABLE_FIX_DONGBO_1.txt (12.4 KB) ALTER_TABLE_FIX_DONGBO_1.txt Luc Tran Van, 04/04/2023 03:54 PM
XSDBBBG.txt (4.69 KB) XSDBBBG.txt Luc Tran Van, 04/04/2023 05:18 PM
ASS_BBBG_ASS_USE_MULTI.docx (61 KB) ASS_BBBG_ASS_USE_MULTI.docx Luc Tran Van, 04/04/2023 05:20 PM
ASS_BBBG_ASS_USE_MULTI.docx (61 KB) ASS_BBBG_ASS_USE_MULTI.docx Luc Tran Van, 04/04/2023 05:29 PM
update_guimail.txt (104 KB) update_guimail.txt Luc Tran Van, 04/04/2023 05:48 PM
gen_user_textapp.txt (2.19 KB) gen_user_textapp.txt Luc Tran Van, 04/04/2023 05:53 PM
rpt_INVENTORY_Search.txt (13.9 KB) rpt_INVENTORY_Search.txt Luc Tran Van, 04/04/2023 06:33 PM
INVENTORY_BYID.xlsx (13.2 KB) INVENTORY_BYID.xlsx Luc Tran Van, 04/04/2023 06:33 PM

History

#2 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID =(
SELECT trjf.REQ_ID FROM TR_REQUEST_JOB_FORM trjf WHERE trjf.REQ_CODE='AFT-23-000189')

#13 Updated by Luc Tran Van over 2 years ago

#18 Updated by Luc Tran Van over 2 years ago

EXEC ASS_MASTER_REMOVE @l_ASSET_CODE = '999019'
GO
UPDATE ASS_MASTER SET AMORT_STATUS='DKH' WHERE ISNULL <> 1 AND AMORT_STATUS='KHX' AND AMORT_AMT-AMORTIZED_AMT >0

Also available in: Atom PDF