VIEW: APPS.PA_TASK_ASGMTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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