Project

General

Profile

Download (799 Bytes)

TRANS1.txt

Luc Tran Van, 11/18/2022 02:15 PM

 
1 
CREATE PROCEDURE [dbo].[PAY_TRANSFER_OUTSIDE_REC_ByRefId]
2 
@p_REF_ID VARCHAR(200) = NULL,
3 
@p_BRANCH_ID VARCHAR(50) = NULL,
4 
@p_RefNo VARCHAR(500) = NULL
5 
AS
6 

    		
  

  

    
      7
    
    
      
SELECT POR.REQ_TRANS_OUTSIDE_REC_ID,TOT.BRANCH_TRANFSER_NAME, TOT.ACC_NO_TRANSFER, REF_NO, 


    		
  

  

    
      8
    
    
      
	dbo.fChuyenCoDauThanhKhongDau((SELECT TOP 1 BRANCH_NAME FROM CM_BRANCH WHERE BRANCH_ID = TOT.brancH_ID)) AS 'BRANCH_NAME', 


    		
  

  

    
      9
    
    
      
	POR.BRANCH_RECEIVE_NAME, POR.ACC_NO_RECEIVE AS 'ACCT_NO', POR.BANK_RECEIVE_ID AS 'BANK_RECEIVE_NAME', 


    		
  

  

    
      10
    
    
      
	REPLACE (FORMAT (POR.TRADE_AMT,'#,###'),',','.') +',00 VND' AS TRADE_AMT,


    		
  

  

    
      11
    
    
      
	REPLACE(dbo.ReadMoney(POR.TRADE_AMT),'  ',' ') AS 'STRING_MONEY', POR.TRADE_DESC


    		
  

  

    
      12
    
    
      
FROM TR_REQ_PAY_TRANS_OUTSIDE_REC POR


    		
  

  

    
      13
    
    
      
LEFT JOIN TR_REQ_PAY_TRANS_OUTSIDE_TRANS TOT ON POR.REQ_PAY_ID = TOT.REQ_PAY_ID


    		
  

  

    
      14
    
    
      
WHERE POR.REQ_PAY_ID = @p_REF_ID