ALTER PROCEDURE [dbo].[TR_REQUEST_DOC_DT_ById]
@P_REQ_ID varchar(15),
@BRANCH_LOGIN	varchar(15) = NULL
AS
SELECT A.*,PO.PO_NAME,PO.PO_CODE,PO.INPUT_DT,PO.CREATE_DT,
--PL.PRICE AS PRICE_PL,PL.QUANTITY AS QUANTITY_PL,PL.TOTAL_AMT AS TOTAL_AMT_PL,
A.PRICE_ETM AS PRICE_PL,A.QUANTITY AS QUANTITY_PL,A.TOTAL_AMT_ETM AS TOTAL_AMT_PL,
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,PL.UNIT_NAME,UN.UNIT_ID,
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
FROM TR_REQUEST_DOC_DT A
LEFT JOIN dbo.PL_REQUEST_DOC_DT PL ON PL.REQDT_ID=A.PL_REQDT_ID
LEFT JOIN CM_GOODS B On A.GD_ID=B.GD_ID
LEFT JOIN dbo.CM_HANGHOA HH ON HH.HH_ID=A.HANGHOA_ID
LEFT JOIN dbo.CM_UNIT UN ON UN.UNIT_ID=HH.UNIT_ID
LEFT JOIN dbo.CM_SUPPLIER S ON A.SUP_ID=S.SUP_ID
LEFT JOIN dbo.CM_TRAN_TYPE T ON A.TRAN_TYPE_ID=T.TRN_TYPE
LEFT JOIN dbo.BID_CONTRACTOR_DT BID ON BID.BID_ID = A.BID_ID AND BID.IS_BID_WIN=1
LEFT JOIN DBO.BID_MASTER BM ON A.BID_ID  = BM.BID_ID
LEFT JOIN CM_SUPPLIER SP ON PL.SUP_ID = SP.SUP_ID
LEFT JOIN TR_PO_MASTER PO ON A.PO_ID = PO.PO_ID
LEFT JOIN CM_ALLCODE AC ON PL.TRADE_TYPE = AC.CDVAL AND CDNAME = 'TRAN_TYPE'
 WHERE A.REQ_DOC_ID=@P_REQ_ID 
 --EXEC TR_PO_DETAIL_ById 'TRPM00000000001', 'DV0001'