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

	DECLARE	

	@RECORD_STATUS VARCHAR(1) ,

	@REQPL_DT_ID VARCHAR(15)  ,

	@REQ_DOC_ID VARCHAR(15) ,

	@PL_REQDT_ID VARCHAR(15) ,

	@GD_ID VARCHAR(15) ,

	@SUP_ID VARCHAR(15) ,

	@HH_ID VARCHAR(15) ,

	@TRAN_TYPE_ID VARCHAR(15) ,

	@MAKER_ID VARCHAR(15) ,

	@CREATE_DT DATETIME ,

	@AUTH_STATUS VARCHAR(50) ,

	@CHECKER_ID VARCHAR(15) ,

	@APPROVE_DT DATETIME ,

	@DES_GOOD NVARCHAR(500) ,

	@QUANTITY_PL DECIMAL(18, 0) ,

	@PRICE_PL DECIMAL(18, 2) ,

	@CURRENCY NVARCHAR(50) ,

	@EXCHANGE_RATE DECIMAL(18, 2) ,

	@TAXES DECIMAL(18, 2) ,

	@TOTAL_AMT_ETM DECIMAL(18, 2) ,

	@REASON_CDT NVARCHAR(500) ,

	@REQ_DT DATETIME ,

	@NOTES NVARCHAR(500),

	@REQDT_ID VARCHAR(15)

	DECLARE lstDATA CURSOR FOR

	SELECT TR.REQPL_DT_ID,

           TR.REQ_DOC_ID,

           TR.PL_REQDT_ID,

           TR.GD_ID,

           TR.SUP_ID,

           TR.HANGHOA_ID,

           PL.TRADE_TYPE,

           TR.MAKER_ID,

           TR.CREATE_DT,

           TR.AUTH_STATUS,

           TR.CHECKER_ID,

           TR.APPROVE_DT,

           TR.DESCRIPTION,

           TR.QUANTITY,

           TR.PRICE_ETM,

           TR.CURRENCY,

           TR.EXCHANGE_RATE,

           TR.TAXES,

           TR.TOTAL_AMT_ETM,

           PL.NAME ,

           TR.REQ_DT,

           TR.NOTES,

           TR.RECORD_STATUS,TR.REQDT_ID FROM dbo.TR_REQUEST_DOC_DT TR

		   LEFT JOIN dbo.PL_REQUEST_DOC_DT PL ON PL.REQDT_ID=TR.PL_REQDT_ID

	OPEN lstDATA

	FETCH NEXT FROM lstDATA INTO @REQPL_DT_ID,@REQ_DOC_ID,@PL_REQDT_ID,@GD_ID,@SUP_ID,@HH_ID,@TRAN_TYPE_ID,@MAKER_ID,@CREATE_DT,@AUTH_STATUS,@CHECKER_ID,@APPROVE_DT,

								@DES_GOOD,@QUANTITY_PL,@PRICE_PL,@CURRENCY,@EXCHANGE_RATE,@TAXES,@TOTAL_AMT_ETM,@REASON_CDT,@REQ_DT,@NOTES,@RECORD_STATUS,@REQDT_ID

	WHILE @@FETCH_STATUS=0

	BEGIN

		EXEC dbo.SYS_CodeMasters_Gen @p_Kind = 'TR_REQUEST_DOC_PL_DT',                -- varchar(100)

		                             @p_KeyGen = @REQPL_DT_ID OUTPUT -- varchar(15)

		INSERT INTO dbo.TR_REQUEST_DOC_PL_DT

		(

		    REQPL_DT_ID,

		    REQ_DOC_ID,

		    PL_REQDT_ID,

		    GD_ID,

		    SUP_ID,

		    HH_ID,

		    TRAN_TYPE_ID,

		    MAKER_ID,

		    CREATE_DT,

		    AUTH_STATUS,

		    CHECKER_ID,

		    APPROVE_DT,

		    DES_GOOD,

		    QUANTITY_PL,

		    PRICE_PL,

		    CURRENCY,

		    EXCHANGE_RATE,

		    TAXES,

		    TOTAL_AMT_ETM,

		    REASON_CDT,

		    REQ_DT,

		    NOTES,

		    RECORD_STATUS

		)

		VALUES

		(   @REQPL_DT_ID,        -- REQPL_DT_ID - varchar(15)

		    @REQ_DOC_ID,        -- REQ_DOC_ID - varchar(15)

		    @PL_REQDT_ID,        -- PL_REQDT_ID - varchar(15)

		    @GD_ID,        -- GD_ID - varchar(15)

		    @SUP_ID,        -- SUP_ID - varchar(15)

		    @HH_ID,        -- HH_ID - varchar(15)

		    @TRAN_TYPE_ID,        -- TRAN_TYPE_ID - varchar(15)

		    @MAKER_ID,        -- MAKER_ID - varchar(15)

		    @CREATE_DT, -- CREATE_DT - datetime

		    @AUTH_STATUS,        -- AUTH_STATUS - varchar(50)

		    @CHECKER_ID,        -- CHECKER_ID - varchar(15)

		    @APPROVE_DT, -- APPROVE_DT - datetime

		    @DES_GOOD,       -- DES_GOOD - nvarchar(500)

		    @QUANTITY_PL,      -- QUANTITY_PL - decimal(18, 0)

		    @PRICE_PL,      -- PRICE_PL - decimal(18, 2)

		   @CURRENCY,       -- CURRENCY - nvarchar(50)

		    @EXCHANGE_RATE,      -- EXCHANGE_RATE - decimal(18, 2)

		    @TAXES,      -- TAXES - decimal(18, 2)

		    @TOTAL_AMT_ETM,      -- TOTAL_AMT_ETM - decimal(18, 2)

		    @REASON_CDT,       -- REASON_CDT - nvarchar(500)

		    @REQ_DT, -- REQ_DT - datetime

		    @NOTES,       -- NOTES - nvarchar(500)

		    @RECORD_STATUS         -- RECORD_STATUS - varchar(1)

		    )

		UPDATE dbo.TR_REQUEST_DOC_DT SET REQPL_DT_ID=@REQPL_DT_ID WHERE REQDT_ID=@REQDT_ID

		FETCH NEXT FROM lstDATA INTO @REQPL_DT_ID,@REQ_DOC_ID,@PL_REQDT_ID,@GD_ID,@SUP_ID,@HH_ID,@TRAN_TYPE_ID,@MAKER_ID,@CREATE_DT,@AUTH_STATUS,@CHECKER_ID,@APPROVE_DT,

								@DES_GOOD,@QUANTITY_PL,@PRICE_PL,@CURRENCY,@EXCHANGE_RATE,@TAXES,@TOTAL_AMT_ETM,@REASON_CDT,@REQ_DT,@NOTES,@RECORD_STATUS,@REQDT_ID

	END

	CLOSE lstDATA

	DEALLOCATE lstDATA