Project

General

Profile

Download (563 Bytes)

script_MW_071222.txt

Luc Tran Van, 12/07/2022 01:39 PM

 
1 
SELECT * FROM MW_MAST_PRICE WHERE PRICE_CODE IN ('069CSKH200084006', '069CSKH200084007', '069CSKH200084008')
2 
SELECT * FROM MW_MAST_BAL WHERE PRICE_ID IN (SELECT PRICE_ID FROM MW_MAST_PRICE WHERE PRICE_CODE IN ('069CSKH200084006', '069CSKH200084007', '069CSKH200084008'))
3 
AND BRANCH_ID ='BRN000000000416'
4 

    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
SELECT * FROM MW_OUT_DT WHERE MAST_BAL_ID IN (SELECT MAST_BAL_ID FROM MW_MAST_BAL WHERE PRICE_ID IN (SELECT PRICE_ID FROM MW_MAST_PRICE WHERE PRICE_CODE IN ('069CSKH200084006', '069CSKH200084007', '069CSKH200084008'))


    		
  

  

    
      7
    
    
      
AND BRANCH_ID ='BRN000000000416')