|
1
|
|
|
2
|
ALTER PROCEDURE [dbo].[TR_REQUEST_DOC_DT_ById]
|
|
3
|
@P_REQ_ID varchar(15),
|
|
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,
|
|
9
|
S.SUP_NAME,S.SUP_CODE,B.GD_CODE,B.GD_NAME,T.TRN_TYPE_NAME,ISNULL(PL.[DESCRIPTION],A.[DESCRIPTION]) AS DES_GOOD,HH.HH_CODE,HH.HH_NAME,PL.UNIT_NAME,UN.UNIT_ID,
|
|
10
|
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
|
|
11
|
FROM TR_REQUEST_DOC_DT A
|
|
12
|
LEFT JOIN dbo.PL_REQUEST_DOC_DT PL ON PL.REQDT_ID=A.PL_REQDT_ID
|
|
13
|
LEFT JOIN CM_GOODS B On A.GD_ID=B.GD_ID
|
|
14
|
LEFT JOIN dbo.CM_HANGHOA HH ON HH.HH_ID=A.HANGHOA_ID
|
|
15
|
LEFT JOIN dbo.CM_UNIT UN ON UN.UNIT_ID=HH.UNIT_ID
|
|
16
|
LEFT JOIN dbo.CM_SUPPLIER S ON A.SUP_ID=S.SUP_ID
|
|
17
|
LEFT JOIN dbo.CM_TRAN_TYPE T ON A.TRAN_TYPE_ID=T.TRN_TYPE
|
|
18
|
LEFT JOIN dbo.BID_CONTRACTOR_DT BID ON BID.BID_ID = A.BID_ID AND BID.IS_BID_WIN=1
|
|
19
|
LEFT JOIN DBO.BID_MASTER BM ON A.BID_ID = BM.BID_ID
|
|
20
|
LEFT JOIN CM_SUPPLIER SP ON PL.SUP_ID = SP.SUP_ID
|
|
21
|
LEFT JOIN TR_PO_MASTER PO ON A.PO_ID = PO.PO_ID
|
|
22
|
LEFT JOIN CM_ALLCODE AC ON PL.TRADE_TYPE = AC.CDVAL AND CDNAME = 'TRAN_TYPE'
|
|
23
|
WHERE A.REQ_DOC_ID=@P_REQ_ID
|
|
24
|
--EXEC TR_PO_DETAIL_ById 'TRPM00000000001', 'DV0001'
|