View: PA_TASK_ASGMTS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_TASK_ASGMTS_V

View Text

SELECT RA.ROWID ROW_ID
, RA.RESOURCE_ASSIGNMENT_ID
, RA.PROJECT_ID
, BV.PROJECT_STRUCTURE_VERSION_ID
, RA.WBS_ELEMENT_VERSION_ID
, PE.PROJ_ELEMENT_ID
, RLM.ALIAS
, RA.RESOURCE_LIST_MEMBER_ID
, RA.RESOURCE_CLASS_CODE
, RA.RBS_ELEMENT_ID
, RA.PERSON_ID
, RA.UNIT_OF_MEASURE
, UOM.MEANING
, RA.RATE_BASED_FLAG
, RA.UNPLANNED_FLAG
, RA.SCHEDULE_START_DATE
, RA.SCHEDULE_END_DATE
, RA.PLANNING_START_DATE
, RA.PLANNING_END_DATE
, PA_TASK_ASSIGNMENT_UTILS.GET_PLANNED_CURRENCY_INFO( RA.RESOURCE_ASSIGNMENT_ID
, RA.PROJECT_ID
, 'TXN_CURRENCY_CODE') AS TXN_CURRENCY_CODE
, PRAC.TOTAL_QUANTITY AS PLANNED_QUANTITY
, PRAC.TOTAL_TXN_BURDENED_COST AS PLANNED_BUR_COST_TXN_CUR
, RA.TOTAL_PLAN_BURDENED_COST AS PLANNED_BUR_COST_PROJFUNC
, RA.TOTAL_PROJECT_BURDENED_COST AS PLANNED_BUR_COST_PROJ_CUR
, PRAC.TOTAL_TXN_RAW_COST AS PLANNED_RAW_COST_TXN_CUR
, RA.TOTAL_PROJECT_RAW_COST AS PLANNED_RAW_COST_PROJ_CUR
, RA.TOTAL_PLAN_RAW_COST AS PLANNED_RAW_COST_PROJFUNC
, PA_TASK_ASSIGNMENT_UTILS.GET_BASELINED_ASGMT_DATES(RA.PROJECT_ID
, RA.WBS_ELEMENT_VERSION_ID
, RA.RESOURCE_ASSIGNMENT_ID
, NULL
, PROJ.PROJECT_CURRENCY_CODE
, PROJ.PROJFUNC_CURRENCY_CODE
, 'BASELINED_ASGMT_START_DATE')
, PA_TASK_ASSIGNMENT_UTILS.GET_BASELINED_ASGMT_DATES(RA.PROJECT_ID
, RA.WBS_ELEMENT_VERSION_ID
, RA.RESOURCE_ASSIGNMENT_ID
, NULL
, PROJ.PROJECT_CURRENCY_CODE
, PROJ.PROJFUNC_CURRENCY_CODE
, 'BASELINED_ASGMT_END_DATE')
, PA_TASK_ASSIGNMENT_UTILS.GET_BASELINED_ASGMT_AMOUNTS(RA.PROJECT_ID
, RA.WBS_ELEMENT_VERSION_ID
, RA.RESOURCE_ASSIGNMENT_ID
, NULL
, PROJ.PROJECT_CURRENCY_CODE
, PROJ.PROJFUNC_CURRENCY_CODE
, 'BASELINED_PLANNED_QTY')
, PA_TASK_ASSIGNMENT_UTILS.GET_BASELINED_ASGMT_AMOUNTS(RA.PROJECT_ID
, RA.WBS_ELEMENT_VERSION_ID
, RA.RESOURCE_ASSIGNMENT_ID
, NULL
, PROJ.PROJECT_CURRENCY_CODE
, PROJ.PROJFUNC_CURRENCY_CODE
, 'BL_PLANNED_BUR_COST_TXN_CUR')
, PA_TASK_ASSIGNMENT_UTILS.GET_BASELINED_ASGMT_AMOUNTS(RA.PROJECT_ID
, RA.WBS_ELEMENT_VERSION_ID
, RA.RESOURCE_ASSIGNMENT_ID
, NULL
, PROJ.PROJECT_CURRENCY_CODE
, PROJ.PROJFUNC_CURRENCY_CODE
, 'BL_BUR_COST_PROJ_CUR')
, PA_TASK_ASSIGNMENT_UTILS.GET_BASELINED_ASGMT_AMOUNTS(RA.PROJECT_ID
, RA.WBS_ELEMENT_VERSION_ID
, RA.RESOURCE_ASSIGNMENT_ID
, NULL
, PROJ.PROJECT_CURRENCY_CODE
, PROJ.PROJFUNC_CURRENCY_CODE
, 'BL_BUR_COST_PROJFUNC_CUR')
, PA_TASK_ASSIGNMENT_UTILS.GET_BASELINED_ASGMT_AMOUNTS(RA.PROJECT_ID
, RA.WBS_ELEMENT_VERSION_ID
, RA.RESOURCE_ASSIGNMENT_ID
, NULL
, PROJ.PROJECT_CURRENCY_CODE
, PROJ.PROJFUNC_CURRENCY_CODE
, 'BL_RAW_COST_TXN_CUR')
, PA_TASK_ASSIGNMENT_UTILS.GET_BASELINED_ASGMT_AMOUNTS(RA.PROJECT_ID
, RA.WBS_ELEMENT_VERSION_ID
, RA.RESOURCE_ASSIGNMENT_ID
, NULL
, PROJ.PROJECT_CURRENCY_CODE
, PROJ.PROJFUNC_CURRENCY_CODE
, 'BL_RAW_COST_PROJ_CUR')
, PA_TASK_ASSIGNMENT_UTILS.GET_BASELINED_ASGMT_AMOUNTS(RA.PROJECT_ID
, RA.WBS_ELEMENT_VERSION_ID
, RA.RESOURCE_ASSIGNMENT_ID
, NULL
, PROJ.PROJECT_CURRENCY_CODE
, PROJ.PROJFUNC_CURRENCY_CODE
, 'BL_RAW_COST_PROJFUNC_CUR')
, RA.TA_DISPLAY_FLAG
, RA.BUDGET_VERSION_ID
FROM PA_RESOURCE_ASSIGNMENTS RA
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_PROJ_ELEMENTS PE
, PA_LOOKUPS UOM
, PA_PROJECTS_ALL PROJ
, PA_BUDGET_VERSIONS BV
, PA_RESOURCE_ASGN_CURR PRAC
WHERE RA.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID
AND PE.PROJ_ELEMENT_ID = RA.TASK_ID
AND UOM.LOOKUP_TYPE = 'UNIT'
AND UOM.LOOKUP_CODE = RA.UNIT_OF_MEASURE
AND RA.TA_DISPLAY_FLAG IS NOT NULL
AND RA.PROJECT_ID = PROJ.PROJECT_ID
AND BV.BUDGET_VERSION_ID = RA.BUDGET_VERSION_ID
AND RA.RESOURCE_ASSIGNMENT_ID = PRAC.RESOURCE_ASSIGNMENT_ID

Columns