DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_PROJ_PROGRESS_REPORTS#

Object Details
Object Name: PA_PROJ_PROGRESS_REPORTS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER
Yes
TASK_ID NUMBER
Yes
PROGRESS_STATUS_CODE VARCHAR2 (30) Yes
SHORT_DESCRIPTION VARCHAR2 (240)
PROGRESS_ASOF_DATE DATE
Yes
LONG_DESCRIPTION VARCHAR2 (4000)
ISSUES VARCHAR2 (4000)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
ESTIMATED_START_DATE DATE

ESTIMATED_END_DATE DATE

ACTUAL_START_DATE DATE

ACTUAL_END_DATE DATE

PERCENT_COMPLETE NUMBER

ESTIMATE_TO_COMPLETE NUMBER

UNIT_TYPE VARCHAR2 (30)
WF_STATUS_CODE VARCHAR2 (10)
WF_ITEM_TYPE VARCHAR2 (30)
WF_ITEM_KEY NUMBER

WF_PROCESS VARCHAR2 (240)
PROGRESS_REPORT_ID NUMBER (15)
RECORD_VERSION_NUMBER NUMBER (15)
PLANNED_ACTIVITIES VARCHAR2 (4000)
REPORT_STATUS VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT_ID
,      TASK_ID
,      PROGRESS_STATUS_CODE
,      SHORT_DESCRIPTION
,      PROGRESS_ASOF_DATE
,      LONG_DESCRIPTION
,      ISSUES
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ESTIMATED_START_DATE
,      ESTIMATED_END_DATE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      PERCENT_COMPLETE
,      ESTIMATE_TO_COMPLETE
,      UNIT_TYPE
,      WF_STATUS_CODE
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      WF_PROCESS
,      PROGRESS_REPORT_ID
,      RECORD_VERSION_NUMBER
,      PLANNED_ACTIVITIES
,      REPORT_STATUS
FROM PA.PA_PROJ_PROGRESS_REPORTS#;

Dependencies

[top of page]

PA.PA_PROJ_PROGRESS_REPORTS# references the following:

SchemaPA
TablePA_PROJ_PROGRESS_REPORTS
PA.PA_PROJ_PROGRESS_REPORTS# is referenced by following:

SchemaAPPS
SynonymPA_PROJ_PROGRESS_REPORTS