ALTER PROCEDURE dbo.CM_REQ_TYPE_Search 
	@p_REQ_TYPE_CODE	varchar(15)  = NULL,
	@p_REQ_TYPE_NAME	nvarchar(255)  = NULL,
	@p_REQ_TYPE_ID	varchar(15)  = NULL,
	@p_WARE_TYPE	nvarchar(25)  = NULL,
	@p_DEP_RECEIVE	varchar(15)  = NULL,
	@p_ROLE_RECEIVE	VARCHAR(25)  = NULL,
	@p_NOTES	nvarchar(1000)  = NULL,
	@p_RECORD_STATUS	varchar(1)  = NULL,
	@p_MAKER_ID	varchar(12)  = NULL,
	@p_CREATE_DT	VARCHAR(20) = NULL,
	@p_AUTH_STATUS	varchar(50)  = NULL,
	@p_CHECKER_ID	varchar(12)  = NULL,
	@p_APPROVE_DT	VARCHAR(20) = NULL,
	@p_TOP	INT = NULL

AS
BEGIN -- PAGING
-- PAGING BEGIN
	SELECT A.*, B.DEP_NAME AS DEP_RECEIVE_NAME , C.WARE_NAME AS WARE_TYPE_NAME, D.AUTH_STATUS_NAME
    		-- SELECT END
    FROM CM_REQ_TYPE A
    LEFT JOIN CM_DEPARTMENT B ON B.DEP_ID = A.DEP_RECEIVE
    LEFT JOIN CM_WARE C ON C.WARE_ID = A.WARE_TYPE
    LEFT JOIN CM_AUTH_STATUS D ON D.AUTH_STATUS = A.AUTH_STATUS
		WHERE 1=1
    AND (A.REQ_TYPE_ID LIKE '%' + @p_REQ_TYPE_ID + '%' OR @p_REQ_TYPE_ID IS NULL OR @p_REQ_TYPE_ID = '')
    AND (A.REQ_TYPE_NAME LIKE '%' + @p_REQ_TYPE_NAME + '%' OR @p_REQ_TYPE_NAME IS NULL OR @p_REQ_TYPE_NAME = '')
    AND (A.WARE_TYPE LIKE '%' + @p_WARE_TYPE + '%' OR @p_WARE_TYPE IS NULL OR @p_WARE_TYPE = '')
    AND (A.DEP_RECEIVE LIKE '%' + @p_DEP_RECEIVE + '%' OR @p_DEP_RECEIVE IS NULL OR @p_DEP_RECEIVE = '')
    AND (A.ROLE_RECEIVE LIKE '%' + @p_ROLE_RECEIVE + '%' OR @p_ROLE_RECEIVE IS NULL OR @p_ROLE_RECEIVE = '')
    AND (A.NOTES LIKE '%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
    AND A.RECORD_STATUS = '1'
-- PAGING END
END -- PAGING