1. Tables and Views for HCM
  2. PER_ACTION_TYPES_VL

PER_ACTION_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

ACTION_TYPE_ID

ACTION_TYPE_CODE

MEANING

BUSINESS_GROUP_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

MODULE_ID

SGUID

CHANGE_ASG_VISIBLE_FLAG

DEFAULT_ASG_STATUS

SUPPORT_ASG_STATUS_DFLT

INCLUDE_CLE_FUT

Query

SQL_Statement

SELECT

b.ACTION_TYPE_ID,

b.ACTION_TYPE_CODE,

t.MEANING,

b.BUSINESS_GROUP_ID,

b.OBJECT_VERSION_NUMBER,

b.CREATED_BY,

b.CREATION_DATE,

b.LAST_UPDATE_DATE,

b.LAST_UPDATE_LOGIN,

b.LAST_UPDATED_BY,

b.MODULE_ID,

b.SGUID SGUID,

b.CHANGE_ASG_VISIBLE_FLAG,

b.DEFAULT_ASG_STATUS,

b.SUPPORT_ASG_STATUS_DFLT,

b.INCLUDE_CLE_FUT

FROM

PER_ACTION_TYPES_B b,

PER_ACTION_TYPES_TL t

WHERE

b.ACTION_TYPE_ID = t.ACTION_TYPE_ID AND t.LANGUAGE = USERENV('LANG')