VIEW: APPS.CN_RULES_V

Source

View Text - Preformatted

SELECT rule.rule_id, rule.name, hier.parent_rule_id, rule.revenue_class_id, rule.expense_ccid, rule.liability_ccid, hier.sequence_number, rule.ruleset_id, rule.last_update_date, rule.last_updated_by, rule.last_update_login, rule.creation_date, rule.created_by , rule.org_id FROM CN_RULES_VL RULE,CN_RULES_HIERARCHY HIER WHERE rule.rule_id = hier.rule_id (+)

View Text - HTML Formatted

SELECT RULE.RULE_ID
, RULE.NAME
, HIER.PARENT_RULE_ID
, RULE.REVENUE_CLASS_ID
, RULE.EXPENSE_CCID
, RULE.LIABILITY_CCID
, HIER.SEQUENCE_NUMBER
, RULE.RULESET_ID
, RULE.LAST_UPDATE_DATE
, RULE.LAST_UPDATED_BY
, RULE.LAST_UPDATE_LOGIN
, RULE.CREATION_DATE
, RULE.CREATED_BY
, RULE.ORG_ID
FROM CN_RULES_VL RULE
, CN_RULES_HIERARCHY HIER
WHERE RULE.RULE_ID = HIER.RULE_ID (+)