DBA Data[Home] [Help]

VIEW: APPS.MST_AUTO_REL_RULES_V

Source

View Text - Preformatted

SELECT r.rule_id, r.name, r.description, a.rule_set_id, r.created_by, r.creation_date, r.last_updated_by, r.last_update_date, r.last_update_login from mst_auto_rel_rules r, mst_rel_rule_associations a WHERE r.rule_id = a.rule_id
View Text - HTML Formatted

SELECT R.RULE_ID
, R.NAME
, R.DESCRIPTION
, A.RULE_SET_ID
, R.CREATED_BY
, R.CREATION_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN
FROM MST_AUTO_REL_RULES R
, MST_REL_RULE_ASSOCIATIONS A
WHERE R.RULE_ID = A.RULE_ID