SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

ALTER PROC [dbo].[rpt_ASS_TRANSFER_MULTI_CONFIRM_Excel]
@TRANS_MULTI_MASTER_ID VARCHAR(15) = null,
@BRANCH_ID VARCHAR(15) = null,
@FROMDATE VARCHAR(15) = null,
@TODATE VARCHAR(15) = null,
@IS_CONFIRM VARCHAR(1) = null
as
BEGIN
	SELECT 
		B.ASSET_CODE, B.ASSET_NAME, B.AMORT_MONTH, B.AMORTIZED_MONTH, B.AMORT_AMT, B.AMORTIZED_AMT, AMORT_AMT - B.AMORTIZED_AMT AS GT_CL, B.NOTES,
		A.TRANS_MULTI_MASTER_ID,CB.BRANCH_CODE,CB.BRANCH_NAME,1 AS SL,B.BUY_PRICE,'' AS UNIT,B.ASSET_SERIAL_NO AS SERIAL_NUMBER,
		dbo.FN_GET_BRANCH_LEADER(C.BRANCH_ID, c.DEPT_ID) AS TLNANME
	FROM ASS_TRANSFER_MULTI_MASTER A
		INNER JOIN ASS_TRANSFER_MULTI_DT C ON C.TRANS_MULTI_MASTER_ID = A.TRANS_MULTI_MASTER_ID
		INNER JOIN ASS_MASTER B ON B.ASSET_ID = C.ASSET_ID
		LEFT JOIN CM_BRANCH CB ON CB.BRANCH_ID = C.BRANCH_ID
		WHERE (A.TRANS_MULTI_MASTER_ID = @TRANS_MULTI_MASTER_ID OR @TRANS_MULTI_MASTER_ID IS NULL OR @TRANS_MULTI_MASTER_ID = '')
		AND A.AUTH_STATUS = 'A' 
		AND (C.BRANCH_ID = @BRANCH_ID OR @BRANCH_ID IS NULL OR @BRANCH_ID = '')
		AND ((@IS_CONFIRM = 'Y' AND A.TRANS_MULTI_MASTER_ID IN (SELECT TRANS_MULTI_MASTER_ID FROM dbo.ASS_TRANSFER_CONFIRM_MASTER WHERE CONFIRM_STATUS_BN = 'Y')) 
		OR (@IS_CONFIRM = 'N' AND A.TRANS_MULTI_MASTER_ID NOT IN (SELECT TRANS_MULTI_MASTER_ID FROM dbo.ASS_TRANSFER_CONFIRM_MASTER)
		OR (@IS_CONFIRM= '' OR @IS_CONFIRM IS NULL)))
		AND	(CONVERT(DATE,A.APPROVE_DT) >= CONVERT(DATE, @FROMDATE, 103) OR @FROMDATE is NULL OR @FROMDATE = '')
		AND	(CONVERT(DATE,A.APPROVE_DT) <= CONVERT(DATE, @TODATE, 103) OR @TODATE is NULL OR @TODATE = '')
END