FND Design Data [Home] [Help]

View: JTF_R_RULES_VL

Product: JTF - CRM Foundation
Description: Provide Rule langauge specific information
Implementation/DBA Data: ViewAPPS.JTF_R_RULES_VL
View Text

SELECT JRST.RULE_ID RULE_ID
, JRST.LANGUAGE LANGUAGE
, JRST.CREATED_BY CREATED_BY
, JRST.CREATION_DATE CREATION_DATE
, JRST.LAST_UPDATED_BY LAST_UPDATED_BY
, JRST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JRST.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JRST.SOURCE_LANG SOURCE_LANG
, JRST.NAME NAME
, JRST.COND_DESC COND_DESC
, JRST.ACTION_DESC ACTION_DESC
FROM JTF_R_RULES_B JRSB
, JTF_R_RULES_TL JRST
WHERE JRST.RULE_ID(+) = JRSB.RULE_ID
AND JRST.LANGUAGE(+) = USERENV('LANG')

Columns

Name
RULE_ID
LANGUAGE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
SOURCE_LANG
NAME
COND_DESC
ACTION_DESC