DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_TASK_ASSIGNMENTS_V

Object Details
Object Name: PA_TASK_ASSIGNMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_TASK_ASSIGNMENTS_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
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
System generated number to uniquely identify row
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.
RESOURCE_ASSIGNMENT_ID NUMBER (15) Yes The system-generated number that uniquely identifies the resource assignment
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.
PROJECT_ID NUMBER (15) Yes Indicates the project to which the assignment belongs
STRUCTURE_VERSION_ID NUMBER (15)
Indicates the structure version to which the assignment belongs
LATEST_EFF_PUBLISHED_FLAG VARCHAR2 (1) Yes Indicates whether the assignments belongs to the latest published structure
PM_TASK_REFERENCE VARCHAR2 (25)
The identifier of the task in the source system from which the task was imported.
TASK_VERSION_ID NUMBER (15)
Indicates the task version to which the assignment belongs
TASK_ID NUMBER (15) Yes Indicates the task to which the assignment belongs
TASK_NAME VARCHAR2 (240) Yes The name of the task to which the assignment belongs
TASK_NUMBER VARCHAR2 (100)
The number of the task to which the assignment belongs
RESOURCE_ALIAS VARCHAR2 (80)
Indicates the user name of the resource
RESOURCE_LIST_MEMBER_ID NUMBER (15) Yes The identifier of the resource list member within the resource list on the assignment
RESOURCE_CLASS_CODE VARCHAR2 (30)
The code of the resource class
RESOURCE_CLASS VARCHAR2 (240) Yes The name of the resource class
RESOURCE_CLASS_FLAG VARCHAR2 (1)
Indicates whether the resource is a resource class
RBS_ELEMENT_ID NUMBER (15) Yes Indicates the resource breakdown structure element
PERSON_ID NUMBER (15)
Indicates the person on the assignment
UNIT_OF_MEASURE_CODE VARCHAR2 (30)
The code of the unit of measure
UNIT_OF_MEASURE VARCHAR2 (80) Yes The name of the unit of measure
ASSIGNMENT_DESCRIPTION VARCHAR2 (240)
The assignment description
RATE_BASED_FLAG VARCHAR2 (1)
Indicates whether the assignment is rate based
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_NAME VARCHAR2 (4000)
The role name of the assignment
ROLE_ID NUMBER (15)
The identifier of the role of the assignment
ASSIGNMENT_START_DATE DATE

Indicates the schedule start date
ASSIGNMENT_END_DATE DATE

Indicates the schedule end date
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
SPREAD_CURVE_ID NUMBER (15)
The identifier of the spread curve of the assignment
SPREAD_CURVE_NAME VARCHAR2 (4000)
The spread curve of the assignment
TXN_CURRENCY_CODE VARCHAR2 (4000)
The currency code 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_QUANTITY NUMBER

Indicates the planned quantity
PLANNED_BUR_COST_TXN_CUR NUMBER

Indicates the planned burdened cost in transaction currency
PLANNED_BUR_COST_PROJFUNC NUMBER

Indicates the planned burdened cost in project functional currency
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
ACTUAL_QUANTITY NUMBER

Indicates the acual quantity
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
BASELINED_ASGMT_START_DATE DATE

The baselined start date
BASELINED_ASGMT_END_DATE DATE

The baselined end date
BASELINED_PLANNED_QTY NUMBER

The baselined planned quantity
BL_PLANNED_BUR_COST_TXN_CUR NUMBER

The baselined planned burdened cost in transaction currency
BL_BUR_COST_PROJ_CUR NUMBER

The baselined planned burdened cost in project currency
BL_BUR_COST_PROJFUNC_CUR NUMBER

The baselined planned burdened cost in project functional currency
BL_PLANNED_RAW_COST_TXN_CUR NUMBER

The baselined planned raw cost in transaction currency
BL_RAW_COST_PROJ_CUR NUMBER

The baselined planned raw cost in project currency
BL_RAW_COST_PROJFUNC_CUR NUMBER

The baselined planned raw cost in project functional currency
TA_DISPLAY_FLAG VARCHAR2 (1)
BUDGET_VERSION_ID NUMBER (15) Yes The unique identifier of the budget version
RATE_EXPENDITURE_TYPE VARCHAR2 (30)
The rate expenditure type
RATE_EXP_FUNC_CURR_CODE VARCHAR2 (30)
The rate expenditure functional currency code
RATE_EXPENDITURE_ORG_ID NUMBER (15)
The rate expenditure operating unit
INCUR_BY_RES_TYPE VARCHAR2 (30)
The resource type code of incurred by resource
SCHEDULED_DELAY NUMBER

