Project

General

Profile

Download (634 Bytes)

1.6 CHECK LỊCH THANH TOAN 2 PO.txt

Luc Tran Van, 08/16/2021 08:28 PM

 
1 
SELECT * FROM TR_PO_MASTER WHERE PO_CODE ='PO069/21/0653'
2 
SELECT * FROM TR_PO_DETAIL WHERE PO_ID IN (SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO069/21/0653')
3 
SELECT * FROM TR_PO_PAYMENT WHERE PO_ID IN (SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO069/21/0653')
4 
SELECT * FROM TR_PO_MASTER WHERE PO_CODE ='PO069/21/0496'
5 
SELECT * FROM TR_PO_DETAIL WHERE PO_ID IN (SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO069/21/0496')
6 
SELECT * FROM TR_PO_PAYMENT WHERE PO_ID IN (SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO069/21/0496')
7 

    		
  

  

    
      8
    
    
      
SELECT * FROM TR_PO_MASTER WHERE REQ_DOC_ID IN ('TRRD00000252757','TRRD00000253160')