FND Design Data [Home] [Help]

View: JTF_FM_QUERY

Product: JTF - CRM Foundation
Description: This view refers to the table JTF_FM_QUERY storing information about the fulfillment queries
Implementation/DBA Data: ViewAPPS.JTF_FM_QUERY
View Text

SELECT QUERY_ID
, APP_DBNAME
, APP_USERID
, APP_PASSWORD
, QUERY_STRING
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORG_ID
, F_DELETEDFLAG
, QUERY_NAME
, QUERY_DESC
, OBJECT_VERSION_NUMBER
, FILE_ID
FROM JTF_FM_QUERIES_ALL

Columns

Name
QUERY_ID
APP_DBNAME
APP_USERID
APP_PASSWORD
QUERY_STRING
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ORG_ID
F_DELETEDFLAG
QUERY_NAME
QUERY_DESC
OBJECT_VERSION_NUMBER
FILE_ID