|
1
|
|
|
2
|
ALTER PROCEDURE [dbo].[TR_REQUEST_DOC_DT_ById]
|
|
3
|
@P_REQ_ID varchar(15) = NULL,
|
|
4
|
@BRANCH_LOGIN varchar(15) = NULL
|
|
5
|
AS
|
|
6
|
SELECT A.*,PO.PO_NAME,PO.PO_CODE,PO.INPUT_DT,PO.CREATE_DT,
|
|
7
|
--PL.PRICE AS PRICE_PL,PL.QUANTITY AS QUANTITY_PL,PL.TOTAL_AMT AS TOTAL_AMT_PL,
|
|
8
|
A.PRICE_ETM AS PRICE_PL,A.QUANTITY AS QUANTITY_PL,A.TOTAL_AMT_ETM AS TOTAL_AMT_PL, HHPL.HH_NAME AS HH_NAME_PL, --'' AS HH_NAME_PL, -- HHPL.HH_NAME AS HH_NAME_PL,
|
|
9
|
S.SUP_NAME,S.SUP_CODE,B.GD_CODE,B.GD_NAME,T.TRN_TYPE_NAME,A.DESCRIPTION AS DES_GOOD,HH.HH_CODE,HH.HH_NAME,
|
|
10
|
--CASE WHEN ISNULL(A.UNIT_NAME,'') ='' THEN PL.UNIT_NAME ELSE
|
|
11
|
--A.UNIT_NAME END AS UNIT_NAME ,
|
|
12
|
----------BAODNQ 25/10/2022 : LẤY UNIT_NAME TRONG TR_REQUEST_DOC_DT
|
|
13
|
A.UNIT_NAME AS UNIT_NAME,
|
|
14
|
UN.UNIT_ID,
|
|
15
|
ISNULL(BID.OFFERING_VALUE, A.OFFERING_VALUE) AS OFFERING_VALUE, BM.BID_CODE, '' AS IS_BID_WIN, PL.SUP_ID AS SUP_ID_TT, PL.NAME AS REASON_CDT, SP.SUP_NAME AS SUP_NAME_TT, AC.CONTENT AS TRADE_TYPE_TT,
|
|
16
|
-----------BAODNQ 23/8/2022 : lấy số hợp đồng---------------
|
|
17
|
TRC.CONTRACT_CODE
|
|
18
|
|
|
19
|
FROM TR_REQUEST_DOC_DT A
|
|
20
|
LEFT JOIN dbo.PL_REQUEST_DOC_DT PL ON PL.REQDT_ID=A.PL_REQDT_ID
|
|
21
|
LEFT JOIN dbo.TR_REQUEST_DOC_PL_DT PLD ON PLD.REQPL_DT_ID = A.REQPL_DT_ID
|
|
22
|
LEFT JOIN dbo.CM_HANGHOA HHPL ON HHPL.HH_ID = PLD.HH_ID -- hàng hóa theo tờ trình
|
|
23
|
LEFT JOIN CM_GOODS B On A.GD_ID=B.GD_ID
|
|
24
|
LEFT JOIN dbo.CM_HANGHOA HH ON HH.HH_ID=A.HANGHOA_ID
|
|
25
|
LEFT JOIN dbo.CM_UNIT UN ON UN.UNIT_ID=HH.UNIT_ID
|
|
26
|
LEFT JOIN dbo.CM_SUPPLIER S ON A.SUP_ID=S.SUP_ID
|
|
27
|
LEFT JOIN dbo.CM_TRAN_TYPE T ON A.TRAN_TYPE_ID=T.TRN_TYPE
|
|
28
|
LEFT JOIN dbo.BID_CONTRACTOR_DT BID ON BID.BID_ID = A.BID_ID AND BID.IS_BID_WIN=1
|
|
29
|
LEFT JOIN DBO.BID_MASTER BM ON A.BID_ID = BM.BID_ID
|
|
30
|
LEFT JOIN CM_SUPPLIER SP ON PL.SUP_ID = SP.SUP_ID
|
|
31
|
LEFT JOIN TR_PO_MASTER PO ON A.PO_ID = PO.PO_ID
|
|
32
|
LEFT JOIN CM_ALLCODE AC ON PL.TRADE_TYPE = AC.CDVAL AND CDNAME = 'TRAN_TYPE'
|
|
33
|
---------------BAODNQ 23/8/2022: Kết bảng hợp đồng-------------
|
|
34
|
LEFT JOIN TR_CONTRACT TRC ON A.CONTRACT_ID = TRC.CONTRACT_ID
|
|
35
|
WHERE A.REQ_DOC_ID=@P_REQ_ID
|
|
36
|
ORDER BY A.REQDT_ID ASC
|