1. Tables and Views for SCM
  2. DOO_PROJECTS_V

DOO_PROJECTS_V

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: VIEW

Columns

Name

DOO_ORDER_PRJ_ID

PARENT_ENTITY_ID

PARENT_ENTITY_CODE

REF_DOO_ORDER_PRJ_ID

MODIFIED_FLAG

PJC_CONTEXT_CATEGORY

PJC_PROJECT_ID

PJC_TASK_ID

PJC_EXPENDITURE_TYPE_ID

PJC_EXPENDITURE_ITEM_DATE

PJC_ORGANIZATION_ID

PJC_BILLABLE_FLAG

PJC_CAPITALIZABLE_FLAG

PJC_WORK_TYPE_ID

PJC_CONTRACT_ID

PJC_CONTRACT_LINE_ID

PJC_FUNDING_ALLOCATION_ID

PJC_RESERVED_ATTRIBUTE1

PJC_RESERVED_ATTRIBUTE2

PJC_RESERVED_ATTRIBUTE3

PJC_RESERVED_ATTRIBUTE4

PJC_RESERVED_ATTRIBUTE5

PJC_RESERVED_ATTRIBUTE6

PJC_RESERVED_ATTRIBUTE7

PJC_RESERVED_ATTRIBUTE8

PJC_RESERVED_ATTRIBUTE9

PJC_RESERVED_ATTRIBUTE10

PJC_USER_DEF_ATTRIBUTE1

PJC_USER_DEF_ATTRIBUTE2

PJC_USER_DEF_ATTRIBUTE3

PJC_USER_DEF_ATTRIBUTE4

PJC_USER_DEF_ATTRIBUTE5

PJC_USER_DEF_ATTRIBUTE6

PJC_USER_DEF_ATTRIBUTE7

PJC_USER_DEF_ATTRIBUTE8

PJC_USER_DEF_ATTRIBUTE9

PJC_USER_DEF_ATTRIBUTE10

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT DOO_ORDER_PRJ_ID ,

PARENT_ENTITY_ID ,

PARENT_ENTITY_CODE ,

REF_DOO_ORDER_PRJ_ID ,

MODIFIED_FLAG ,

PJC_CONTEXT_CATEGORY ,

PJC_PROJECT_ID ,

PJC_TASK_ID ,

PJC_EXPENDITURE_TYPE_ID ,

PJC_EXPENDITURE_ITEM_DATE ,

PJC_ORGANIZATION_ID ,

PJC_BILLABLE_FLAG ,

PJC_CAPITALIZABLE_FLAG ,

PJC_WORK_TYPE_ID ,

PJC_CONTRACT_ID ,

PJC_CONTRACT_LINE_ID ,

PJC_FUNDING_ALLOCATION_ID ,

PJC_RESERVED_ATTRIBUTE1 ,

PJC_RESERVED_ATTRIBUTE2 ,

PJC_RESERVED_ATTRIBUTE3 ,

PJC_RESERVED_ATTRIBUTE4 ,

PJC_RESERVED_ATTRIBUTE5 ,

PJC_RESERVED_ATTRIBUTE6 ,

PJC_RESERVED_ATTRIBUTE7 ,

PJC_RESERVED_ATTRIBUTE8 ,

PJC_RESERVED_ATTRIBUTE9 ,

PJC_RESERVED_ATTRIBUTE10 ,

PJC_USER_DEF_ATTRIBUTE1 ,

PJC_USER_DEF_ATTRIBUTE2 ,

PJC_USER_DEF_ATTRIBUTE3 ,

PJC_USER_DEF_ATTRIBUTE4 ,

PJC_USER_DEF_ATTRIBUTE5 ,

PJC_USER_DEF_ATTRIBUTE6 ,

PJC_USER_DEF_ATTRIBUTE7 ,

PJC_USER_DEF_ATTRIBUTE8 ,

PJC_USER_DEF_ATTRIBUTE9 ,

PJC_USER_DEF_ATTRIBUTE10 ,

CREATED_BY ,

CREATION_DATE ,

LAST_UPDATED_BY ,

LAST_UPDATE_DATE ,

LAST_UPDATE_LOGIN ,

OBJECT_VERSION_NUMBER from DOO_PROJECTS