SELECT  TAB1.ID, TAB1.CRNCY_CODE, TAB2.SCHEME_CODE, DECODE( 'INFENG',CAST( ''  AS VARCHAR(20)),
NVL(TAB2.ALT1_SCHEME_DESC,TAB2.SCHEME_DESC),TAB2.SCHEME_DESC),  
TAB1.SUB_HEAD_CODE,  DECODE( 'INFENG' ,CAST( ''  AS VARCHAR(20)),NVL(TAB1.ALT1_SUB_HEAD_DESC ,
TAB1.SUB_HEAD_DESC),TAB1.SUB_HEAD_DESC) 
FROM TAB1, TAB4, TAB2, TAB3  
WHERE TAB2.SCHEME_TYPE = 'SCHEME1'  AND TAB1.BANK_ID= '01'  AND  TAB4.BANK_ID= '01' 
AND  TAB2.BANK_ID= '01'  AND  TAB3.BANK_ID= '01'  AND  TAB3.DEL_FLG != 'Y'  AND TAB4.DEL_FLG != 'Y'
AND TAB1.DEL_FLG != 'Y'  AND TAB2.DEL_FLG != 'Y'  
AND TAB3.SUB_HEAD_CODE = TAB1.SUB_HEAD_CODE
AND TAB3.SCHEME_CODE = TAB4.SCHEME_CODE 
AND TAB2.SCHEME_CODE = TAB3.SCHEME_CODE 
AND TAB1.CRNCY_CODE = TAB4.CRNCY_CODE 
AND TAB1.ID = '105'   AND TAB4.CRNCY_CODE =  'INR'    
union

select null ID,null crncy_code,TAB2.SCHEME_CODE  ,
NVL(TAB2.ALT1_SCHEME_DESC,TAB2.SCHEME_DESC),TAB2.SCHEME_DESC,null SUB_HEAD_CODE from TAB2 where TAB2.SCHEME_TYPE ='SCHEME1';