Project

General

Profile

Download (2.9 KB)

IN PYCMS 21102020.txt

Luc Tran Van, 10/21/2020 03:16 PM

 
1 
??CREATE PROCEDURE [dbo].[TR_REQUEST_DOC_DT_ById]
2 
@P_REQ_ID varchar(15),
3 
@BRANCH_LOGIN varchar(15) = NULL
4 
AS
5 
SELECT A.*,PO.PO_NAME,PO.PO_CODE,PO.INPUT_DT,PO.CREATE_DT,
6 
--PL.PRICE AS PRICE_PL,PL.QUANTITY AS QUANTITY_PL,PL.TOTAL_AMT AS TOTAL_AMT_PL,
7 
A.PRICE_ETM AS PRICE_PL,A.QUANTITY AS QUANTITY_PL,A.TOTAL_AMT_ETM AS TOTAL_AMT_PL,
8 
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,
9 
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
10 
FROM TR_REQUEST_DOC_DT A
11 
LEFT JOIN dbo.PL_REQUEST_DOC_DT PL ON PL.REQDT_ID=A.PL_REQDT_ID
12 
LEFT JOIN CM_GOODS B On A.GD_ID=B.GD_ID
13 
LEFT JOIN dbo.CM_HANGHOA HH ON HH.HH_ID=A.HANGHOA_ID
14 
LEFT JOIN dbo.CM_UNIT UN ON UN.UNIT_ID=HH.UNIT_ID
15 
LEFT JOIN dbo.CM_SUPPLIER S ON A.SUP_ID=S.SUP_ID
16 
LEFT JOIN dbo.CM_TRAN_TYPE T ON A.TRAN_TYPE_ID=T.TRN_TYPE
17 
LEFT JOIN dbo.BID_CONTRACTOR_DT BID ON BID.BID_ID = A.BID_ID AND BID.IS_BID_WIN=1
18 
LEFT JOIN DBO.BID_MASTER BM ON A.BID_ID = BM.BID_ID
19 
LEFT JOIN CM_SUPPLIER SP ON PL.SUP_ID = SP.SUP_ID
20 
LEFT JOIN TR_PO_MASTER PO ON A.PO_ID = PO.PO_ID
21 
LEFT JOIN CM_ALLCODE AC ON PL.TRADE_TYPE = AC.CDVAL AND CDNAME = 'TRAN_TYPE'
22 
WHERE A.REQ_DOC_ID=@P_REQ_ID
23 
--EXEC TR_PO_DETAIL_ById 'TRPM00000000001', 'DV0001'
24