1. Tables and Views for Project Management
  2. PJO_FINANCIAL_PROGRESS_V

PJO_FINANCIAL_PROGRESS_V

Details

  • Schema: FUSION

  • Object owner: PJO

  • Object type: VIEW

Columns

Name

PROJECT_PROGRESS_ID

PROJECT_ID

STRUCTURE_TYPE

STRUCTURE_VERSION_ID

PROJ_ELEMENT_ID

ELEMENT_VERSION_ID

AS_OF_DATE

OBJECT_TYPE

OBJECT_ID

PERCENT_COMPLETE

PUBLISHED_FLAG

PROGRESS_PERIOD

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

PROJECT_PROGRESS_ID,

PROJECT_ID ,

STRUCTURE_TYPE ,

STRUCTURE_VERSION_ID,

PROJ_ELEMENT_ID ,

ELEMENT_VERSION_ID ,

AS_OF_DATE ,

OBJECT_TYPE ,

OBJECT_ID ,

PERCENT_COMPLETE ,

PUBLISHED_FLAG ,

PROGRESS_PERIOD ,

LAST_UPDATED_BY ,

LAST_UPDATE_DATE ,

CREATION_DATE ,

CREATED_BY ,

LAST_UPDATE_LOGIN ,

OBJECT_VERSION_NUMBER

FROM

PJO_PROJECT_PROGRESS

WHERE

PUBLISHED_FLAG <> 'N'