Activity

From 03/06/2025 to 04/04/2025

04:44 PM Bug #1593: UAT 04042025: DECLARE @REQ_ID VARCHAR(15)
SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2024/002916'
INSERT d... Luc Tran Van
03:29 PM Bug #1593: UAT 04042025: WITH RankedTrades AS (
SELECT
B.YEAR,
B.DEPT_ID,
B.BRANCH_ID,
DP.DEP_COD... Luc Tran Van
03:15 PM Bug #1593: UAT 04042025: UPDATE dbo.PL_TRADEDETAIL
SET PLAN_ID = 'X' + LEFT(PLAN_ID, LEN(PLAN_ID) - 14)
WHERE LEN(PLAN_ID) > 14 AND PLAN_ID ... Luc Tran Van
02:29 PM Bug #1593: UAT 04042025: DECLARE @REQ_ID VARCHAR(50)
SELECT TOP 1 @REQ_ID = IMP_LOG_CODE FROM dbo.PL_IMPORT_LOG ORDER BY IMP_LOG_ID DESC
SEL... Luc Tran Van
08:55 AM Bug #1593: UAT 04042025: WITH RankedTrades AS (
SELECT
B.YEAR,
B.DEPT_ID,
B.BRANCH_ID,
DP.DEP_COD... Luc Tran Van
08:55 AM Bug #1593 (New): UAT 04042025: Luc Tran Van
08:50 AM Bug #1590: UAT.25.03.2025: SELECT B.YEAR, A.*
FROM dbo.PL_TRADEDETAIL A
INNER JOIN dbo.PL_MASTER B ON B.PLAN_ID = A.PLAN_ID
WHERE TRADE_ID I... Luc Tran Van

01:59 PM Bug #1590: UAT.25.03.2025: SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
GO
ALTER PROCEDURE [dbo].[rpt_PL_REQUEST_FUND_Template]
@p_TR_REQU... Luc Tran Van
11:15 AM Bug #1590: UAT.25.03.2025: WITH NumberedLogs AS (
SELECT
t.TEMPLATE_REQUEST_ID,
t.GROUP_APPROVE,
ROW_NUMBER() O... Luc Tran Van
09:49 AM Feature #1591: SUPPORT EOFFICE 26.03.2025: UPDATE TR_REQ_ADVANCE_PAYMENT SET CREATE_DT_KT ='2025-03-25 8:15:00',APPROVE_DT_KT ='2025-03-25 8:30:00'
WHERE REQ_P... Luc Tran Van
09:47 AM Feature #1591 (New): SUPPORT EOFFICE 26.03.2025: Luc Tran Van

04:34 PM Bug #1590: UAT.25.03.2025: ;WITH LatestSteps AS (
SELECT
REQ_ID,
MAX(STEP_LEVEL) AS MaxStepLevel,
STUFF((
... Luc Tran Van
03:06 PM Bug #1590: UAT.25.03.2025: USE [gAMSPro_BVB_v3_FINAL1]
GO
/****** Object: StoredProcedure [dbo].[CM_REQUEST_TEMPLATE_Search] Script Date: ... Luc Tran Van
01:30 PM Bug #1590: UAT.25.03.2025: DECLARE @REQ_ID NVARCHAR(50)
DECLARE @DistinctSteps INT
DECLARE @TotalRows INT
DECLARE @StepSequence NVARCHAR(MAX)... Luc Tran Van
11:54 AM Bug #1590: UAT.25.03.2025: WITH LatestRecords AS (
SELECT *
FROM [dbo].[CM_APPROVE_GROUP] a
WHERE CREATE_DT = (
SELECT M... Luc Tran Van
11:43 AM Bug #1590: UAT.25.03.2025: -- Bước 1: Lấy các bản ghi có CREATE_DT mới nhất cho mỗi REQ_ID
WITH LatestRecords AS (
SELECT *
FROM [dbo... Luc Tran Van
11:33 AM Bug #1590: UAT.25.03.2025: -- Bước 1: Lấy các bản ghi có CREATE_DT mới nhất cho mỗi REQ_ID
WITH LatestRecords AS (
SELECT *
FROM [dbo... Luc Tran Van
11:31 AM Bug #1590 (New): UAT.25.03.2025: Luc Tran Van
11:00 AM Bug #1586: Support App Mobile: -- Bước 1: Lấy các bản ghi có CREATE_DT mới nhất cho mỗi REQ_ID
WITH LatestRecords AS (
SELECT *
FROM [dbo... Luc Tran Van
10:47 AM Bug #1586: Support App Mobile: WITH StepCheck AS (
SELECT
REQ_ID,
COUNT(*) AS StepCount,
MIN(STEP_LEVEL) AS MinStep... Luc Tran Van

04:37 PM Bug #1586: Support App Mobile: https://testflight.apple.com/join/qEIw6wvh Luc Tran Van

03:50 PM Bug #1586: Support App Mobile: DECLARE
@p_REQ_PAY_ID varchar(15)= NULL,
@p_REQ_PAY_CODE varchar(50) = NULL,
@p_REQ_DT VARCHAR(20)= NULL,
@p_BRAN... Luc Tran Van

04:43 PM Bug #1586: Support App Mobile: SELECT * FROM TR_REQ_PAY_AUTO_RECURRING_HISTORY WHERE billRef = 'P25063895850'
DECLARE @REQ_PAY_AUTO_ID VARCHAR(20) ... Luc Tran Van
03:31 PM Bug #1586: Support App Mobile: SELECT A.SUP_NAME, A.TAX_NO,A.CONTACT_PERSON, A.TEL, A.EMAIL, SUM(B.TOTAL_AMT) AS DOANH_SO_2024
FROM CM_SUPPLIER A
... Luc Tran Van

04:02 PM Bug #1586: Support App Mobile: https://ams-apigateway-mobile.bvbank.net.vn/API_MOBILE/api/PlanRequestDoc/PL_REQ_PROCESS_CHILD_Ins
Luc Tran Van

03:01 PM Bug #1586: Support App Mobile: https://ams-apigateway-mobile.bvbank.net.vn/API_MOBILE/api/services/app/UserConfiguration/GetAll?id=5132453255 Luc Tran Van

Also available in: Atom

EOFFICE - GD4