[Home] [Help] [Dependency Information]

VIEW: APPS.PA_PROJ_TASK_PROG_HIST_V

Object Details

Object Name:	PA_PROJ_TASK_PROG_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_TASK_PROG_HIST_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
,      STRUCTURE_NAME
,      STRUCTURE_NUMBER
,      TASK_ID
,      PARENT_TASK_ID
,      PROJ_ELEMENT_ID
,      PARENT_ELEMENT_VERSION_ID
,      ELEMENT_VERSION_ID
,      OBJECT_TYPE
,      STRUCTURE_TYPE
,      TASK_NAME
,      TASK_NUMBER
,      WBS_NUMBER
,      WBS_LEVEL
,      DISPLAY_SEQUENCE
,      MANAGER_PERSON_ID
,      MANAGER_NAME
,      MILESTONE_FLAG
,      CRITICAL_FLAG
,      SUMMARY_ELEMENT_FLAG
,      TASK_STATUS_CODE
,      TASK_STATUS_NAME
,      SYSTEM_TASK_STATUS_CODE
,      PLANNED_EFFORT
,      PLANNED_WORK_QUANTITY
,      WQ_ITEM_CODE
,      WQ_ITEM_NAME
,      WQ_UOM_CODE
,      WQ_UOM_NAME
,      AS_OF_DATE
,      PERCENT_COMPLETE_ID
,      COMPLETED_PERCENTAGE
,      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
,      INCREMENTAL_WORK_QUANTITY
,      CUMULATIVE_WORK_QUANTITY
,      BASE_PERCENT_COMPLETE
,      EFF_ROLLUP_PERCENT_COMP
,      ESTIMATED_REMAINING_EFFORT
,      PUBLISHED_BY_PARTY_ID
,      PUBLISHED_BY_NAME
,      PROGRESS_COMMENT
,      PROGRESS_OVERVIEW
,      LAST_UPDATED_DATE
,      PUBLISHED_FLAG
,      CURRENT_FLAG
,      RECORD_VERSION_NUMBER
,      BASE_PROGRESS_STATUS_CODE
,      BASE_PROGRESS_STATUS_NAME
,      WQ_ENABLED_FLAG
,      EFFORT_ENABLED_FLAG
,      BASELINE_AS_OF_DATE
,      SCHEDULE_AS_OF_DATE
,      PERCENT_COMP_ENABLED_FLAG
,      EFF_ROLLUP_PROG_STAT_CODE
,      EFF_ROLLUP_PROG_STAT_NAME
,      EFF_ROLLUP_STATUS_ICON_IND
,      PROGRESS_OUTDATED_FLAG
,      BASE_PERCENT_COMP_DERIV_CODE
,      BASELINE_START_DATE
,      BASELINE_FINISH_DATE
,      PROG_ENTRY_ENABLE_FLAG
,      PROG_ENTRY_REQ_FLAG
,      ROLLUP_PERCENT_COMPLETE_ID
,      PC_STRUCTURE_TYPE
,      ROLLUP_PROJ_ELEMENT_ID
,      PPL_ACT_EFFORT_TO_DATE
,      EQPMT_ACT_EFFORT_TO_DATE
,      TOTAL_ACT_EFFORT_TO_DATE
,      EQPMT_ETC_EFFORT
,      TOTAL_ETC_EFFORT
,      OTH_ACT_COST_TO_DATE_TC
,      OTH_ACT_COST_TO_DATE_PC
,      OTH_ACT_COST_TO_DATE_FC
,      OTH_ETC_COST_TC
,      OTH_ETC_COST_PC
,      OTH_ETC_COST_FC
,      PPL_ACT_COST_TO_DATE_TC
,      PPL_ACT_COST_TO_DATE_PC
,      PPL_ACT_COST_TO_DATE_FC
,      PPL_ETC_COST_TC
,      PPL_ETC_COST_PC
,      PPL_ETC_COST_FC
,      EQPMT_ACT_COST_TO_DATE_TC
,      EQPMT_ACT_COST_TO_DATE_PC
,      EQPMT_ACT_COST_TO_DATE_FC
,      TOTAL_ACT_COST_TO_DATE_TC
,      TOTAL_ACT_COST_TO_DATE_PC
,      TOTAL_ACT_COST_TO_DATE_FC
,      EQPMT_ETC_COST_TC
,      EQPMT_ETC_COST_PC
,      EQPMT_ETC_COST_FC
,      TOTAL_ETC_COST_TC
,      TOTAL_ETC_COST_PC
,      TOTAL_ETC_COST_FC
,      EARNED_VALUE
,      ROLLUP_CURRENT_FLAG
,      TXN_CURRENCY_CODE
,      PROG_PA_PERIOD_NAME
,      PROG_GL_PERIOD_NAME
,      STRUCTURE_VERSION_ID
,      TOTAL_ACT_RAWCOST_TO_DATE_PC
,      TOTAL_ETC_RAWCOST_PC
FROM APPS.PA_PROJ_TASK_PROG_HIST_V;

Dependencies

[top of page]

APPS

PA_OBJECT_RELATIONSHIPS

PA_PERCENT_COMPLETES

PA_PROGRESS_ROLLUP

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_PROJ_STRUCTURE_TYPES

PA_TASK_TYPES

APPS.PA_PROJ_TASK_PROG_HIST_V is not referenced by any database object