[Home] [Help] [Dependency Information]

VIEW: APPS.PA_TASK_ASSIGNMENTS_AMG_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view provides progress data for task assignments.

[View Source]

Columns

Query Text

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

SELECT ACT_SCH_FINISH_VAR
,      ACT_SCH_START_VAR
,      ACTUAL_COST
,      ACTUAL_EFFORT
,      ACTUAL_FINISH_DATE
,      ACTUAL_START_DATE
,      ACTUAL_WORK_QUANTITY
,      AS_OF_DATE
,      BASELINE_COST
,      BASELINE_FINISH_DATE
,      BASELINE_START_DATE
,      BASELINED_EFFORT
,      DAYS_UNTIL_PROGRESS_DUE
,      DAYS_UNTIL_SCHEDULED_FINISH
,      DAYS_UNTIL_START
,      EARNED_VALUE
,      ETC_COST
,      EST_AT_COMPLETION_EFFORT
,      EST_BAS_FINISH_VAR
,      EST_BAS_START_VAR
,      EST_REMAINING_EFFORT
,      EST_SCH_FINISH_VAR
,      ESTIMATED_FINISH_DATE
,      ESTIMATED_START_DATE
,      ETC_COST_TC
,      ETC_EFFORT
,      ETC_WORK_QUANTITY
,      NEXT_PROGRESS_DUE_DATE
,      DEFAULT_AS_OF_DATE
,      PERCENT_COMPLETE_COST
,      PERCENT_COMPLETE_EFFORT
,      PERCENT_COMPLETE_ID
,      PERCENT_SPENT_COST
,      PERCENT_SPENT_EFFORT
,      PLANNED_COST
,      PLANNED_COST_PER_UNIT
,      PLANNED_EFFORT
,      PLANNED_WORK_QUANTITY
,      PREDECESSORS
,      PRIORITY_CODE
,      SCH_BASE_FINISH_VAR
,      SCH_BASE_START_VAR
,      SCH_PERFORMANCE_INDEX
,      ASSIGNMENT_END_DATE
,      ASSIGNMENT_START_DATE
,      TASK_ID
,      TASK_MANAGER_NAME
,      TASK_MANAGER_PERSON_ID
,      TASK_NAME
,      TASK_NUMBER
,      TASK_TYPE
,      TO_COMPLETE_PERFORMANCE_INDEX
,      UNIT_OF_MEASURE
,      VAR_AT_COMPLETION_COST
,      VAR_AT_COMPLETION_EFFORT
,      WBS_NUMBER
,      WORK_ITEM_CODE
,      WORK_TYPE
,      RESOURCE_ASSIGNMENT_ID
,      CURRENT_FLAG
,      DISPLAY_SEQUENCE
,      ELEMENT_VERSION_ID
,      LONG_NAME
,      OBJECT_TYPE
,      PROJ_ELEMENT_ID
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      PUBLISHED_BY_NAME
,      PUBLISHED_BY_PARTY_ID
,      PUBLISHED_FLAG
,      RECORD_VERSION_NUMBER
,      UOM_CODE
,      UOM_DESCRIPTION
,      WBS_LEVEL
,      WORK_ITEM_DESCRIPTION
,      TXN_CURRENCY_CODE
,      EFFORT_ENABLED_FLAG
,      PROG_ENTRY_ENABLE_FLAG
,      RESOURCE_ALIAS
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_CLASS_CODE
,      RESOURCE_CLASS
,      RBS_ELEMENT_ID
,      PERSON_ID
,      PROGRESS_COMMENT
,      PROGRESS_OVERVIEW
,      PRIORITY_DESCRIPTION
,      SUMMARY_ELEMENT_FLAG
,      RESOURCES
,      RATE_BASED_FLAG
,      ACTUAL_QUANTITY
,      ACTUAL_COST_THIS_PERIOD
,      LATEST_PROGRESS_DATE
,      STRUCTURE_VERSION_ID
,      SPREAD_CURVE_ID
,      SPREAD_CURVE_NAME
,      ASSIGNMENT_DESCRIPTION
,      PLANNED_BUR_COST_PROJFUNC
,      PLANNED_QUANTITY
,      ROLE_NAME
,      PM_RES_ASSIGNMENT_REFERENCE
,      PM_PROJECT_REFERENCE
,      PM_PRODUCT_CODE
,      PM_TASK_REFERENCE
,      RESOURCE_CLASS_FLAG
,      UNPLANNED_FLAG
,      RESOURCE_NAME
,      RES_TYPE_CODE
,      BOM_RESOURCE_ID
,      JOB_ID
,      PERSON_TYPE_CODE
,      NON_LABOR_RESOURCE
,      INVENTORY_ITEM_ID
,      RESOURCE_CLASS_ID
,      ITEM_CATEGORY_ID
,      FINANCIAL_CATEGORY_NAME
,      FC_RES_TYPE_CODE
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      EVENT_TYPE
,      REVENUE_CATEGORY_CODE
,      ORGANIZATION_NAME
,      ORGANIZATION_ID
,      SUPPLIER_NAME
,      SUPPLIER_ID
,      TEAM_ROLE
,      INCURRED_BY_RESOURCE_NAME
,      INCUR_BY_ROLE_ID
,      INCUR_BY_RES_CLASS_CODE
,      INCURRED_BY_RES_FLAG
,      PROCURE_RESOURCE_FLAG
,      ROLE_ID
,      PLANNING_START_DATE
,      PLANNING_END_DATE
,      USE_TASK_SCHEDULE_FLAG
,      DELAY
,      DURATION
,      MANUFACTURING_COST_TYPE
,      MFC_COST_TYPE_ID
,      ETC_METHOD_NAME
,      ETC_METHOD_CODE
,      BILLABLE_WORK_PERCENT
,      PLANNED_BUR_COST_PROJ_CUR
,      PLANNED_RAW_COST_TXN_CUR
,      PLANNED_RAW_COST_PROJ_CUR
,      PLANNED_RAW_COST_PROJFUNC
,      ACT_BUR_COST_TXN_CUR
,      ACT_BUR_COST_PROJ_CUR
,      ACT_BUR_COST_PROJFUNC
,      ACT_RAW_COST_TXN_CUR
,      ACT_RAW_COST_PROJ_CUR
,      ACT_RAW_COST_PROJFUNC
,      AVG_RAW_COST_RATE
,      AVG_BUR_COST_RATE
,      SCHEDULED_DELAY
FROM APPS.PA_TASK_ASSIGNMENTS_AMG_V;

Dependencies

[top of page]

APPS

PA_EXPENDITURES_UTILS - show dependent code

PA_FIN_PLAN_UTILS - show dependent code

PA_LOOKUPS

PA_PERCENT_COMPLETES

PA_PLANNING_ELEMENT_UTILS - show dependent code

PA_PLANNING_RESOURCE_UTILS - show dependent code

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_PROJ_STRUCTURE_TYPES

PA_RELATIONSHIP_UTILS - show dependent code

PA_ROLE_JOB_BG_UTILS - show dependent code

PA_TASK_ASSIGNMENTS_V

PA_TASK_ASSIGNMENT_UTILS - show dependent code

PA_TASK_TYPES

APPS.PA_TASK_ASSIGNMENTS_AMG_V is not referenced by any database object