RCL_CHARGES_PROCESS_RULES_VL

Details

  • Schema: FUSION

  • Object owner: RCL

  • Object type: VIEW

Columns

Name

RULE_ID

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

ENABLED_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

ruleb.rule_id,

ruleb.object_version_number,

rulet.name,

rulet.description,

ruleb.enabled_flag,

ruleb.created_by,

ruleb.creation_date,

ruleb.last_updated_by,

ruleb.last_update_date,

ruleb.last_update_login

FROM

rcl_charges_process_rules_b ruleb,

rcl_charges_process_rules_tl rulet

WHERE

ruleb.rule_id = rulet.rule_id

AND

rulet.language = userenv('LANG')