1. Tables and Views for HCM
  2. IRC_LC_ACTION_USAGES_VL

IRC_LC_ACTION_USAGES_VL

Details

  • Schema: FUSION

  • Object owner: IRC

  • Object type: VIEW

Columns

Name

STEP_ACTION_USAGE_ID

ROUTING_STEP_ID

ACTION_ID

TRIGGER_EVENT_CODE

TRACE_LOG

ACTION_NAME

ACTION_DESCRIPTION

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

STEP_ACTION_USAGE_CODE

LAST_EXECUTION_DATE

LAST_EXECUTION_RESULT

SETTING_ID

Query

SQL_Statement

SELECT

IRC_LC_ACTION_USAGES_B.STEP_ACTION_USAGE_ID STEP_ACTION_USAGE_ID,

IRC_LC_ACTION_USAGES_B.ROUTING_STEP_ID ROUTING_STEP_ID,

IRC_LC_ACTION_USAGES_B.ACTION_ID ACTION_ID,

IRC_LC_ACTION_USAGES_B.TRIGGER_EVENT_CODE TRIGGER_EVENT_CODE,

IRC_LC_ACTION_USAGES_B.TRACE_LOG TRACE_LOG,

IRC_LC_ACTION_USAGES_TL.ACTION_NAME ACTION_NAME,

IRC_LC_ACTION_USAGES_TL.ACTION_DESCRIPTION ACTION_DESCRIPTION,

IRC_LC_ACTION_USAGES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

IRC_LC_ACTION_USAGES_B.CREATED_BY CREATED_BY,

IRC_LC_ACTION_USAGES_B.CREATION_DATE CREATION_DATE,

IRC_LC_ACTION_USAGES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

IRC_LC_ACTION_USAGES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

IRC_LC_ACTION_USAGES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

IRC_LC_ACTION_USAGES_B.STEP_ACTION_USAGE_CODE STEP_ACTION_USAGE_CODE,

IRC_LC_ACTION_USAGES_B.LAST_EXECUTION_DATE LAST_EXECUTION_DATE,

IRC_LC_ACTION_USAGES_B.LAST_EXECUTION_RESULT LAST_EXECUTION_RESULT,

IRC_LC_ACTION_USAGES_B.SETTING_ID SETTING_ID

FROM

IRC_LC_ACTION_USAGES_B,

IRC_LC_ACTION_USAGES_TL

WHERE

IRC_LC_ACTION_USAGES_B.STEP_ACTION_USAGE_ID = IRC_LC_ACTION_USAGES_TL.STEP_ACTION_USAGE_ID AND IRC_LC_ACTION_USAGES_TL.LANGUAGE = USERENV('LANG')