|
1
|
DECLARE @p_USER_LOGIN VARCHAR(250) = 'vanpt2',
|
|
2
|
@p_TYPE_ID VARCHAR(5) = NULL,
|
|
3
|
@p_GROUP_ID VARCHAR(15) = 'TSCD',
|
|
4
|
@p_BRANCH_ID VARCHAR(15) = NULL,
|
|
5
|
@p_FROM_DATE VARCHAR(100) = '2023-01-01 10:22:45.640',
|
|
6
|
@p_TO_DATE VARCHAR(100) = '2023-03-16 10:22:45.640',
|
|
7
|
@p_AMORT_DATE_CHECK VARCHAR(100) = NULL,
|
|
8
|
@p_USE_DATE_KT_CHECK VARCHAR(100) = NULL,
|
|
9
|
@p_FILTER VARCHAR(100) = NULL
|
|
10
|
|
|
11
|
DECLARE @BRANCH_LOGIN varchar(15) ='', @DEP_LOGIN varchar(15) =''
|
|
12
|
SELECT @DEP_LOGIN = SECUR_CODE, @BRANCH_LOGIN = TLSUBBRID FROM TL_USER WHERE TLNANME = @p_USER_LOGIN
|
|
13
|
|
|
14
|
IF(NOT EXISTS(SELECT * FROM CM_DEPARTMENT cd WHERE cd.BRANCH_ID = @BRANCH_LOGIN AND cd.DEP_ID = @DEP_LOGIN AND (cd.DEP_CODE = '0690604' OR cd.DEP_CODE = '0690802' OR cd.DEP_CODE = '0690803')))
|
|
15
|
BEGIN
|
|
16
|
IF(@BRANCH_LOGIN = 'DV0001') SET @p_BRANCH_ID = @DEP_LOGIN
|
|
17
|
ELSE SET @p_BRANCH_ID = @BRANCH_LOGIN
|
|
18
|
END
|
|
19
|
|
|
20
|
SELECT A.ASSET_ID FROM ASS_MASTER A
|
|
21
|
WHERE 1=1 AND A.RECORD_STATUS = '1' AND A.AUTH_STATUS = 'A' AND A.ENTRY_BOOKED = 'Y'
|
|
22
|
--AND (CONVERT(date,A.USE_DATE_KT,103) >= CONVERT(date,@p_FROM_DATE,103) OR @p_FROM_DATE IS NULL OR @p_FROM_DATE ='')
|
|
23
|
AND ((A.[TYPE_ID] = 'TSCD' AND CONVERT(date,A.LIQUIDATION_DT,103) >= CONVERT(date,@p_TO_DATE,103) OR A.LIQUIDATION_DT IS NULL OR A.LIQUIDATION_DT ='')
|
|
24
|
OR (A.[TYPE_ID] = 'CCLD' AND A.AMORT_STATUS <> 'VNM' AND CONVERT(date,A.LIQUIDATION_DT,103) > CONVERT(date,@p_TO_DATE,103) OR A.LIQUIDATION_DT IS NULL OR A.LIQUIDATION_DT =''))
|
|
25
|
AND (CONVERT(date,A.USE_DATE_KT,103) <= CONVERT(date,@p_TO_DATE,103) OR @p_TO_DATE IS NULL OR @p_TO_DATE ='' OR (A.TYPE_ID ='TSCD' AND (A.USE_DATE_KT IS NULL OR A.USE_DATE_KT ='')))
|
|
26
|
AND (A.[TYPE_ID]=@p_TYPE_ID OR @p_TYPE_ID IS NULL OR @p_TYPE_ID ='')
|
|
27
|
AND (A.GROUP_ID=@p_GROUP_ID OR @p_GROUP_ID IS NULL OR @p_GROUP_ID ='' OR (DBO.[FN_GET_GROUPID] (A.GROUP_ID,1) =@p_GROUP_ID)
|
|
28
|
OR (DBO.[FN_GET_GROUPID] (A.GROUP_ID,2) =@p_GROUP_ID) OR (DBO.[FN_GET_GROUPID] (A.GROUP_ID,3) =@p_GROUP_ID))
|
|
29
|
AND (A.BRANCH_ID=@p_BRANCH_ID OR @p_BRANCH_ID IS NULL OR @p_BRANCH_ID ='' OR A.DEPT_ID = @p_BRANCH_ID OR (A.TYPE_ID ='TSCD' AND ISNULL(A.BRANCH_CREATE,'') =@p_BRANCH_ID))
|