PJF_PROJECT_STATUSES_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name

PROJECT_STATUS_CODE PROJECT_STATUS_NAME PROJECT_SYSTEM_STATUS_CODE DESCRIPTION START_DATE_ACTIVE END_DATE_ACTIVE PREDEFINED_FLAG STARTING_STATUS_FLAG ENABLE_BP_FLAG BPEL_ITEM_TYPE BPEL_PROCESS BP_SUCCESS_STATUS_CODE BP_FAILURE_STATUS_CODE SOURCE_STATUS_CODE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 STATUS_TYPE NEXT_ALLOWABLE_STATUS_FLAG STATUS_ICON_IND STATUS_ICON_ACTIVE_IND PROJECT_STATUS_WEIGHT LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT base.PROJECT_STATUS_CODE, tl.PROJECT_STATUS_NAME, base.PROJECT_SYSTEM_STATUS_CODE, tl.DESCRIPTION, base.START_DATE_ACTIVE, base.END_DATE_ACTIVE, base.PREDEFINED_FLAG, base.STARTING_STATUS_FLAG, base.ENABLE_BP_FLAG, base.BPEL_ITEM_TYPE, base.BPEL_PROCESS, base.BP_SUCCESS_STATUS_CODE, base.BP_FAILURE_STATUS_CODE, base.SOURCE_STATUS_CODE, base.ATTRIBUTE_CATEGORY, base.ATTRIBUTE1, base.ATTRIBUTE2, base.ATTRIBUTE3, base.ATTRIBUTE4, base.ATTRIBUTE5, base.ATTRIBUTE6, base.ATTRIBUTE7, base.ATTRIBUTE8, base.ATTRIBUTE9, base.ATTRIBUTE10, base.ATTRIBUTE11, base.ATTRIBUTE12, base.ATTRIBUTE13, base.ATTRIBUTE14, base.ATTRIBUTE15, base.STATUS_TYPE, base.NEXT_ALLOWABLE_STATUS_FLAG, base.STATUS_ICON_IND, base.STATUS_ICON_ACTIVE_IND, base.PROJECT_STATUS_WEIGHT, base.LAST_UPDATE_DATE, base.LAST_UPDATED_BY, base.CREATION_DATE, base.CREATED_BY, base.LAST_UPDATE_LOGIN, base.OBJECT_VERSION_NUMBER FROM PJF_PROJECT_STATUSES_B base, PJF_PROJECT_STATUSES_TL tl WHERE base.project_status_code = tl.project_status_code AND tl.language = userenv('LANG')