SELECT
    X5.XCMS_ID, 
    X5.XCMS_NAME1 LASTNAME, 
    X5.XCMS_NAME3 FIRSTNAME, 
    C5.XCID_ADDRGREET ADDR_GREETING, 
    C5.XCID_LETTGREET LETT_GREETING, 
    C5.XCID_BIRTHTIME
FROM 
    XCMS X5, XCID C5
WHERE 
    X5.XCMS_ID = {xcms_id} 
and X5.XCMS_ID = C5.XCID_ID(+)