[Home] [Help]
VIEW: APPS.JTF_FM_MASTER_DOC_V
Source
View Text - Preformatted
SELECT QMS.MES_DOC_ID, QMS.QUERY_ID, QUE.APP_DBNAME, QUE.APP_USERID, QUE.QUERY_STRING, QUE.QUERY_NAME, QUE.QUERY_DESC FROM JTF_FM_QUERIES_ALL QUE, JTF_FM_QUERY_MES QMS WHERE QUE.QUERY_ID = QMS.QUERY_ID
View Text - HTML Formatted
SELECT QMS.MES_DOC_ID
, QMS.QUERY_ID
, QUE.APP_DBNAME
, QUE.APP_USERID
, QUE.QUERY_STRING
, QUE.QUERY_NAME
, QUE.QUERY_DESC
FROM JTF_FM_QUERIES_ALL QUE
, JTF_FM_QUERY_MES QMS
WHERE QUE.QUERY_ID = QMS.QUERY_ID