1. Tables and Views for Project Management
  2. PJB_XLA_EVENTS_REF_V

PJB_XLA_EVENTS_REF_V

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: VIEW

Columns

Name

BILLING_EVENT_ID

BILLING_EVENT_TYPE

BILLING_EVENT_TYPE_ID

EVENT_RECLASSIFICATION_FLAG

EVENT_ADJUSTED_EVENT_ID

EVENT_REVERSE_ACCRUAL_FLAG

EVENT_ORGANIZATION_ID

EVENT_ORGANIZATION_NAME

EVENT_ORG_COMPANY

EVENT_ORG_COST_CENTER

EVENT_TYPE_CODE

EVENT_DESCRIPTION

EVENT_ATTRIBUTE_CATEGORY

EVENT_ATTRIBUTE1

EVENT_ATTRIBUTE2

EVENT_ATTRIBUTE3

EVENT_ATTRIBUTE4

EVENT_ATTRIBUTE5

EVENT_ATTRIBUTE6

EVENT_ATTRIBUTE7

EVENT_ATTRIBUTE8

EVENT_ATTRIBUTE9

EVENT_ATTRIBUTE10

EVENT_REFERENCE1

EVENT_REFERENCE2

EVENT_REFERENCE3

EVENT_REFERENCE4

EVENT_REFERENCE5

EVENT_REFERENCE6

EVENT_REFERENCE7

EVENT_REFERENCE8

EVENT_REFERENCE9

EVENT_REFERENCE10

EVENT_NUMBER

APPLICATION_SOURCE

EVENT_SOURCE

BILLING_EVENT_CREATION_DATE

EVENT_CREATED_BY

EVENT_LAST_UPDATED_DATE

EVENT_LAST_UPDATED_BY

EVENT_COMPLETION_DATE

Query

SQL_Statement

SELECT

Evt.EVENT_ID BILLING_EVENT_ID,

Evt.EVENT_TYPE_ID BILLING_EVENT_TYPE,

Evt.EVENT_TYPE_ID BILLING_EVENT_TYPE_ID,

'N' EVENT_RECLASSIFICATION_FLAG,

Evt.ADJUSTED_EVENT_ID EVENT_ADJUSTED_EVENT_ID,

Evt.REVERSE_ACCRUAL_FLAG EVENT_REVERSE_ACCRUAL_FLAG,

Evt.ORGANIZATION_ID EVENT_ORGANIZATION_ID,

Evt.ORGANIZATION_ID EVENT_ORGANIZATION_NAME,

pjc_accounting_pvt.get_company_info(Evt.ORGANIZATION_ID) EVENT_ORG_COMPANY,

pjc_accounting_pvt.get_costcenter_info(Evt.ORGANIZATION_ID) EVENT_ORG_COST_CENTER,

Evt.EVENT_TYPE_CODE EVENT_TYPE_CODE,

Evt.EVENT_DESC EVENT_DESCRIPTION,

Evt.ATTRIBUTE_CATEGORY EVENT_ATTRIBUTE_CATEGORY,

Evt.ATTRIBUTE1 EVENT_ATTRIBUTE1,

Evt.ATTRIBUTE2 EVENT_ATTRIBUTE2,

Evt.ATTRIBUTE3 EVENT_ATTRIBUTE3,

Evt.ATTRIBUTE4 EVENT_ATTRIBUTE4,

Evt.ATTRIBUTE5 EVENT_ATTRIBUTE5,

Evt.ATTRIBUTE6 EVENT_ATTRIBUTE6,

Evt.ATTRIBUTE7 EVENT_ATTRIBUTE7,

Evt.ATTRIBUTE8 EVENT_ATTRIBUTE8,

Evt.ATTRIBUTE9 EVENT_ATTRIBUTE9,

Evt.ATTRIBUTE10 EVENT_ATTRIBUTE10,

Evt.REFERENCE1 EVENT_REFERENCE1,

Evt.REFERENCE2 EVENT_REFERENCE2,

Evt.REFERENCE3 EVENT_REFERENCE3,

Evt.REFERENCE4 EVENT_REFERENCE4,

Evt.REFERENCE5 EVENT_REFERENCE5,

Evt.REFERENCE6 EVENT_REFERENCE6,

Evt.REFERENCE7 EVENT_REFERENCE7,

Evt.REFERENCE8 EVENT_REFERENCE8,

Evt.REFERENCE9 EVENT_REFERENCE9,

Evt.REFERENCE10 EVENT_REFERENCE10,

Evt.EVENT_NUM EVENT_NUMBER,

Evt.SOURCENAME APPLICATION_SOURCE,

Evt.SOURCEREF EVENT_SOURCE,

trunc(Evt.CREATION_DATE) BILLING_EVENT_CREATION_DATE,

Evt.CREATED_BY EVENT_CREATED_BY,

trunc(Evt.LAST_UPDATE_DATE) EVENT_LAST_UPDATED_DATE,

Evt.LAST_UPDATED_BY EVENT_LAST_UPDATED_BY,

Evt.COMPLETION_DATE EVENT_COMPLETION_DATE

FROM

PJB_BILLING_EVENTS Evt