VIEW: APPS.WF_NTF_RULES_VL

Source

View Text - Preformatted

select b.rowid row_id,
       b.rule_name,
       tl.user_rule_name,
       tl.description,
       b.customization_level,
       b.phase,
       b.status,
       b.owner_tag,
       b.owner_name,
       b.creation_date
from wf_ntf_rules b,
     wf_ntf_rules_tl tl
where b.rule_name = tl.rule_name
and  tl.language = userenv('LANG')

   

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.RULE_NAME
, TL.USER_RULE_NAME
, TL.DESCRIPTION
, B.CUSTOMIZATION_LEVEL
, B.PHASE
, B.STATUS
, B.OWNER_TAG
, B.OWNER_NAME
, B.CREATION_DATE FROM WF_NTF_RULES B
, WF_NTF_RULES_TL TL WHERE B.RULE_NAME = TL.RULE_NAME AND TL.LANGUAGE = USERENV('LANG')