DBA Data[Home] [Help]

VIEW: APPS.INL_RULES_VL

Source

View Text - Preformatted

SELECT b.rule_id, t.rule_name, b.package_name, b.usage_code, b.enabled_flag, b.created_by, b.creation_date, b.last_updated_by, b.last_update_date, b.last_update_login FROM inl_rules_tl t, inl_rules_b b WHERE b.rule_id = t.rule_id AND t.language = USERENV('LANG')
View Text - HTML Formatted

SELECT B.RULE_ID
, T.RULE_NAME
, B.PACKAGE_NAME
, B.USAGE_CODE
, B.ENABLED_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM INL_RULES_TL T
, INL_RULES_B B
WHERE B.RULE_ID = T.RULE_ID
AND T.LANGUAGE = USERENV('LANG')