DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

ALTER   proc [dbo].[CM_ATTACH_FILE_By_RefMaster] @p_REF_MASTER varchar(15)

AS

BEGIN

	select A. * from CM_ATTACH_FILE A where

	1=1

	AND (A.REF_MASTER = @p_REF_MASTER OR A.REF_ID = @p_REF_MASTER)

	AND ((A.[TYPE] IN ('TR_CONTRACT','TR_REQUEST_DOC_FILE') AND

			(A.REF_ID IN (SELECT TR_REQUEST_DOC_FILE_ID FROM TR_REQUEST_DOC_FILE WHERE REQ_ID =@p_REF_MASTER)

			OR A.REF_ID IN (SELECT PL_REQUEST_DOC_FILE_ID FROM PL_REQUEST_DOC_FILE WHERE REQ_ID =@p_REF_MASTER))

			AND (A.ATTACH_ID IN (SELECT ATTACH_ID FROM TR_REQUEST_DOC_FILE WHERE REQ_ID =@p_REF_MASTER)

			OR A.ATTACH_ID IN (SELECT ATTACH_ID FROM PL_REQUEST_DOC_FILE WHERE REQ_ID =@p_REF_MASTER)))

			--- NGƯỢC LẠI ĐỐI VỚI CÁC LOẠI KHÁC

			OR (A.[TYPE] NOT IN ('TR_CONTRACT','TR_REQUEST_DOC_FILE')))

END