Scheduled delay for assignment
Query Text

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


SELECT ROW_ID
,      PM_RES_ASSIGNMENT_REFERENCE
,      RESOURCE_ASSIGNMENT_ID
,      PM_PROJECT_REFERENCE
,      PM_PRODUCT_CODE
,      PROJECT_ID
,      STRUCTURE_VERSION_ID
,      LATEST_EFF_PUBLISHED_FLAG
,      PM_TASK_REFERENCE
,      TASK_VERSION_ID
,      TASK_ID
,      TASK_NAME
,      TASK_NUMBER
,      RESOURCE_ALIAS
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_CLASS_CODE
,      RESOURCE_CLASS
,      RESOURCE_CLASS_FLAG
,      RBS_ELEMENT_ID
,      PERSON_ID
,      UNIT_OF_MEASURE_CODE
,      UNIT_OF_MEASURE
,      ASSIGNMENT_DESCRIPTION
,      RATE_BASED_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_NAME
,      ROLE_ID
,      ASSIGNMENT_START_DATE
,      ASSIGNMENT_END_DATE
,      PLANNING_START_DATE
,      PLANNING_END_DATE
,      USE_TASK_SCHEDULE_FLAG
,      DELAY
,      DURATION
,      SPREAD_CURVE_ID
,      SPREAD_CURVE_NAME
,      TXN_CURRENCY_CODE
,      MANUFACTURING_COST_TYPE
,      MFC_COST_TYPE_ID
,      ETC_METHOD_NAME
,      ETC_METHOD_CODE
,      BILLABLE_WORK_PERCENT
,      PLANNED_QUANTITY
,      PLANNED_BUR_COST_TXN_CUR
,      PLANNED_BUR_COST_PROJFUNC
,      PLANNED_BUR_COST_PROJ_CUR
,      PLANNED_RAW_COST_TXN_CUR
,      PLANNED_RAW_COST_PROJ_CUR
,      PLANNED_RAW_COST_PROJFUNC
,      ACTUAL_QUANTITY
,      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
,      BASELINED_ASGMT_START_DATE
,      BASELINED_ASGMT_END_DATE
,      BASELINED_PLANNED_QTY
,      BL_PLANNED_BUR_COST_TXN_CUR
,      BL_BUR_COST_PROJ_CUR
,      BL_BUR_COST_PROJFUNC_CUR
,      BL_PLANNED_RAW_COST_TXN_CUR
,      BL_RAW_COST_PROJ_CUR
,      BL_RAW_COST_PROJFUNC_CUR
,      TA_DISPLAY_FLAG
,      BUDGET_VERSION_ID
,      RATE_EXPENDITURE_TYPE
,      RATE_EXP_FUNC_CURR_CODE
,      RATE_EXPENDITURE_ORG_ID
,      INCUR_BY_RES_TYPE
,      SCHEDULED_DELAY
FROM APPS.PA_TASK_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS.PA_TASK_ASSIGNMENTS_V references the following:

SchemaAPPS
SynonymPA_BUDGET_VERSIONS
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
PL/SQL PackagePA_FIN_PLAN_UTILS - show dependent code
ViewPA_LOOKUPS
PL/SQL PackagePA_PLANNING_ELEMENT_UTILS - show dependent code
PL/SQL PackagePA_PLANNING_RESOURCE_UTILS - show dependent code
SynonymPA_PROJECTS_ALL
ViewPA_PROJECT_ROLE_TYPES
SynonymPA_PROJ_ELEMENTS
SynonymPA_PROJ_ELEMENT_VERSIONS
SynonymPA_PROJ_ELEM_VER_SCHEDULE
SynonymPA_PROJ_ELEM_VER_STRUCTURE
SynonymPA_RESOURCE_ASGN_CURR
SynonymPA_RESOURCE_ASSIGNMENTS
SynonymPA_RESOURCE_CLASSES_B
SynonymPA_RESOURCE_CLASSES_TL
SynonymPA_RESOURCE_LIST_MEMBERS
PL/SQL PackagePA_ROLE_JOB_BG_UTILS - show dependent code
PL/SQL PackagePA_TASK_ASSIGNMENT_UTILS - show dependent code
APPS.PA_TASK_ASSIGNMENTS_V is referenced by following:

SchemaAPPS
Package BodyPA_ASSIGNMENT_PROGRESS_PUB - show dependent code
Package BodyPA_PROGRESS_PUB - show dependent code
Package BodyPA_PROGRESS_UTILS - show dependent code
Package BodyPA_STATUS_PUB - show dependent code
ViewPA_TASK_ASSIGNMENTS_AMG_V
Package BodyPA_TASK_PUB1 - show dependent code