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

ALTER PROCEDURE [dbo].[rpt_InventoryPOReport]

@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 TM.PO_CODE DESC) AS STT,PL.REQ_CODE AS PL_REQ_CODE,TR.REQ_CODE,TM.PO_CODE,CS.SUP_NAME,TU.TLFullName AS MAKER_NAME,TM.TOTAL_AMT,CB.BRANCH_CODE,CB.BRANCH_NAME

	FROM dbo.TR_PO_MASTER TM

	LEFT JOIN dbo.TR_REQUEST_DOC TR ON TR.REQ_ID=Tm.REQ_DOC_ID

	LEFT JOIN dbo.PL_REQUEST_DOC PL ON PL.REQ_ID=TR.PL_REQ_ID

	LEFT JOIN dbo.CM_SUPPLIER CS ON CS.SUP_ID=TM.SUP_ID

	LEFT JOIN dbo.TL_USER TU ON TU.TLNANME=TM.MAKER_ID

	LEFT JOIN dbo.CM_BRANCH CB ON CB.BRANCH_ID=TM.BRANCH_ID

	--LEFT JOIN dbo.CM_DEPARTMENT CD ON CD.DEP_ID=TM. 

	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)

	--ORDER BY A.CREATE_DT DESC

END