PJC_DISTRIBUTE_RULE_SETS_VL

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
DISTRIBUTE_RULE_SET_ID DISTRIBUTE_PATTERN_ID PRECEDENCE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DISTRIBUTE_PATTERN_SET_NAME DISTRIBUTE_PATTERN_SET_DESC

Query

SQL_Statement

SELECT b.distribute_rule_set_id, b.distribute_pattern_id, b.precedence, b.attribute_category, b.attribute1, b.attribute2, b.attribute3, b.attribute4, b.attribute5, b.attribute6, b.attribute7, b.attribute8, b.attribute9, b.attribute10, b.object_version_number, b.created_by, b.creation_date, b.last_updated_by, b.last_update_date, b.last_update_login, tl.distribute_pattern_set_name, tl.distribute_pattern_set_desc FROM PJC_DISTRIBUTE_RULE_SETS_B b, PJC_DISTRIBUTE_RULE_SETS_TL tl WHERE b.distribute_rule_set_id = tl.distribute_rule_set_id AND tl.language = userenv('LANG')