|
1
|
|
|
2
|
ALTER PROCEDURE dbo.ASS_LIQUIDATION_BVB_Export
|
|
3
|
@p_LIQ_ID varchar(20) = NULL
|
|
4
|
|
|
5
|
AS
|
|
6
|
|
|
7
|
BEGIN
|
|
8
|
SELECT ROW_NUMBER() OVER (ORDER BY LIQ_ID) AS STT, A.LIQDT_ID,A.LIQ_ID,A.ASSET_ID,A.LIQ_PRICE,A.LIQ_TYPE,A.AUTH_STATUS,A.MAKER_ID,
|
|
9
|
A.CREATE_DT,A.CHECKER_ID,A.APPROVE_DT, B.ASSET_NAME, B.ASSET_CODE,
|
|
10
|
ISNULL(A.BUY_PRICE_LIQ * A.REMAIN_VALUE/IIF(A.BUY_PRICE IS NULL,0,A.BUY_PRICE),0) AS REMAIN_VALUE,
|
|
11
|
A.REMAIN_VALUE AS REMAIN_AMORTIZED_AMT,
|
|
12
|
-- ISNULL((B.AMORT_AMT - B.AMORTIZED_AMT), B.AMORT_AMT) AS REMAIN_AMORTIZED_AMT, --So tien khau hao con lai
|
|
13
|
A.BUY_PRICE, A.BUY_PRICE_LIQ, E.STATUS_NAME ASS_STATUS_NAME, --Tinh trang tai san
|
|
14
|
BR_C.BRANCH_CODE BRANCH_CODE_CRE, BR_C.BRANCH_NAME BRANCH_NAME_CRE, BR_U.BRANCH_CODE BRANCH_CODE_USE, BR_U.BRANCH_NAME BRANCH_NAME_USE,AMORT_MONTH,ISNULL(AMORT_MONTH-AMORTIZED_MONTH,AMORT_MONTH) AS REMAIN_AMORT_MONTH,
|
|
15
|
DP_U.DEP_CODE AS DEPT_CODE_USE, DP_U.DEP_NAME AS DEPT_NAME_USE,A.LIQ_REASON,B.BUY_DATE_KT,B.AMORTIZED_MONTH,B.AMORTIZED_AMT,B.AMORT_AMT
|
|
16
|
FROM ASS_LIQUIDATION_DT A
|
|
17
|
LEFT JOIN ASS_MASTER B ON A.ASSET_ID=B.ASSET_ID
|
|
18
|
LEFT JOIN ASS_STATUS E ON B.ASS_STATUS = E.STATUS_ID
|
|
19
|
--LUCTV: 19-12-2018 BO SUNG LEFT JOIN DE LAY THONG TIN DON VI NHAP TAI SAN, DON VI DANG SU SUNG TAI SAN
|
|
20
|
LEFT JOIN CM_BRANCH BR_C ON B.BRANCH_CREATE = BR_C.BRANCH_ID
|
|
21
|
LEFT JOIN CM_BRANCH BR_U ON B.BRANCH_ID = BR_U.BRANCH_ID
|
|
22
|
LEFT JOIN dbo.CM_DEPARTMENT DP_U ON B.DEPT_ID = DP_U.DEP_ID
|
|
23
|
WHERE 1 = 1 AND A.LIQ_ID = @p_LIQ_ID
|
|
24
|
END
|
|
25
|
|
|
26
|
GO
|