DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

UPDATE PL_REQUEST_PROCESS_CHILD SET TYPE_JOB = 'XL' WHERE REQ_ID = '' AND PROCESS_ID = AND TLNAME = ''

UPDATE PL_REQUEST_PROCESS_CHILD SET TYPE_JOB='XL' WHERE TLNAME ='dungptm2'

UPDATE PL_REQUEST_PROCESS SET STATUS='U', CHECKER_ID='', APPROVE_DT = NULL, NOTES =N'Chờ Giám đốc khối phê duyệt' WHERE ID ='76057'
UPDATE TR_REQUEST_DOC SET PROCESS_ID='', AUTH_STATUS='E' WHERE REQ_CODE ='PUR/2022/001996'

exec TR_ROLE_NOTIFI_ID @PO_ID = 'TADY00000203604', @TYPE = 'TR_REQ_ADVANCE_PAYMENT_APR'

SELECT A.OUT_DT_ID, A.TOTAL_AMT, A.TO_BRN_ID, A.TO_DEPT_ID, B.BRANCH_CREATE, B.CORE_NOTE,
B.KT_MAKER_ID, C.BRANCH_ID, C.DEPT_ID, D.PRICE_ID, E.GROUP_ID, E.MATERIAL_ID, A.IS_BCT /*E.IS_PROMO*/, E.VAT, E.PRICE_VAT,A.QTY,
A.TO_BRN_ID, A.MAST_BAL_ID,A.CUST_NAME,A.QTY,A.PRICE,A.NOTES, A.COST_ACC
FROM MW_OUT_DT A
INNER JOIN MW_OUT B ON A.OUT_ID = B.OUT_ID
INNER JOIN MW_MAST_BAL C ON A.MAST_BAL_ID = C.MAST_BAL_ID
INNER JOIN MW_MAST_PRICE D ON D.PRICE_ID = C.PRICE_ID
INNER JOIN MW_IN E ON D.MATERIAL_ID = E.IN_ID
WHERE A.OUT_ID = @p_OUT_ID

UPDATE MW_ENTRIES_POST SET AMT=14607650*0.1 WHERE ET_ID='MWET00000343406'

SELECT * FROM MW_ENTRIES_POST WHERE TRN_ID='MWOUT0000253629'

SELECT * FROM dbo.TL_SYS_ROLE_MAPPING WHERE TLNAME ='sontv1'

body:ORA-06512: at "FCUBSIT2.GLOBAL", line 162
ORA-06512: at "FCUBSIT2.VCCBPKS_ASSET_MANAGEMENT", line 515
- ORA-01403: no data found

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002173'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002173')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002173')
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002173')
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002173')
SELECT * FROM PL_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002173')

DECLARE @TABLE_ROLE TABLE (ROLE_AUTH VARCHAR)
DECLARE @ROLE_ID VARCHAR
SET @ROLE_ID = (SELECT ROLENAME FROM TL_USER WHERE TLNANME =@p_USER_LOGIN)
INSERT INTO @TABLE_ROLE SELECT @ROLE_ID
INSERT INTO @TABLE_ROLE SELECT ROLE_NEW FROM TL_SYS_ROLE_MAPPING WHERE ROLE_OLD =@ROLE_ID AND TLNAME =@p_USER_LOGIN AND
(CONVERT,103) >= CONVERT AND CONVERT,103) <=CONVERT OR (EFF_DATE IS NULL OR EXP_DATE IS NULL))