SELECT GD_ID FROM CM_GOODS WHERE GD_CODE ='AD.I.N.CE.0035.2021'
SELECT * FROM PL_TRADEDETAIL WHERE GOODS_ID =(SELECT GD_ID FROM CM_GOODS WHERE GD_CODE ='AD.I.N.CE.0035.2021')
SELECT * FROM PL_MASTER WHERE BRANCH_ID ='BRN000000000397' AND PLAN_ID IN (SELECT PLAN_ID FROM PL_TRADEDETAIL WHERE GOODS_ID =(SELECT GD_ID FROM CM_GOODS WHERE GD_CODE ='AD.I.N.CE.0035.2021'))
DECLARE @REQ_ID VARCHAR(15)
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/0001050')
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID =@REQ_ID