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

SELECT AMORT_ID FROM dbo.ASS_AMORT WHERE AMORT_TERM ='11/2022'

ASM000000251054

UPDATE dbo.ASS_ENTRIES_POST SET MAKER_ID ='admin',CHECKER_ID='admin' WHERE TRN_ID='ASM000000251054'
UPDATE ASS_AMORT SET MAKER_ID='admin',CHECKER_ID='admin' WHERE AMORT_ID='ASM000000251054'

SELECT REF_NO, COUNT (*) AS SL FROM ASS_ENTRIES_POST WHERE TRN_ID ='ASM000000251054'
GROUP BY REF_NO

SELECT COUNT (*) AS SL FROM ASS_ENTRIES_POST WHERE TRN_ID ='ASM000000251054'

7651

SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC_DT WHERE TRADE_ID ='PLT000000287360')
SELECT * FROM PL_REQUEST_DOC_DT WHERE TRADE_ID ='PLT000000287360'

SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID IN (SELECT REQ_DOC_ID FROM PL_REQUEST_TRANSFER WHERE FR_TRADE_ID ='PLT000000287360')
SELECT * FROM PL_REQUEST_TRANSFER WHERE FR_TRADE_ID ='PLT000000287360'

UPDATE TR_REQUEST_DOC_DT SET
TOTAL_AMT = PRICE * QUANTITY
WHERE REQDT_ID

UPDATE TR_REQUEST_DOC SET
TOTAL_AMT = 202284860
WHERE REQ_ID =

select A.TLNAME, A.ROLE_OLD, A.ROLE_NEW, B.DEP_CODE, B.DEP_NAME, c.DVDM_ID, C.DVDM_NAME from TL_SYS_ROLE_MAPPING A
LEFT JOIN CM_DEPARTMENT B ON A.DEP_ID = B.DEP_ID
LEFT JOIN CM_DVDM C ON B.KHOI_ID = C.DVDM_ID
WHERE A.RECORD_STATUS = 1 AND A.ROLE_NEW = 'GDK'