|
SELECT R.EOPCMAIN_ID , R.RECNAME , F.FIELDNAME , L.LANGUAGE_CD , F.EOPCALT_LABEL , F.EOPCALT_LABEL FROM PS_EOPCMAIN_LNG L , PS_EOPCAPP_KEY_FLD F , PS_EOPCAPP_SRC_REC R WHERE L.EOPCMAIN_ID = R.EOPCMAIN_ID AND F.EOPCAPP_SRCREC_ID = R.EOPCAPP_SRCREC_ID AND NOT EXISTS ( SELECT 'X' FROM PSMSGCATDEFN M WHERE M.MESSAGE_SET_NBR = F.EOPCLBL_MSGSET AND M.MESSAGE_NBR = F.EOPCLBL_MSGNBR) UNION SELECT R.EOPCMAIN_ID , R.RECNAME , F.FIELDNAME , L.LANGUAGE_CD , %Substring(M.MESSAGE_TEXT, 1, 30) , M.MESSAGE_TEXT FROM PS_EOPCMAIN_LNG L , PSMSGCATLANG M , PS_EOPCAPP_KEY_FLD F , PS_EOPCAPP_SRC_REC R WHERE L.EOPCMAIN_ID = R.EOPCMAIN_ID AND F.EOPCAPP_SRCREC_ID = R.EOPCAPP_SRCREC_ID AND M.MESSAGE_SET_NBR = F.EOPCLBL_MSGSET AND M.MESSAGE_NBR = F.EOPCLBL_MSGNBR AND M.LANGUAGE_CD = L.LANGUAGE_CD AND F.EOPCLBL_MSGNBR > 0
|