Product: | JTF - CRM Foundation |
---|---|
Description: | view for ruleset |
Implementation/DBA Data: | APPS.JTF_R_RULESETS_V |
SELECT JRSB.RULESET_ID RULESET_ID
, JRSB.CREATED_BY CREATED_BY
, JRSB.CREATION_DATE CREATION_DATE
, JRSB.LAST_UPDATED_BY LAST_UPDATED_BY
, JRSB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JRSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JRSB.APPLICATION_ID APPLICATION_ID
, JRSB.STATUS STATUS
, JRSB.START_DATE START_DATE
, JRSB.END_DATE END_DATE
, JRSB.RULESET_CLASS RULESET_CLASS
, JRSB.RULESET_SER RULESET_SER
, JRST.NAME NAME
, JRST.SOURCE_LANG SOURCE_LANG
, JRST.DESCRIPTION DESCRIPTION
, JRSB.OBJECT_TYPE OBJECT_TYPE
, JRSB.MAX_OBJECTS MAX_OBJECTS
FROM JTF_R_RULESETS_B JRSB
, JTF_R_RULESETS_VL JRST
WHERE JRSB.RULESET_ID = JRST.RULESET_ID