View: JTF_FM_MASTER_DOC_V

Product:	JTF - CRM Foundation
Description:	View to show the content ID's and queries for master documents
Implementation/DBA Data:	APPS.JTF_FM_MASTER_DOC_V

View Text

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

Columns