|
1
|
SET ANSI_NULLS ON
|
|
2
|
|
|
3
|
SET QUOTED_IDENTIFIER ON
|
|
4
|
|
|
5
|
ALTER PROC [dbo].[rpt_ASS_TRANSFER_MULTI_CONFIRM_Excel]
|
|
6
|
@TRANS_MULTI_MASTER_ID VARCHAR(15) = null,
|
|
7
|
@BRANCH_ID VARCHAR(15) = null,
|
|
8
|
@FROMDATE VARCHAR(15) = null,
|
|
9
|
@TODATE VARCHAR(15) = null,
|
|
10
|
@IS_CONFIRM VARCHAR(1) = null
|
|
11
|
as
|
|
12
|
BEGIN
|
|
13
|
SELECT
|
|
14
|
B.ASSET_CODE, B.ASSET_NAME, B.AMORT_MONTH, B.AMORTIZED_MONTH, B.AMORT_AMT, B.AMORTIZED_AMT, AMORT_AMT - B.AMORTIZED_AMT AS GT_CL, B.NOTES,
|
|
15
|
A.TRANS_MULTI_MASTER_ID,CB.BRANCH_CODE,CB.BRANCH_NAME,1 AS SL,B.BUY_PRICE,'' AS UNIT,B.ASSET_SERIAL_NO AS SERIAL_NUMBER,
|
|
16
|
dbo.FN_GET_BRANCH_LEADER(C.BRANCH_ID, c.DEPT_ID) AS TLNANME
|
|
17
|
FROM ASS_TRANSFER_MULTI_MASTER A
|
|
18
|
INNER JOIN ASS_TRANSFER_MULTI_DT C ON C.TRANS_MULTI_MASTER_ID = A.TRANS_MULTI_MASTER_ID
|
|
19
|
INNER JOIN ASS_MASTER B ON B.ASSET_ID = C.ASSET_ID
|
|
20
|
LEFT JOIN CM_BRANCH CB ON CB.BRANCH_ID = C.BRANCH_ID
|
|
21
|
WHERE (A.TRANS_MULTI_MASTER_ID = @TRANS_MULTI_MASTER_ID OR @TRANS_MULTI_MASTER_ID IS NULL OR @TRANS_MULTI_MASTER_ID = '')
|
|
22
|
AND A.AUTH_STATUS = 'A'
|
|
23
|
AND (C.BRANCH_ID = @BRANCH_ID OR @BRANCH_ID IS NULL OR @BRANCH_ID = '')
|
|
24
|
AND ((@IS_CONFIRM = 'Y' AND A.TRANS_MULTI_MASTER_ID IN (SELECT TRANS_MULTI_MASTER_ID FROM dbo.ASS_TRANSFER_CONFIRM_MASTER WHERE CONFIRM_STATUS_BN = 'Y'))
|
|
25
|
OR (@IS_CONFIRM = 'N' AND A.TRANS_MULTI_MASTER_ID NOT IN (SELECT TRANS_MULTI_MASTER_ID FROM dbo.ASS_TRANSFER_CONFIRM_MASTER)
|
|
26
|
OR (@IS_CONFIRM= '' OR @IS_CONFIRM IS NULL)))
|
|
27
|
AND (CONVERT(DATE,A.APPROVE_DT) >= CONVERT(DATE, @FROMDATE, 103) OR @FROMDATE is NULL OR @FROMDATE = '')
|
|
28
|
AND (CONVERT(DATE,A.APPROVE_DT) <= CONVERT(DATE, @TODATE, 103) OR @TODATE is NULL OR @TODATE = '')
|
|
29
|
END
|
|
30
|
|