View: JTF_R_RULES_V

Product:	JTF - CRM Foundation
Description:	view for rules
Implementation/DBA Data:	APPS.JTF_R_RULES_V

View Text

SELECT JRSB.RULE_ID RULE_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.RULESET_ID RULESET_ID
, JRSB.STATUS STATUS
, JRSB.START_DATE START_DATE
, JRSB.END_DATE END_DATE
, JRSB.PRIORITY PRIORITY
, JRST.NAME NAME
, JRST.SOURCE_LANG SOURCE_LANG
, JRST.COND_DESC COND_DESC
, JRST.ACTION_DESC ACTION_DESC
FROM JTF_R_RULES_B JRSB
, JTF_R_RULES_VL JRST
WHERE JRSB.RULE_ID = JRST.RULE_ID

Columns