[Home] [Help]
View: JTF_R_RULESETS_VL
Product: | JTF - CRM Foundation |
Description: | RuleSet language specific view |
Implementation/DBA Data: |
APPS.JTF_R_RULESETS_VL
|
View Text
SELECT JRST.RULESET_ID RULESET_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.NAME NAME
, JRST.SOURCE_LANG SOURCE_LANG
, JRST.DESCRIPTION DESCRIPTION
, JRST.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM JTF_R_RULESETS_B JRSB
, JTF_R_RULESETS_TL JRST
WHERE JRST.RULESET_ID(+) = JRSB.RULESET_ID
AND JRST.LANGUAGE(+) = USERENV('LANG')
Columns
Name |
RULESET_ID |
LANGUAGE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
NAME |
SOURCE_LANG |
DESCRIPTION |
OBJECT_VERSION_NUMBER |