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

ALTER PROCEDURE [dbo].[ASS_GROUP_ByCondition]

	@p_TYPE_ID varchar(15) = NULL,

	@p_ASS_CAT varchar(15) = NULL

AS

BEGIN

	--khangth,27/03/2020 searching ass group by type and category

	SELECT * 

	FROM ASS_GROUP A

	WHERE ([TYPE_ID] = @p_TYPE_ID OR @p_TYPE_ID IS NULL OR @p_TYPE_ID = '')

	--AND (ASS_CAT = @p_ASS_CAT OR @p_ASS_CAT IS NULL OR @p_ASS_CAT = '')

	AND RECORD_STATUS = '1'

	AND AUTH_STATUS = 'A'

		--and IS_LEAF='Y'

		--AND ISNULL(A.ASSET_ACCTNO,'') <> '' 

		--AND ISNULL(A.AMORT_ACCTNO,'') <> ''

		--AND ISNULL(A.EXP_ACCTNO,'') <> ''

		--AND ISNULL(A.INC_ACCTNO,'') <> ''

		--AND ISNULL(A.LIQ_ACCTNO,'') <> ''		

	ORDER BY GROUP_CODE 

End