|
SELECT R.EOPCMAIN_ID , R.RECNAME , F.FIELDNAME , F.EOPCALT_LABEL , F.EOPCALT_LABEL FROM PS_EOPCAPP_KEY_FLD F , PS_EOPCAPP_SRC_REC R WHERE 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 , %Substring(M.MESSAGE_TEXT, 1, 30) , M.MESSAGE_TEXT FROM PSMSGCATDEFN M , PS_EOPCAPP_KEY_FLD F , PS_EOPCAPP_SRC_REC R WHERE F.EOPCAPP_SRCREC_ID = R.EOPCAPP_SRCREC_ID AND M.MESSAGE_SET_NBR = F.EOPCLBL_MSGSET AND M.MESSAGE_NBR = F.EOPCLBL_MSGNBR AND F.EOPCLBL_MSGNBR > 0
|