DBA Data[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: ViewPA.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
Name Datatype Length Mandatory Comments
ACT_SCH_FINISH_VAR NUMBER

The variance between actual and scheduled finish.
ACT_SCH_START_VAR NUMBER

The variance between actual and scheduled start.
ACTUAL_COST NUMBER

The actual cost incurred.
ACTUAL_EFFORT NUMBER

The actual effort incurred.
ACTUAL_FINISH_DATE DATE

The actual date work finished.
ACTUAL_START_DATE DATE

The actual date work started.
ACTUAL_WORK_QUANTITY NUMBER (17)
The actual work achieved to date, as measured by work quantity.
AS_OF_DATE DATE

The progress As of Date.
BASELINE_COST NUMBER

The baseline cost for the task or assignment.
BASELINE_FINISH_DATE DATE

The baseline finish date.
BASELINE_START_DATE DATE

The baseline start date.
BASELINED_EFFORT NUMBER

The baseline effort for the task or assignment.
DAYS_UNTIL_PROGRESS_DUE NUMBER

The number of days until the next progress as of date for the task or assignment.
DAYS_UNTIL_SCHEDULED_FINISH NUMBER

The number of days until the assignment is scheduled to finish.
DAYS_UNTIL_START NUMBER

The number of days until the assignment is scheduled to start.
EARNED_VALUE NUMBER

The earned value for the task.
ETC_COST NUMBER

The estimated total cost for the assignment upon completion.
EST_AT_COMPLETION_EFFORT NUMBER

The estimated total effort for the assignment upon completion.
EST_BAS_FINISH_VAR NUMBER

The variance between estimated and baseline finish.
EST_BAS_START_VAR NUMBER

The variance between estimated and baseline start.
EST_REMAINING_EFFORT NUMBER

Estimated remaining effort.
EST_SCH_FINISH_VAR NUMBER

The variance between estimated and baseline finish.
ESTIMATED_FINISH_DATE DATE

The estimated finish date of the task or assignment.
ESTIMATED_START_DATE DATE

The estimated start date of the task or assignment.
ETC_COST_TC NUMBER

The cost in transaction currency estimated to be necessary to complete the assignment.
ETC_EFFORT NUMBER

The effort estimated to be necessary to complete the assignment.
ETC_WORK_QUANTITY NUMBER

The quantity of work required to finish the task as measured by work quantity.
NEXT_PROGRESS_DUE_DATE DATE

The date of the next As of Date for the task or assignment.
DEFAULT_AS_OF_DATE DATE

The progress As of Date.
PERCENT_COMPLETE_COST NUMBER

The percentage of work completed based on cost.
PERCENT_COMPLETE_EFFORT NUMBER

The percentage of work completed based on effort.
PERCENT_COMPLETE_ID NUMBER (15)
Percent_complete_id generated in sequence from pa_percent_completes_s.
PERCENT_SPENT_COST NUMBER

The percentage of planned cost that has been spent.
PERCENT_SPENT_EFFORT NUMBER

The percentage of planned effort that has been spent.
PLANNED_COST NUMBER

The planned cost of the task.
PLANNED_COST_PER_UNIT NUMBER

The planned cost per work quantity unit of the task.
PLANNED_EFFORT NUMBER

The planned effort of the task.
PLANNED_WORK_QUANTITY NUMBER (17)
The planned work quantity of the task.
PREDECESSORS VARCHAR2 (4000)
Predecessors for the task version
PRIORITY_CODE VARCHAR2 (30)
The task priority.
SCH_BASE_FINISH_VAR NUMBER

The variance between scheduled and baseline finish.
SCH_BASE_START_VAR NUMBER

The variance between scheduled and baseline start.
SCH_PERFORMANCE_INDEX NUMBER

The schedule performance index of the task.
ASSIGNMENT_END_DATE DATE

The scheduled finish of the assignment.
ASSIGNMENT_START_DATE DATE

The scheduled start of the assignment.
TASK_ID NUMBER (15) Yes Task Id.
TASK_MANAGER_NAME VARCHAR2 (0)
The task manager of the task.
TASK_MANAGER_PERSON_ID NUMBER (15)
The task manager id of the task.
TASK_NAME VARCHAR2 (240) Yes The task name.
TASK_NUMBER VARCHAR2 (100)
The task number.
TASK_TYPE VARCHAR2 (150)
The type that the user specifies for the task. This is a task-specific attribute.
TO_COMPLETE_PERFORMANCE_INDEX NUMBER

The to complete performance index of the task.
UNIT_OF_MEASURE VARCHAR2 (0)
The unit of measure for work quantity for the task.
VAR_AT_COMPLETION_COST NUMBER

The variance at completion between planned and actual cost.
VAR_AT_COMPLETION_EFFORT NUMBER

The variance at completion between planned and actual effort.
WBS_NUMBER VARCHAR2 (240)
System-generated formatted number for the task version, indicating the exact position of the task version in the structure version.
WORK_ITEM_CODE VARCHAR2 (30)
The default Work Item for Work Quantity.
WORK_TYPE NUMBER

The work type of the task.
RESOURCE_ASSIGNMENT_ID NUMBER (15) Yes The system-generated number that uniquely identifies the resource assignment.
CURRENT_FLAG VARCHAR2 (1)
The flag indicating whether the row is current or not.
DISPLAY_SEQUENCE NUMBER (15)
Display Sequence of the task.
ELEMENT_VERSION_ID NUMBER (15) Yes The unique identifier for the element version.
LONG_NAME VARCHAR2 (240)
Project Long Name.
OBJECT_TYPE VARCHAR2 (30) Yes The type of the object for the element. The value can be TASK or STRUCTURE.
PROJ_ELEMENT_ID NUMBER (15) Yes The unique identifier for the project element (uses the same sequence as PA_TASKS_S).
PROJECT_ID NUMBER (15) Yes The identifier of the project to which the element belongs.
PROJECT_NAME VARCHAR2 (30) Yes Name of the project.
PROJECT_NUMBER VARCHAR2 (25) Yes Number of the project.
PUBLISHED_BY_NAME VARCHAR2 (0)
Name of the person who published the progress record.
PUBLISHED_BY_PARTY_ID NUMBER (15)
Identifier of the person who published the progress record.
PUBLISHED_FLAG VARCHAR2 (1)
Flag indicating whether the progress record is published.
RECORD_VERSION_NUMBER NUMBER

Record version number.
UOM_CODE VARCHAR2 (30)
The default Unit of Measure for Work Quantity.
UOM_DESCRIPTION VARCHAR2 (80) Yes The default Unit of Measure name for Work Quantity.
WBS_LEVEL NUMBER (3)
Identifies the hierarchical level of the task version within a structure version.
WORK_ITEM_DESCRIPTION VARCHAR2 (80)
The default work item for work quantity
TXN_CURRENCY_CODE VARCHAR2 (4000)
The transaction currency code of the amount.
EFFORT_ENABLED_FLAG VARCHAR2 (1)
Flag to indicate effort enabled.
PROG_ENTRY_ENABLE_FLAG VARCHAR2 (1)
Flag to indicate whether progress entry is enabled for tasks of this task type.
RESOURCE_ALIAS VARCHAR2 (80)
User-defined short name of the the resource list member.
RESOURCE_LIST_MEMBER_ID NUMBER (15) Yes The identifier of the resource list member within the resource list that is assigned to the Workplan.
RESOURCE_CLASS_CODE VARCHAR2 (30)
Indicates the code of the resource class.
RESOURCE_CLASS VARCHAR2 (240) Yes Indicates the resource class.
RBS_ELEMENT_ID NUMBER (15) Yes Indicates the resource breakdown structure element id.
PERSON_ID NUMBER (15)
Indicates the person.
PROGRESS_COMMENT VARCHAR2 (4000)
Progress Comments.
PROGRESS_OVERVIEW VARCHAR2 (250)
The progress overview of the task.
PRIORITY_DESCRIPTION VARCHAR2 (0)
The priority of the task.
SUMMARY_ELEMENT_FLAG VARCHAR2 (4000)
Flag to indicate lowest ot summary level task.
RESOURCES VARCHAR2 (0)
Link to navigate to planning resource details page.
RATE_BASED_FLAG VARCHAR2 (1)
Indicates whether transactional is rate based.
ACTUAL_QUANTITY NUMBER

Actual effort incurred to date.
ACTUAL_COST_THIS_PERIOD NUMBER

Actual effort incurred during the progress cycle.
LATEST_PROGRESS_DATE DATE

Last published progress date.
STRUCTURE_VERSION_ID NUMBER (15)
Structure version Id.
SPREAD_CURVE_ID NUMBER (15)
Indicates the spread curve id.
SPREAD_CURVE_NAME VARCHAR2 (4000)
Indicates the spread curve used to spread the periodic amounts.
ASSIGNMENT_DESCRIPTION VARCHAR2 (240)
It stores the description of the assignment.
PLANNED_BUR_COST_PROJFUNC NUMBER

Indicates the planned burdened cost in project functional currency
PLANNED_QUANTITY NUMBER

Total quantity for the relevant task assignment.
ROLE_NAME VARCHAR2 (4000)
Indicates the project role name.
PM_RES_ASSIGNMENT_REFERENCE VARCHAR2 (25)
The identifier of the resource assignment in the external project management system from which the resource assignment was imported.
PM_PROJECT_REFERENCE VARCHAR2 (25)
The identifier of the project in the external project management system from which the project was imported.
PM_PRODUCT_CODE VARCHAR2 (30)
The identifier of the external project management system from which the project was imported.
PM_TASK_REFERENCE VARCHAR2 (25)
The identifier of the task in the source system from which the task was imported.
RESOURCE_CLASS_FLAG VARCHAR2 (1)
Indicates whether the resource is a resource class
UNPLANNED_FLAG VARCHAR2 (1)
Indicates that the planning transaction was created by the system as a result of actual costs being incurred
RESOURCE_NAME VARCHAR2 (4000)
The resource name of the assignment
RES_TYPE_CODE VARCHAR2 (30)
The resource type code of the assignment
BOM_RESOURCE_ID NUMBER (15)
The identifier of the BOM resource of the assignment
JOB_ID NUMBER (15)
The identifier of the job of the assignment
PERSON_TYPE_CODE VARCHAR2 (30)
The person type code of the assignment
NON_LABOR_RESOURCE VARCHAR2 (20)
The non-labor resource of the assignment
INVENTORY_ITEM_ID NUMBER (15)
The identifier of the inventory item of the assignment
RESOURCE_CLASS_ID NUMBER (15) Yes The identifier of the resource class of the assignment
ITEM_CATEGORY_ID NUMBER (15)
The identifier of the item category of the assignment
FINANCIAL_CATEGORY_NAME VARCHAR2 (4000)
The financial category of the assignment
FC_RES_TYPE_CODE VARCHAR2 (30)
The financial category resource type code of the assignment
EXPENDITURE_TYPE VARCHAR2 (30)
The expenditure type of the assignment
EXPENDITURE_CATEGORY VARCHAR2 (30)
The expenditure category of the assignment
EVENT_TYPE VARCHAR2 (30)
The event_type of the assignment
REVENUE_CATEGORY_CODE VARCHAR2 (30)
The revenue category code of the assignment
ORGANIZATION_NAME VARCHAR2 (4000)
The organization of the assignment
ORGANIZATION_ID NUMBER (15)
The identifier of the organization of the assignment
SUPPLIER_NAME VARCHAR2 (4000)
The supplier of the assignment
SUPPLIER_ID NUMBER (15)
The identifier of the supplier of the assignment
TEAM_ROLE VARCHAR2 (80)
The team role of the assignment
INCURRED_BY_RESOURCE_NAME VARCHAR2 (4000)
The incurred by resource of the assignment
INCUR_BY_ROLE_ID NUMBER (15)
The identifier of the incurred by role of the assignment
INCUR_BY_RES_CLASS_CODE VARCHAR2 (30)
The incurred by resource class code of the assignment
INCURRED_BY_RES_FLAG VARCHAR2 (1)
Indicates whether the resource is an incurred by resource of the assignment
PROCURE_RESOURCE_FLAG VARCHAR2 (1)
Indicates the procure resource of the assignment
ROLE_ID NUMBER (15)
The identifier of the role of the assignment
PLANNING_START_DATE DATE

Indicates the planning start date
PLANNING_END_DATE DATE

Indicates the planning end date
USE_TASK_SCHEDULE_FLAG VARCHAR2 (1)
Indicates whether the assignment uses task schedule
DELAY NUMBER

The delay of the assignment
DURATION NUMBER

The duration of the assignment
MANUFACTURING_COST_TYPE VARCHAR2 (4000)
The manufacturing cost type of the assignment
MFC_COST_TYPE_ID NUMBER (15)
The identifier of the manufacturing cost type of the assignment
ETC_METHOD_NAME VARCHAR2 (4000)
The forecast ETC method of the assignment
ETC_METHOD_CODE VARCHAR2 (30)
The forecast ETC method code of the assignment
BILLABLE_WORK_PERCENT NUMBER

The billable work percent of the assignment
PLANNED_BUR_COST_PROJ_CUR NUMBER

Indicates the planned burdened cost in project currency
PLANNED_RAW_COST_TXN_CUR NUMBER

Indicates the planned raw cost in transaction currency
PLANNED_RAW_COST_PROJ_CUR NUMBER

Indicates the planned raw cost in project currency
PLANNED_RAW_COST_PROJFUNC NUMBER

Indicates the planned raw cost in project functional currency
ACT_BUR_COST_TXN_CUR NUMBER

Indicates the actual burdened cost in transaction currency
ACT_BUR_COST_PROJ_CUR NUMBER

Indicates the actual burdened cost in project currency
ACT_BUR_COST_PROJFUNC NUMBER

Indicates the actual burdened cost in project functional currency
ACT_RAW_COST_TXN_CUR NUMBER

Indicates the actual raw cost in transaction currency
ACT_RAW_COST_PROJ_CUR NUMBER

Indicates the actual raw cost in project currency
ACT_RAW_COST_PROJFUNC NUMBER

Indicates the actual raw cost in project functional currency
AVG_RAW_COST_RATE NUMBER

Indicates the average raw cost rate
AVG_BUR_COST_RATE NUMBER

Indicates the average burdened cost rate
SCHEDULED_DELAY NUMBER

Scheduled delay for assignment
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_TASK_ASSIGNMENTS_AMG_V references the following:

SchemaAPPS
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
PL/SQL PackagePA_FIN_PLAN_UTILS - show dependent code
ViewPA_LOOKUPS
SynonymPA_PERCENT_COMPLETES
PL/SQL PackagePA_PLANNING_ELEMENT_UTILS - show dependent code
PL/SQL PackagePA_PLANNING_RESOURCE_UTILS - show dependent code
SynonymPA_PROGRESS_ROLLUP
PL/SQL PackagePA_PROGRESS_UTILS - show dependent code
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_STATUSES
SynonymPA_PROJ_ELEMENTS
PL/SQL PackagePA_PROJ_ELEMENTS_UTILS - show dependent code
SynonymPA_PROJ_ELEMENT_VERSIONS
SynonymPA_PROJ_ELEM_VER_SCHEDULE
SynonymPA_PROJ_ELEM_VER_STRUCTURE
SynonymPA_PROJ_PROGRESS_ATTR
SynonymPA_PROJ_STRUCTURE_TYPES
PL/SQL PackagePA_RELATIONSHIP_UTILS - show dependent code
PL/SQL PackagePA_ROLE_JOB_BG_UTILS - show dependent code
ViewPA_TASK_ASSIGNMENTS_V
PL/SQL PackagePA_TASK_ASSIGNMENT_UTILS - show dependent code
SynonymPA_TASK_TYPES

APPS.PA_TASK_ASSIGNMENTS_AMG_V is not referenced by any database object