DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID='TRRDI0000100088' AND PROCESS_ID='DMMS'

SELECT * FROM dbo.PL_REQUEST_PROCESS_CHILD WHERE REQ_ID='TRRDI0000100088'

UPDATE dbo.TR_REQUEST_DOC SET PROCESS_ID='DMMS' WHERE REQ_ID='TRRDI0000100088'
DELETE FROM dbo.PL_REQUEST_PROCESS_CHILD WHERE ID='1720'
DELETE FROM dbo.PL_REQUEST_PROCESS_CHILD WHERE ID='1721'

UPDATE dbo.PL_REQUEST_PROCESS_CHILD SET PROCESS_ID=(SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE PL_REQUEST_PROCESS_CHILD.REQ_ID=PL_REQUEST_PROCESS.REQ_ID AND PROCESS_ID='DMMS')
WHERE PL_REQUEST_PROCESS_CHILD.REQ_ID ='TRRDI0000100088'

DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID='1179'
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID='1180'
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID='1181'
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID='1182'
UPDATE dbo.PL_REQUEST_PROCESS_CHILD SET PROCESS_ID='386' WHERE REQ_ID='TRRDI0000100088'

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE='003/2020/TTr-0690803'

SELECT * FROM dbo.TR_REQUEST_DOC WHERE REQ_ID='TRRD00000251012'
SELECT * FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID='TRRD00000251012'
SELECT * FROM dbo.PL_REQUEST_PROCESS_CHILD WHERE REQ_ID='TRRD00000251012'

EXEC dbo.PL_REQ_PROCESS_CHILD_App @p_REQ_ID = 'PLRD00000200055', -- varchar(20)
@p_PROCESS_ID = 'TC', -- varchar(20)
@p_TLNAME = 'hoattm', -- varchar(20)
@p_MAKER_ID = 'hoattm', -- varchar(20)
@p_TYPE_JOB = 'TP', -- varchar(20)
@p_PROCESS_DES = N'Phê duyệt', -- nvarchar(20)
@p_REF_ID = 935 -- int

UPDATE dbo.TR_REQUEST_DOC_DT SET SUP_ID='CMS000000251234',HANGHOA_ID='HH0000000112222' WHERE REQ_DOC_ID IN ('TRRDII001055328','TRRDII001055329')

EXEC dbo.sp_generate_inserts @table_name = 'CM_SUPPLIER', -- varchar(776)

@from = 'FROM CM_SUPPLIER'

UPDATE dbo.TR_REQUEST_DOC_DT SET SUP_ID='CMS000000251234',HANGHOA_ID='HH0000000112222' WHERE REQ_DOC_ID IN ('TRRDII001055328','TRRDII001055329')

UPDATE dbo.TR_REQUEST_DOC_DT SET TRAN_TYPE_ID='TRN0000000001' WHERE REQ_DOC_ID IN ('TRRDII001055328','TRRDII001055329')

SELECT * FROM dbo.PL_TRADEDETAIL WHERE GOODS_ID='GOO000001064137'
SELECT * FROM dbo.PL_MASTER WHERE PLAN_ID='PLM000000016947'

SELECT * FROM dbo.PL_TRADEDETAIL WHERE GOODS_ID='GOO000001064015'
SELECT * FROM dbo.PL_MASTER WHERE PLAN_ID='PLM000000017042'

EXEC dbo.PL_REQ_DOC_Ins_To_TR_REQ_DOC @p_PL_REQ_ID = '' -- varchar(15)

exec PL_REQ_DOC_Ins_To_TR_REQ_DOC 'PLRD00000200077'

PLT000001072180 PLM000001057694 GOO000001061959 - ANGIANG

PLT000001072183 PLM000001057695 GOO000001061967

EXEC dbo.PL_PROCESS_SEARCH @p_REQ_ID = '', -- varchar(20)
@p_USER_LOGIN = '', -- varchar(20)
@p_TYPE = '' -- varchar(20)

UPDATE dbo.PL_TRADEDETAIL SET AMT_TF=104000000 WHERE TRADE_ID='PLT000000071255'
UPDATE dbo.PL_TRADEDETAIL SET AMT_RECEIVE_TF=104000000 WHERE TRADE_ID='PLT000000071335'

EXEC dbo.PL_REQ_DOC_Ins_To_TR_REQ_DOC @p_PL_REQ_ID = '' -- varchar(15)