1. Tables and Views for Project Management
  2. PJF_RES_FORMATS_VL

PJF_RES_FORMATS_VL

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

RES_FORMAT_ID

PARENT_RES_TYPE_ID

RES_TYPE_ID

PARENT_RES_FORMAT_ID

RES_TYPE_ID_LEVEL1

RES_TYPE_ID_LEVEL2

RES_TYPE_ID_LEVEL3

PEOPLE_CLASS_FLAG

EQUIPMENT_CLASS_FLAG

MATERIAL_ITEM_CLASS_FLAG

FINANCIAL_ELEM_CLASS_FLAG

RESOURCE_CLASS_FLAG

RES_FORMAT_SEQ

RES_TYPE_DISP_CHARS

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

FORMAT_LEVEL

FORMAT_TOKEN

PER_RC_PREC

EQP_RC_PREC

MAT_RC_PREC

FIN_RC_PREC

PER_LEVEL_SEQ

EQP_LEVEL_SEQ

MAT_LEVEL_SEQ

FIN_LEVEL_SEQ

Query

SQL_Statement

SELECT

PJF_RES_FORMATS_B.RES_FORMAT_ID RES_FORMAT_ID,

PJF_RES_FORMATS_B.PARENT_RES_TYPE_ID PARENT_RES_TYPE_ID,

PJF_RES_FORMATS_B.RES_TYPE_ID RES_TYPE_ID,

PJF_RES_FORMATS_B.PARENT_RES_FORMAT_ID PARENT_RES_FORMAT_ID,

PJF_RES_FORMATS_B.RES_TYPE_ID_LEVEL1 RES_TYPE_ID_LEVEL1,

PJF_RES_FORMATS_B.RES_TYPE_ID_LEVEL2 RES_TYPE_ID_LEVEL2,

PJF_RES_FORMATS_B.RES_TYPE_ID_LEVEL3 RES_TYPE_ID_LEVEL3,

PJF_RES_FORMATS_B.PEOPLE_CLASS_FLAG PEOPLE_CLASS_FLAG,

PJF_RES_FORMATS_B.EQUIPMENT_CLASS_FLAG EQUIPMENT_CLASS_FLAG,

PJF_RES_FORMATS_B.MATERIAL_ITEM_CLASS_FLAG MATERIAL_ITEM_CLASS_FLAG,

PJF_RES_FORMATS_B.FINANCIAL_ELEM_CLASS_FLAG FINANCIAL_ELEM_CLASS_FLAG,

PJF_RES_FORMATS_B.RESOURCE_CLASS_FLAG RESOURCE_CLASS_FLAG,

PJF_RES_FORMATS_B.RES_FORMAT_SEQ RES_FORMAT_SEQ,

PJF_RES_FORMATS_B.RES_TYPE_DISP_CHARS RES_TYPE_DISP_CHARS,

PJF_RES_FORMATS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

PJF_RES_FORMATS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PJF_RES_FORMATS_B.CREATION_DATE CREATION_DATE,

PJF_RES_FORMATS_B.CREATED_BY CREATED_BY,

PJF_RES_FORMATS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PJF_RES_FORMATS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PJF_RES_FORMATS_TL.NAME NAME,

PJF_RES_FORMATS_TL.DESCRIPTION DESCRIPTION,

PJF_RES_FORMATS_B.FORMAT_LEVEL FORMAT_LEVEL,

PJF_RES_FORMATS_B.FORMAT_TOKEN FORMAT_TOKEN,

PJF_RES_FORMATS_B.PER_RC_PREC PER_RC_PREC,

PJF_RES_FORMATS_B.EQP_RC_PREC EQP_RC_PREC,

PJF_RES_FORMATS_B.MAT_RC_PREC MAT_RC_PREC,

PJF_RES_FORMATS_B.FIN_RC_PREC FIN_RC_PREC,

PJF_RES_FORMATS_B.PER_LEVEL_SEQ PER_LEVEL_SEQ,

PJF_RES_FORMATS_B.EQP_LEVEL_SEQ EQP_LEVEL_SEQ,

PJF_RES_FORMATS_B.MAT_LEVEL_SEQ MAT_LEVEL_SEQ,

PJF_RES_FORMATS_B.FIN_LEVEL_SEQ FIN_LEVEL_SEQ

FROM

PJF_RES_FORMATS_B,

PJF_RES_FORMATS_TL

WHERE

PJF_RES_FORMATS_B.RES_FORMAT_ID = PJF_RES_FORMATS_TL.RES_FORMAT_ID AND PJF_RES_FORMATS_TL.LANGUAGE = USERENV('lang')