VIEW: APPS.HXC_DATA_APP_RULE_USAGES_V

Source

View Text - Preformatted

SELECT dru.rowid row_id, dru.data_app_rule_usage_id, dru.approval_style_id, has.name approval_style_name, dru.time_entry_rule_id, dar.name rule, dru.time_recipient_id, htr.name application, dru.object_version_number, dru.created_by, dru.creation_date, dru.last_updated_by, dru.last_update_date, dru.last_update_login From hxc_time_recipients htr, hxc_time_entry_rules dar, hxc_approval_styles has, hxc_data_app_rule_usages dru where dru.time_entry_rule_id = dar.time_entry_rule_id and dru.time_recipient_id = htr.time_recipient_id(+) and dru.approval_style_id = has.approval_style_id

View Text - HTML Formatted

SELECT DRU.ROWID ROW_ID
, DRU.DATA_APP_RULE_USAGE_ID
, DRU.APPROVAL_STYLE_ID
, HAS.NAME APPROVAL_STYLE_NAME
, DRU.TIME_ENTRY_RULE_ID
, DAR.NAME RULE
, DRU.TIME_RECIPIENT_ID
, HTR.NAME APPLICATION
, DRU.OBJECT_VERSION_NUMBER
, DRU.CREATED_BY
, DRU.CREATION_DATE
, DRU.LAST_UPDATED_BY
, DRU.LAST_UPDATE_DATE
, DRU.LAST_UPDATE_LOGIN
FROM HXC_TIME_RECIPIENTS HTR
, HXC_TIME_ENTRY_RULES DAR
, HXC_APPROVAL_STYLES HAS
, HXC_DATA_APP_RULE_USAGES DRU
WHERE DRU.TIME_ENTRY_RULE_ID = DAR.TIME_ENTRY_RULE_ID
AND DRU.TIME_RECIPIENT_ID = HTR.TIME_RECIPIENT_ID(+)
AND DRU.APPROVAL_STYLE_ID = HAS.APPROVAL_STYLE_ID