eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_TASK_ASGMTS_LPV_V

Object Details

Object Name:	PA_TASK_ASGMTS_LPV_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		System generated number to uniquely identify row
RESOURCE_ASSIGNMENT_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the resource assignment
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
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
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
RBS_ELEMENT_ID	NUMBER	(15)		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
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
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
TXN_CURRENCY_CODE	VARCHAR2	(4000)		The currency code 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
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
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
CBS_ELEMENT_ID	NUMBER	(15)		The unique identifier of the cost code

Query Text

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


SELECT ROW_ID
,      RESOURCE_ASSIGNMENT_ID
,      PROJECT_ID
,      STRUCTURE_VERSION_ID
,      TASK_VERSION_ID
,      TASK_ID
,      RESOURCE_ALIAS
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_CLASS_CODE
,      RBS_ELEMENT_ID
,      PERSON_ID
,      UNIT_OF_MEASURE_CODE
,      UNIT_OF_MEASURE
,      RATE_BASED_FLAG
,      UNPLANNED_FLAG
,      ASSIGNMENT_START_DATE
,      ASSIGNMENT_END_DATE
,      PLANNING_START_DATE
,      PLANNING_END_DATE
,      TXN_CURRENCY_CODE
,      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
,      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
,      CBS_ELEMENT_ID
FROM APPS.PA_TASK_ASGMTS_LPV_V;

Dependencies

[top of page]

APPS.PA_TASK_ASGMTS_LPV_V references the following:

APPS: PA_BUDGET_VERSIONS; PA_LOOKUPS; PA_PROJECTS_ALL; PA_PROJ_ELEMENTS; PA_PROJ_ELEM_VER_STRUCTURE; PA_RESOURCE_ASGN_CURR; PA_RESOURCE_ASSIGNMENTS; PA_RESOURCE_LIST_MEMBERS; PA_TASK_ASSIGNMENT_UTILS - show dependent code

APPS.PA_TASK_ASGMTS_LPV_V is referenced by following:

APPS: PA_ASSIGNMENT_PROGRESS_V