   SELECT xcnc.XCNC_LONGDESC, xcno.xcno_notes, xcms.xcms_id
     FROM xcno, xcms, xcnc
    WHERE xcms.xcms_id = xcno.xcno_table_id
      AND UPPER (xcno.xcno_tablelinkedto) = 'XCMS'
	  AND xcno.XCNO_XCNC_ID = xcnc.XCNC_ID
	  AND xcno.XCNO_TABLE_ID =:Parameter;