[Home] [Help] [Dependency Information]

VIEW: APPS.PA_PROGRESS_HIST_DET_V

Object Details

Object Name:	PA_PROGRESS_HIST_DET_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROGRESS_HIST_DET_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 PERCENT_COMPLETE_ID
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      LONG_NAME
,      TASK_ID
,      PROJ_ELEMENT_ID
,      PARENT_TASK_ID
,      ELEMENT_VERSION_ID
,      PARENT_ELEMENT_VERSION_ID
,      OBJECT_TYPE
,      STRUCTURE_TYPE
,      TASK_NAME
,      TASK_NUMBER
,      TASK_MANAGER_PERSON_ID
,      TASK_MANAGER_NAME
,      WBS_LEVEL
,      WBS_NUMBER
,      MILESTONE_FLAG
,      CRITICAL_FLAG
,      PRIORITY_CODE
,      PRIORITY_DESCRIPTION
,      LATEST_EFF_PUBLISHED_FLAG
,      AS_OF_DATE
,      PROGRESS_OVERVIEW
,      PROGRESS_COMMENT
,      PROGRESS_STATUS_CODE
,      PROGRESS_STATUS_NAME
,      SYSTEM_PROGRESS_STAT_CODE
,      STATUS_ICON_IND
,      STATUS_ICON_ACTIVE_IND
,      SCHEDULED_START_DATE
,      SCHEDULED_FINISH_DATE
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      ESTIMATED_START_DATE
,      ESTIMATED_FINISH_DATE
,      COMPLETED_PERCENTAGE
,      LAST_UPDATED_DATE
,      PUBLISHED_BY_PARTY_ID
,      PUBLISHED_BY_PARTY_NAME
,      CURRENT_FLAG
,      PUBLISHED_FLAG
,      SUMMARY_ELEMENT_FLAG
,      RECORD_VERSION_NUMBER
,      TASK_STATUS_CODE
,      TASK_STATUS_NAME
,      SYSTEM_TASK_STATUS_CODE
,      PLANNED_WORK_QUANTITY
,      INCREMENTAL_WORK_QUANTITY
,      CUMULATIVE_WORK_QUANTITY
,      PLANNED_EFFORT
,      ESTIMATED_REMAINING_EFFORT
,      BASE_PERCENT_COMPLETE
,      WQ_ENABLED_FLAG
,      EFFORT_ENABLED_FLAG
,      BASE_PERCENT_COMP_DERIV_CODE
,      WQ_ACTUAL_ENTRY_CODE
,      BASELINE_START_DATE
,      BASELINE_FINISH_DATE
,      BASELINE_AS_OF_DATE
,      SCHEDULE_AS_OF_DATE
,      EFF_ROLLUP_PERCENT_COMP
,      ROLLUP_REC_VER_NUMBER
,      WQ_ITEM_CODE
,      WQ_ITEM_NAME
,      WQ_UOM_CODE
,      WQ_UOM_NAME
,      BASE_PROGRESS_STATUS_CODE
,      BASE_PROGRESS_STATUS_NAME
,      EFF_ROLLUP_PROG_STAT_CODE
,      EFF_ROLLUP_PROG_STAT_NAME
,      NEXT_PROGRESS_DUE_DATE
,      DEFAULT_AS_OF_DATE
,      PERCENT_COMP_ENABLED_FLAG
,      PROG_ENTRY_ENABLE_FLAG
,      PROG_ENTRY_REQ_FLAG
,      ELEM_ROW_ID
,      PERCENT_COMPLETE_COST
,      PERCENT_COMPLETE_EFFORT
,      PERCENT_SPENT_COST
,      PERCENT_SPENT_EFFORT
,      ACTUAL_COST
,      ACTUAL_EFFORT
,      BASELINE_COST
,      BASELINED_EFFORT
,      DAYS_UNTIL_PROGRESS_DUE
,      DAYS_UNTIL_START
,      EARNED_VALUE
,      EST_AT_COMPLETION_COST
,      EST_AT_COMPLETION_EFFORT
,      EST_BAS_START_VAR
,      EST_BAS_FINISH_VAR
,      ETC_COST
,      ETC_EFFORT
,      ETC_WORK_QUANTITY
,      PLANNED_COST
,      PLANNED_COST_PER_UNIT
,      PREDECESSORS
,      RESOURCES
,      SCH_PERFORMANCE_INDEX
,      TO_COMPLETE_PERFORMANCE_INDEX
,      UNIT_OF_MEASURE
,      VAR_AT_COMPLETION_COST
,      VAR_AT_COMPLETION_EFFORT
,      WORK_TYPE
,      BCWS
,      PROJECT_CURRENCY_CODE
,      COST_PERFORMANCE_INDEX
,      SCH_AT_COMPLETION
,      ESTIMATE_AS_OF_DATE
,      ACTUAL_AS_OF_DATE
,      STRUCTURE_VERSION_ID
,      ACTUAL_SCH_FINISH_VAR
,      ACTUAL_SCH_START_VAR
,      ACTUAL_WORK_QUANTITY
,      COLUMN_NAME
,      DAYS_UNTIL_FINISH
,      ESTIMATED_SCH_FINISH_VAR
,      SCH_BASELINE_FINISH_VAR
,      SCH_BASELINE_START_VAR
,      LATE_START_DATE
,      LATE_FINISH_DATE
,      PLANNED_BASELINE_EFFORT_VAR
,      PLANNED_BASELINE_COST_VAR
,      BASELINE_SCHEDULE_VAR
,      VARIANCE_FROM_SCHEDULE
,      EAC_PLANNED_EFFORT_VAR
,      ACTUAL_EFFORT_THIS_PERIOD
,      PROGRESS_ROLLUP_METHOD
,      LINKED_TASK_FLAG
,      LINKED_TASK_FLAG_SHARED
,      SELF_ACTUAL_COST
,      SELF_ACTUAL_EFFORT
,      SELF_ETC_COST
,      SELF_ETC_EFFORT
FROM APPS.PA_PROGRESS_HIST_DET_V;

Dependencies

[top of page]

APPS

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_PROGRESS_ATTR

PA_RELATIONSHIP_UTILS - show dependent code

PA_TASK_TYPES

PJI_FM_XBS_ACCUM_TMP1

APPS.PA_PROGRESS_HIST_DET_V is not referenced by any database object