1. Tables and Views for Project Management
  2. PJF_EVENT_TYPES_VL

PJF_EVENT_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

EVENT_TYPE_ID

START_DATE_ACTIVE

END_DATE_ACTIVE

REVENUE_FLAG

INVOICE_FLAG

RECLASSIFY_FLAG

PREDEFINED_FLAG

REVENUE_CATEGORY_CODE

EVENT_TYPE_NAME

DESCRIPTION

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ALLOW_ADJUSTMENT_FLAG

MIGRATION_FLAG

ALLOW_ITEM_FLAG

PREPAYMENT_INDICATOR

Query

SQL_Statement

SELECT

PJF_EVENT_TYPES_B.EVENT_TYPE_ID EVENT_TYPE_ID,

PJF_EVENT_TYPES_B.START_DATE_ACTIVE START_DATE_ACTIVE,

PJF_EVENT_TYPES_B.END_DATE_ACTIVE END_DATE_ACTIVE,

PJF_EVENT_TYPES_B.REVENUE_FLAG REVENUE_FLAG,

PJF_EVENT_TYPES_B.INVOICE_FLAG INVOICE_FLAG,

PJF_EVENT_TYPES_B.RECLASSIFY_FLAG RECLASSIFY_FLAG,

PJF_EVENT_TYPES_B.PREDEFINED_FLAG PREDEFINED_FLAG,

PJF_EVENT_TYPES_B.REVENUE_CATEGORY_CODE REVENUE_CATEGORY_CODE,

PJF_EVENT_TYPES_TL.EVENT_TYPE_NAME EVENT_TYPE_NAME,

PJF_EVENT_TYPES_TL.DESCRIPTION DESCRIPTION,

PJF_EVENT_TYPES_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

PJF_EVENT_TYPES_B.ATTRIBUTE1 ATTRIBUTE1,

PJF_EVENT_TYPES_B.ATTRIBUTE2 ATTRIBUTE2,

PJF_EVENT_TYPES_B.ATTRIBUTE3 ATTRIBUTE3,

PJF_EVENT_TYPES_B.ATTRIBUTE4 ATTRIBUTE4,

PJF_EVENT_TYPES_B.ATTRIBUTE5 ATTRIBUTE5,

PJF_EVENT_TYPES_B.ATTRIBUTE6 ATTRIBUTE6,

PJF_EVENT_TYPES_B.ATTRIBUTE7 ATTRIBUTE7,

PJF_EVENT_TYPES_B.ATTRIBUTE8 ATTRIBUTE8,

PJF_EVENT_TYPES_B.ATTRIBUTE9 ATTRIBUTE9,

PJF_EVENT_TYPES_B.ATTRIBUTE10 ATTRIBUTE10,

PJF_EVENT_TYPES_B.ATTRIBUTE11 ATTRIBUTE11,

PJF_EVENT_TYPES_B.ATTRIBUTE12 ATTRIBUTE12,

PJF_EVENT_TYPES_B.ATTRIBUTE13 ATTRIBUTE13,

PJF_EVENT_TYPES_B.ATTRIBUTE14 ATTRIBUTE14,

PJF_EVENT_TYPES_B.ATTRIBUTE15 ATTRIBUTE15,

PJF_EVENT_TYPES_B.CREATION_DATE CREATION_DATE,

PJF_EVENT_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PJF_EVENT_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

PJF_EVENT_TYPES_B.CREATED_BY CREATED_BY,

PJF_EVENT_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PJF_EVENT_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PJF_EVENT_TYPES_B.ALLOW_ADJUSTMENT_FLAG ALLOW_ADJUSTMENT_FLAG,

PJF_EVENT_TYPES_B.MIGRATION_FLAG MIGRATION_FLAG,

PJF_EVENT_TYPES_B.ALLOW_ITEM_FLAG ALLOW_ITEM_FLAG,

PJF_EVENT_TYPES_B.PREPAYMENT_INDICATOR PREPAYMENT_INDICATOR

FROM

PJF_EVENT_TYPES_B,

PJF_EVENT_TYPES_TL

WHERE

PJF_EVENT_TYPES_B.EVENT_TYPE_ID = PJF_EVENT_TYPES_TL.EVENT_TYPE_ID AND PJF_EVENT_TYPES_TL.LANGUAGE = USERENV('LANG')