1. Tables and Views for Project Management
  2. PJF_ACTION_OBJ_REASONS_VL

PJF_ACTION_OBJ_REASONS_VL

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

OBJECT_CODE

REASON_CODE

REASON

ACTION_CODE

REASON_TYPE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

b.OBJECT_CODE,

b.REASON_CODE,

tl.REASON,

b.ACTION_CODE,

b.REASON_TYPE,

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_reasons_b b,

pjf_action_obj_reasons_tl tl

WHERE

b.OBJECT_CODE = tl.OBJECT_CODE

AND b.REASON_CODE = tl.REASON_CODE

AND b.REASON_TYPE = tl.REASON_TYPE

AND tl.LANGUAGE = USERENV('LANG')