[Home] [Help] [Dependency Information]

VIEW: APPS.PA_TASK_PROGRESS_V

Object Details

Object Name:	PA_TASK_PROGRESS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_TASK_PROGRESS_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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

SELECT PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      LONG_NAME
,      TASK_ID
,      PROJ_ELEMENT_ID
,      ELEMENT_VERSION_ID
,      OBJECT_TYPE
,      TASK_NAME
,      TASK_NUMBER
,      WBS_NUMBER
,      WBS_LEVEL
,      TASK_MANAGER_PERSON_ID
,      TASK_MANAGER_NAME
,      ORGANIZATION_ID
,      DISPLAY_SEQUENCE
,      MILESTONE_FLAG
,      CRITICAL_FLAG
,      SUMMARY_ELEMENT_FLAG
,      PRIORITY_CODE
,      PRIORITY_DESCRIPTION
,      PRIORITY_SORT
,      STATUS_CODE
,      STATUS_DESCRIPTION
,      SYSTEM_TASK_STATUS_CODE
,      PLANNED_EFFORT
,      PLANNED_WORK_QUANTITY
,      WORK_ITEM_CODE
,      WORK_ITEM_DESCRIPTION
,      UOM_CODE
,      UOM_DESCRIPTION
,      AS_OF_DATE
,      PERCENT_COMPLETE_ID
,      COMPLETED_PERCENTAGE
,      PROGRESS_STATUS_CODE
,      PROGRESS_STATUS_DESC
,      SYSTEM_PROGRESS_STAT_CODE
,      PROGRESS_STATUS_WEIGHT
,      STATUS_ICON_IND
,      STATUS_ICON_ACTIVE_IND
,      BASELINE_START_DATE
,      BASELINE_FINISH_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_FINISH_DATE
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      ESTIMATED_START_DATE
,      ESTIMATED_FINISH_DATE
,      INCREMENTAL_WORK_QTY
,      CUMULATIVE_WORK_QTY
,      BASE_PERCENT_COMPLETE
,      EFF_ROLLUP_PERCENT_COMP
,      PUBLISHED_BY_PARTY_ID
,      PUBLISHED_BY_NAME
,      PROGRESS_COMMENT
,      PROGRESS_OVERVIEW
,      LAST_UPDATED_DATE
,      PUBLISHED_FLAG
,      CURRENT_FLAG
,      PROCESS_STATUS_NAME
,      PROCESS_STATUS_CODE
,      RECORD_VERSION_NUMBER
,      EST_SCH_START_VAR
,      EST_SCH_FINISH_VAR
,      ACT_SCH_START_VAR
,      ACT_SCH_FINISH_VAR
,      SCH_BASE_START_VAR
,      SCH_BASE_FINISH_VAR
,      BASE_PROGRESS_STATUS_CODE
,      EFF_ROLLUP_PROG_STAT_CODE
,      PROG_ENTRY_ENABLE_FLAG
,      PROG_ENTRY_REQ_FLAG
,      ELEM_ROW_ID
,      NEXT_PROGRESS_DUE_DATE
,      OPEN_ISSUES
,      OPEN_CHANGE_DOCUMENTS
,      DAYS_UNTIL_SCHEDULED_FINISH
,      TASK_TYPE
,      OPEN_CHANGE_REQUESTS
,      OPEN_CHANGE_ORDERS
,      PHASE
,      ACTUAL_COST
,      ACTUAL_EFFORT
,      ACTUAL_EQUIP_EFFORT
,      ACTUAL_PEOPLE_EFFORT
,      ETC_COST
,      ETC_EFFORT
,      ETC_EQUIP_EFFORT
,      EST_REMAINING_EFFORT
,      CONSTRAINT_DATE
,      CONSTRAINT_TYPE
,      STRUCTURE_VERSION_ID
,      PROJECT_CURRENCY_CODE
,      PROJFUNC_CURRENCY_CODE
FROM APPS.PA_TASK_PROGRESS_V;

Dependencies

[top of page]

APPS

PA_CONTROL_ITEMS_UTILS - show dependent code

PA_LOOKUPS

PA_PERCENT_COMPLETES

PA_PROGRESS_ROLLUP

PA_PROGRESS_UTILS - show dependent code

PA_PROJECTS_ALL

PA_PROJECT_STATUSES

PA_PROJ_ELEMENTS

PA_PROJ_ELEMENTS_UTILS - show dependent code

PA_PROJ_ELEMENT_VERSIONS

PA_PROJ_ELEM_VER_SCHEDULE

PA_PROJ_ELEM_VER_STRUCTURE

PA_PROJ_STRUCTURE_TYPES

PA_TASK_TYPES

APPS.PA_TASK_PROGRESS_V is not referenced by any database object