View: PA_TASK_ASSIGNMENTS_V

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

View Text

SELECT RA.ROWID ROW_ID
, RA.PM_RES_ASSIGNMENT_REFERENCE
, RA.RESOURCE_ASSIGNMENT_ID
, PROJ.PM_PROJECT_REFERENCE
, RA.PM_PRODUCT_CODE
, RA.PROJECT_ID
, PEV.PARENT_STRUCTURE_VERSION_ID
, PEVS.LATEST_EFF_PUBLISHED_FLAG
, PE.PM_SOURCE_REFERENCE
, RA.WBS_ELEMENT_VERSION_ID
, PE.PROJ_ELEMENT_ID
, PE.NAME
, PE.ELEMENT_NUMBER
, RLM.ALIAS
, RA.RESOURCE_LIST_MEMBER_ID
, RA.RESOURCE_CLASS_CODE
, RCTL.NAME
, RA.RESOURCE_CLASS_FLAG
, RA.RBS_ELEMENT_ID
, RA.PERSON_ID
, RA.UNIT_OF_MEASURE
, UOM.MEANING
, RA.ASSIGNMENT_DESCRIPTION
, RA.RATE_BASED_FLAG
, RA.UNPLANNED_FLAG
, PA_PLANNING_RESOURCE_UTILS.RET_RESOURCE_NAME(RA.RES_TYPE_CODE
, RA.PERSON_ID
, RA.BOM_RESOURCE_ID
, RA.JOB_ID
, RA.PERSON_TYPE_CODE
, RA.NON_LABOR_RESOURCE
, RA.INVENTORY_ITEM_ID
, RCB.RESOURCE_CLASS_ID
, RA.ITEM_CATEGORY_ID
, RA.RESOURCE_ASSIGNMENT_ID)
, RA.RES_TYPE_CODE
, RA.BOM_RESOURCE_ID
, RA.JOB_ID
, RA.PERSON_TYPE_CODE
, RA.NON_LABOR_RESOURCE
, RA.INVENTORY_ITEM_ID
, RCB.RESOURCE_CLASS_ID
, RA.ITEM_CATEGORY_ID
, PA_PLANNING_RESOURCE_UTILS.RET_FIN_CATEGORY_NAME(RA.FC_RES_TYPE_CODE
, RA.EXPENDITURE_TYPE
, RA.EXPENDITURE_CATEGORY
, RA.EVENT_TYPE
, RA.REVENUE_CATEGORY_CODE
, RA.RESOURCE_ASSIGNMENT_ID)
, RA.FC_RES_TYPE_CODE
, RA.EXPENDITURE_TYPE
, RA.EXPENDITURE_CATEGORY
, RA.EVENT_TYPE
, RA.REVENUE_CATEGORY_CODE
, PA_EXPENDITURES_UTILS.GETORGTLNAME(RA.ORGANIZATION_ID)
, RA.ORGANIZATION_ID
, PA_PLANNING_ELEMENT_UTILS.GET_SUPPLIER_NAME(RA.SUPPLIER_ID)
, RA.SUPPLIER_ID
, RA.NAMED_ROLE
, PA_PLANNING_RESOURCE_UTILS.RET_INCUR_BY_RES_NAME(RA.PERSON_ID
, RA.JOB_ID
, RA.INCUR_BY_ROLE_ID
, RA.PERSON_TYPE_CODE
, RA.INCUR_BY_RES_CLASS_CODE
, RA.RESOURCE_ASSIGNMENT_ID)
, RA.INCUR_BY_ROLE_ID
, RA.INCUR_BY_RES_CLASS_CODE
, RA.INCURRED_BY_RES_FLAG
, RA.PROCURE_RESOURCE_FLAG
, PA_PLANNING_ELEMENT_UTILS.GET_PROJECT_ROLE_NAME(RA.PROJECT_ROLE_ID)
, RA.PROJECT_ROLE_ID
, RA.SCHEDULE_START_DATE
, RA.SCHEDULE_END_DATE
, RA.PLANNING_START_DATE
, RA.PLANNING_END_DATE
, RA.USE_TASK_SCHEDULE_FLAG
, RA.SCHEDULE_START_DATE - PEVSCH.SCHEDULED_START_DATE AS DELAY
, RA.SCHEDULE_END_DATE - RA.SCHEDULE_START_DATE AS DURATION
, RA.SPREAD_CURVE_ID
, PA_PLANNING_ELEMENT_UTILS.GET_SPREAD_CURVE_NAME(RA.SPREAD_CURVE_ID)
, PA_TASK_ASSIGNMENT_UTILS.GET_PLANNED_CURRENCY_INFO( RA.RESOURCE_ASSIGNMENT_ID
, RA.PROJECT_ID
, 'TXN_CURRENCY_CODE') AS TXN_CURRENCY_CODE
, PA_PLANNING_ELEMENT_UTILS.GET_MFC_COST_TYPE_NAME(RA.MFC_COST_TYPE_ID)
, RA.MFC_COST_TYPE_ID
, PA_FIN_PLAN_UTILS.GET_LOOKUP_VALUE('PA_FP_ETC_METHOD'
, RA.ETC_METHOD_CODE)
, RA.ETC_METHOD_CODE
, RA.BILLABLE_PERCENT
, 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
, PRAC.TOTAL_INIT_QUANTITY AS ACTUAL_QUANTITY
, PRAC.TOTAL_TXN_INIT_BURDENED_COST AS ACT_BUR_COST_TXN_CUR
, PRAC.TOTAL_PROJECT_INIT_BD_COST AS ACT_BUR_COST_PROJ_CUR
, PRAC.TOTAL_PROJFUNC_INIT_BD_COST AS ACT_BUR_COST_PROJFUNC
, PRAC.TOTAL_TXN_INIT_RAW_COST AS ACT_RAW_COST_TXN_CUR
, PRAC.TOTAL_PROJECT_INIT_RAW_COST AS ACT_RAW_COST_PROJ_CUR
, PRAC.TOTAL_PROJFUNC_INIT_RAW_COST AS ACT_RAW_COST_PROJFUNC
, PRAC.TXN_AVERAGE_RAW_COST_RATE AS AVG_RAW_COST_RATE
, PRAC.TXN_AVERAGE_BURDEN_COST_RATE AS AVG_BUR_COST_RATE
, 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
, RA.RATE_EXPENDITURE_TYPE
, RA.RATE_EXP_FUNC_CURR_CODE
, RA.RATE_EXPENDITURE_ORG_ID
, DECODE(RA.INCURRED_BY_RES_FLAG
, 'Y'
, RA.RES_TYPE_CODE
, NULL)
, RA.SCHEDULED_DELAY
FROM PA_RESOURCE_ASSIGNMENTS RA
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_RESOURCE_CLASSES_TL RCTL
, PA_RESOURCE_CLASSES_B RCB
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_PROJ_ELEMENTS PE
, PA_LOOKUPS UOM
, PA_PROJECT_ROLE_TYPES PRT
, PA_PROJ_ELEM_VER_STRUCTURE PEVS
, PA_PROJECTS_ALL PROJ
, PA_PROJ_ELEM_VER_SCHEDULE PEVSCH
, PA_BUDGET_VERSIONS BV
, PA_RESOURCE_ASGN_CURR PRAC
WHERE RA.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID
AND RA.RESOURCE_CLASS_CODE = RCB.RESOURCE_CLASS_CODE
AND RCB.RESOURCE_CLASS_ID = RCTL.RESOURCE_CLASS_ID
AND RCTL.LANGUAGE = USERENV('LANG')
AND RA.WBS_ELEMENT_VERSION_ID = PEV.ELEMENT_VERSION_ID
AND PEV.PROJ_ELEMENT_ID = PE.PROJ_ELEMENT_ID
AND PEVSCH.ELEMENT_VERSION_ID = RA.WBS_ELEMENT_VERSION_ID
AND UOM.LOOKUP_TYPE = 'UNIT'
AND UOM.LOOKUP_CODE = RA.UNIT_OF_MEASURE
AND RA.TA_DISPLAY_FLAG IS NOT NULL
AND PEV.PARENT_STRUCTURE_VERSION_ID = PEVS.ELEMENT_VERSION_ID
AND RA.PROJECT_ID = PROJ.PROJECT_ID
AND PEV.PROJECT_ID = PEVS.PROJECT_ID
AND RA.PROJECT_ROLE_ID = PRT.PROJECT_ROLE_ID(+)
AND RA.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
AND BV.PROJECT_STRUCTURE_VERSION_ID = PEVS.ELEMENT_VERSION_ID
AND RA.RESOURCE_ASSIGNMENT_ID = PRAC.RESOURCE_ASSIGNMENT_ID

Columns