ALTER PROCEDURE [dbo].[rpt_InventoryTRReport]
@p_REQ_CODE	varchar(50)	= NULL,
@p_REQ_NAME	nvarchar(500)	= NULL,
@p_FromDate VARCHAR(20) = NULL,
@p_ToDate VARCHAR(20) = NULL,
@p_DEP_ID VARCHAR(20) = NULL,
@p_BRANCH_ID	varchar(20)	= NULL,
@p_BRANCH_LOGIN VARCHAR(20)= NULL,
@p_USER_LOGIN VARCHAR(15)= NULL
AS
BEGIN 
	SELECT 
	ROW_NUMBER() OVER (ORDER BY TR.REQ_CODE DESC) AS STT,Pl.REQ_CODE AS PL_REQ_CODE,TR.REQ_CODE,TR.REQ_REASON,TR.REQ_CONTENT,TR.TOTAL_AMT,CB.BRANCH_ID,CB.BRANCH_CODE,CB.BRANCH_NAME,CD.DEP_CODE,CD.DEP_NAME,TU.TLNANME,
	dbo.PL_PROCESS_CURRENT_NGUOIXULY(TR.REQ_ID,NULL,'PYC-DVKD',0) AS NGUOI_XU_LY,RPN.NOTES AS PROCESS_DES
	FROM dbo.TR_REQUEST_DOC TR
	LEFT JOIN dbo.PL_REQUEST_DOC PL ON PL.REQ_ID=TR.PL_REQ_ID
	LEFT JOIN dbo.CM_BRANCH CB ON CB.BRANCH_ID=TR.BRANCH_CREATE
	LEFT JOIN dbo.CM_DEPARTMENT CD ON CD.DEP_ID=TR.DEP_CREATE
	LEFT JOIN dbo.TL_USER TU ON TU.TLNANME=TR.MAKER_ID
	LEFT JOIN 
		(
			SELECT REQ_ID,PROCESS_ID,PARENT_PROCESS_ID,STATUS,NOTES FROM
			dbo.PL_REQUEST_PROCESS
			GROUP BY REQ_ID,PROCESS_ID,PARENT_PROCESS_ID,STATUS,NOTES
		) RPN ON RPN.REQ_ID=TR.REQ_ID AND TR.PROCESS_ID=RPN.PROCESS_ID
	WHERE 1=1 
	AND (PL.REQ_CODE LIKE '%' +@p_REQ_CODE+'%' OR @p_REQ_CODE ='' OR @p_REQ_CODE IS NULL)
	AND (PL.REQ_NAME LIKE '%' +@p_REQ_NAME+'%' OR @p_REQ_NAME ='' OR @p_REQ_NAME IS NULL)
	AND (TR.DEP_CREATE = @p_DEP_ID OR @p_DEP_ID IS NULL OR @p_DEP_ID ='')
	AND (TR.BRANCH_CREATE = @p_BRANCH_ID OR @p_BRANCH_ID IS NULL OR @p_BRANCH_ID ='')
	AND (CONVERT(DATE, TR.CREATE_DT, 103) >= CONVERT(DATE, @p_FromDate, 103) OR @p_FromDate IS NULL OR @p_FromDate ='')
	AND (CONVERT(DATE, TR.CREATE_DT, 103) <= CONVERT(DATE, @p_ToDate, 103) OR @p_ToDate IS NULL OR @p_ToDate ='')
	
	--ORDER BY A.CREATE_DT DESC
END