SELECT  U.ABO,U.LED_ID, U.PROJECT_NO, T.WORDC, P.CHECKC, P.PIN_NO,
  FROM unit1 U, unit2 L, LS..USER2.UNIT3 P, unit4 T  
WHERE 
U.ABO like 'LE%'  
AND U.CREATE_DT = '18/01/2009' 
AND U.ABO = L.ABO
AND L.CT_ID = P.CT_ID AND U.PCT = T.ACT AND U.FJT_TYP = T.FJT_TYP 
ORDER BY U.ABO, U.LED_ID

Error:
OLE DB provider "ORAOLEDB.ORACLE" for linked server "ls" returned message "ORA-01403: no data found".
Msg 7346, Level 16, State 2, Line 1
Cannot get the data of the row from the OLE DB provider "ORAOLEDB.ORACLE" for linked server "ls". 

SELECT  
  U.ABO,
  U.LED_ID, 
  U.PROJECT_NO, 
  T.WORDC, 
  P.CHECKC, 
  P.PIN_NO,
  FROM unit1 U 
    INNER JOIN unit2 L
      ON  U.ABO = L.ABO
    INNER JOIN LS..USER2.UNIT3 P
     ON L.CT_ID = P.CT_ID
    INNER JOIN unit4 T 
      ON  U.PCT = T.ACT
      AND U.FJT_TYP = T.FJT_TYP  
WHERE U.ABO like 'LE%'  
--AND U.CREATE_DT = TO_DATE('18/01/2009' ,'DD/MM/YYYY')
AND U.CREATE_DT ='2009-01-18'
ORDER BY U.ABO, U.LED_ID

 SELECT  U.ABO,U.LED_ID, U.PROJECT_NO, T.WORDC, P.CHECKC, P.PIN_NO,
  FROM unit1 U, unit2 L, LS..USER2.UNIT3 P, unit4 T  
WHERE 
U.ABO like 'LE%'  
AND U.CREATE_DT between  '01/18/2009'  and '04/20/2009'
AND U.ABO = L.ABO
AND L.CT_ID = P.CT_ID AND U.PCT = T.ACT AND U.FJT_TYP = T.FJT_TYP 
ORDER BY U.ABO, U.LED_ID

SELECT  * from OPENQUERY(LS, 'SELECT * FROM  U.ABO,
  U.LED_ID, 
  U.PROJECT_NO, 
  T.WORDC, 
  P.CHECKC, 
  P.PIN_NO,
  FROM unit1 U 
    INNER JOIN unit2 L
      ON  U.ABO = L.ABO
    INNER JOIN LS..USER2.UNIT3 P
     ON L.CT_ID = P.CT_ID
    INNER JOIN unit4 T 
      ON  U.PCT = T.ACT
      AND U.FJT_TYP = T.FJT_TYP  
WHERE U.ABO like 'LE%'  
--AND U.CREATE_DT = TO_DATE('18/01/2009' ,'DD/MM/YYYY')
AND U.CREATE_DT ='2009-01-18'
ORDER BY U.ABO, U.LED_ID') 

SELECT    U.ABO,  U.LED_ID,   U.PROJECT_NO,   T.WORDC,   P.CHECKC,   P.PIN_NO
FROM unit1 U     
INNER JOIN unit2 L      
ON  U.ABO = L.ABO    
INNER JOIN 
(
SELECT CT_ID, CHECKC, PIN_NO FROM 
OPENQUERY(LS,'SELECT CT_ID, CHECKC, PIN_NO FROM USER2.UNIT3')
) P     
ON L.CT_ID = P.CT_ID    
INNER JOIN unit4 T       
ON  U.PCT = T.ACT      
AND U.FJT_TYP = T.FJT_TYP  
WHERE U.ABO like 'LE%'  
AND U.CREATE_DT = '2009-01-18'