1. Tables and Views for Project Management
  2. PJF_ACTION_OBJ_ACTIONS_VL

PJF_ACTION_OBJ_ACTIONS_VL

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

OBJECT_CODE

ACTION_CODE

ACTION_NAME

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

b.OBJECT_CODE,

b.ACTION_CODE,

tl.ACTION_NAME,

b.CREATED_BY,

b.CREATION_DATE,

b.LAST_UPDATED_BY,

b.LAST_UPDATE_DATE,

b.LAST_UPDATE_LOGIN,

b.OBJECT_VERSION_NUMBER

FROM

pjf_action_obj_actions_b b,

pjf_action_obj_actions_tl tl

WHERE

b.OBJECT_CODE = tl.OBJECT_CODE

AND b.ACTION_CODE = tl.ACTION_CODE

AND tl.LANGUAGE = USERENV('LANG')