[Home] [Help]
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
Name |
QMS_MES_DOC_ID |
QMS_QUERY_ID |
QUE_APP_DBNAME |
QUE_APP_USERID |
QUE_QUERY_STRING |
QUE_QUERY_NAME |
QUE_QUERY_DESC |