|
1
|
ALTER PROCEDURE dbo.ASS_LIQUIDDETAIL_BVB_ById
|
|
2
|
@p_LIQ_ID varchar(15) = NULL
|
|
3
|
|
|
4
|
AS
|
|
5
|
|
|
6
|
BEGIN
|
|
7
|
SELECT A.LIQDT_ID,A.LIQ_ID,A.ASSET_ID,A.LIQ_PRICE,A.LIQ_TYPE,A.AUTH_STATUS,A.MAKER_ID, A.NOTE,
|
|
8
|
A.CREATE_DT,A.CHECKER_ID,A.APPROVE_DT, B.ASSET_NAME, B.ASSET_CODE, B.BUY_PRICE,
|
|
9
|
A.REMAIN_AMORTIZED_AMT, A.BUY_PRICE, A.BUY_PRICE_LIQ, A.REMAIN_VALUE, A.LIQ_AMT,
|
|
10
|
-- CASE
|
|
11
|
-- WHEN A.ASS_STATUS IS NOT NULL AND A.ASS_STATUS <> '' THEN ASS.STATUS_NAME
|
|
12
|
-- ELSE ASS2.STATUS_NAME
|
|
13
|
-- END AS ASS_STATUS_NAME, --Tinh trang tai san
|
|
14
|
ASS.STATUS_NAME AS ASS_STATUS_NAME,
|
|
15
|
B.ASS_STATUS_DESC, B.AMORT_STATUS,
|
|
16
|
-- CASE
|
|
17
|
-- WHEN A.AMORT_STATUS IS NULL OR A.AMORT_STATUS = '' THEN AAS.STATUS_NAME
|
|
18
|
-- ELSE AAS2.STATUS_NAME
|
|
19
|
-- END AS AMORT_STATUS_NAME, -- Trang thai khau hao
|
|
20
|
AAS.STATUS_NAME AS AMORT_STATUS_NAME,
|
|
21
|
CB.BRANCH_NAME AS BRANCH_NAME_USE, CB.BRANCH_ID AS BRANCH_ID_USE,
|
|
22
|
CD.DEP_NAME AS DEPT_NAME_USE, CD.DEP_ID AS DEPT_ID_USE
|
|
23
|
, AZ.LIST_LIQ_REQUEST
|
|
24
|
, A.LIQ_REQ_ID,
|
|
25
|
CASE WHEN A.ASS_AMORTIZED_MONTH IS NULL THEN ISNULL(B.AMORTIZED_MONTH,0) ELSE ISNULL(A.ASS_AMORTIZED_MONTH,0) END ASS_AMORTIZED_MONTH,
|
|
26
|
CASE WHEN A.ASS_AMORTIZED_AMT IS NULL THEN ISNULL(B.AMORTIZED_AMT,0) ELSE ISNULL(A.ASS_AMORTIZED_AMT,0) END ASS_AMORTIZED_AMT
|
|
27
|
, CASE WHEN A.LIQ_VAT IS NULL THEN 0 ELSE A.LIQ_VAT END AS LIQ_VAT
|
|
28
|
, CASE WHEN A.LIQ_VAT IS NULL THEN 0 ELSE A.LIQ_PRICE_VAT END AS LIQ_PRICE_VAT
|
|
29
|
,A.REQ_AMT
|
|
30
|
-- ,A.REQ_AMT - ISNULL(A.LIQ_PRICE_VAT, 0) AS LIQ_AMT_BE_VAT
|
|
31
|
, A.LIQ_AMT_BE_VAT
|
|
32
|
,A.LIQ_REASON
|
|
33
|
FROM ASS_LIQUIDATION_DT A
|
|
34
|
LEFT JOIN ASS_MASTER B ON A.ASSET_ID=B.ASSET_ID
|
|
35
|
LEFT JOIN ASS_AMORT_STATUS AAS ON AAS.STATUS_CODE = B.AMORT_STATUS
|
|
36
|
LEFT JOIN ASS_STATUS ASS ON B.ASS_STATUS = ASS.STATUS_ID
|
|
37
|
--LEFT JOIN ASS_AMORT_STATUS AAS2 ON AAS.STATUS_CODE = A.AMORT_STATUS
|
|
38
|
--LEFT JOIN ASS_STATUS ASS2 ON A.ASS_STATUS = ASS.STATUS_ID
|
|
39
|
LEFT JOIN CM_BRANCH CB ON A.BRANCH_ID_USE = CB.BRANCH_ID
|
|
40
|
LEFT JOIN CM_DEPARTMENT CD ON CD.DEP_ID = A.DEP_ID_USE
|
|
41
|
LEFT JOIN ASS_LIQUIDATION AZ ON A.LIQ_ID = AZ.LIQ_ID
|
|
42
|
WHERE 1 = 1 AND A.LIQ_ID = @p_LIQ_ID
|
|
43
|
END
|