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.

VIEW: APPS.PA_FP_WEBADI_CONTENTS_V

Source

View Text - Preformatted


SELECT pra.budget_version_id, ppfo.FIN_PLAN_PREFERENCE_CODE, pp.name, pra.resource_assignment_id, ptk.task_number, ptk.task_name, decode(prlm2.parent_member_id, null, prlm2.alias, prlm1.alias), decode(prlm2.parent_member_id, null,decode(prl.group_resource_type_id,0,prlm2.alias,null) ,prlm2.alias), to_date(NULL), to_date(NULL), to_number(null), to_number(null), to_number(null), to_number(null), pmvl.amount_type_name, p.amount_type_code, p.amount_subtype_code, pmvl.amount_type_id, p.currency_code, p.preceding_periods_amount, p.succeeding_periods_amount, p.period_amount1, p.period_amount2, p.period_amount3, p.period_amount4, p.period_amount5, p.period_amount6, p.period_amount7, p.period_amount8, p.period_amount9, p.period_amount10, p.period_amount11, p.period_amount12, p.period_amount13, p.period_amount14, p.period_amount15, p.period_amount16, p.period_amount17, p.period_amount18, p.period_amount19, p.period_amount20, p.period_amount21, p.period_amount22, p.period_amount23, p.period_amount24, p.period_amount25, p.period_amount26, p.period_amount27, p.period_amount28, p.period_amount29, p.period_amount30, p.period_amount31, p.period_amount32, p.period_amount33, p.period_amount34, p.period_amount35, p.period_amount36, p.period_amount37, p.period_amount38, p.period_amount39, p.period_amount40, p.period_amount41, p.period_amount42, p.period_amount43, p.period_amount44, p.period_amount45, p.period_amount46, p.period_amount47, p.period_amount48, p.period_amount49, p.period_amount50, p.period_amount51, p.period_amount52, decode(NVL(pra.UNIT_OF_MEASURE,'NONE'), 'NONE', NULL, (SELECT meaning from PA_LOOKUPS WHERE LOOKUP_TYPE = 'UNIT' AND LOOKUP_CODE = NVL(pra.UNIT_OF_MEASURE,'HOURS'))), null, null, null, null, null, null, null, null, null, null, to_number(null), to_date(null), to_number(null), to_date(null), to_number(null), to_date(null), to_number(null), to_date(null), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, decode(decode(p.amount_subtype_code, 'RAW_COST',ppfo.PROJFUNC_COST_RATE_TYPE, 'BURDENED_COST',ppfo.PROJFUNC_COST_RATE_TYPE, 'REVENUE',ppfo.PROJFUNC_REV_RATE_TYPE, null), null,null,(select pctv1.USER_CONVERSION_TYPE from pa_conversion_types_v pctv1 where pctv1.CONVERSION_TYPE= NVL(decode(p.amount_subtype_code, 'RAW_COST',ppfo.PROJFUNC_COST_RATE_TYPE, 'BURDENED_COST',ppfo.PROJFUNC_COST_RATE_TYPE, 'REVENUE',ppfo.PROJFUNC_REV_RATE_TYPE, null),'Corporate')) ), decode(decode(p.amount_subtype_code, 'RAW_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',null,ppfo.PROJFUNC_COST_RATE_DATE_TYPE), 'BURDENED_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',null,ppfo.PROJFUNC_COST_RATE_DATE_TYPE), 'REVENUE',decode(ppfo.PROJFUNC_REV_RATE_TYPE,'User',null,ppfo.PROJFUNC_REV_RATE_DATE_TYPE) ,NULL ), null,null,(select plk_d1.meaning from pa_lookups plk_d1 where plk_d1.lookup_type='PA_FP_RATE_DATE_TYPE' and plk_d1.lookup_code=NVL(decode(p.amount_subtype_code, 'RAW_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',null,ppfo.PROJFUNC_COST_RATE_DATE_TYPE), 'BURDENED_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',null,ppfo.PROJFUNC_COST_RATE_DATE_TYPE), 'REVENUE',decode(ppfo.PROJFUNC_REV_RATE_TYPE,'User',null,ppfo.PROJFUNC_REV_RATE_DATE_TYPE) ,NULL),'FIXED_DATE')) ), decode(decode(p.amount_subtype_code, 'RAW_COST',ppfo.PROJECT_COST_RATE_TYPE, 'BURDENED_COST',ppfo.PROJECT_COST_RATE_TYPE, 'REVENUE',ppfo.PROJECT_REV_RATE_TYPE, null), null,null,(select pctv2.USER_CONVERSION_TYPE from pa_conversion_types_v pctv2 where pctv2.CONVERSION_TYPE= NVL(decode(p.amount_subtype_code, 'RAW_COST',ppfo.PROJECT_COST_RATE_TYPE, 'BURDENED_COST',ppfo.PROJECT_COST_RATE_TYPE, 'REVENUE',ppfo.PROJECT_REV_RATE_TYPE, null),'Corporate')) ), decode(decode(p.amount_subtype_code, 'RAW_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',null,ppfo.PROJECT_COST_RATE_DATE_TYPE), 'BURDENED_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',null,ppfo.PROJECT_COST_RATE_DATE_TYPE), 'REVENUE',decode(ppfo.PROJECT_REV_RATE_TYPE,'User',null,ppfo.PROJECT_REV_RATE_DATE_TYPE) ,NULL ), null,null,(select plk_d2.meaning from pa_lookups plk_d2 where plk_d2.lookup_type='PA_FP_RATE_DATE_TYPE' and plk_d2.lookup_code=NVL(decode(p.amount_subtype_code, 'RAW_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',null,ppfo.PROJECT_COST_RATE_DATE_TYPE), 'BURDENED_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',null,ppfo.PROJECT_COST_RATE_DATE_TYPE), 'REVENUE',decode(ppfo.PROJECT_REV_RATE_TYPE,'User',null,ppfo.PROJECT_REV_RATE_DATE_TYPE) ,NULL),'FIXED_DATE')) ), decode(p.amount_subtype_code, 'RAW_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',pftc.PROJFUNC_COST_EXCHANGE_RATE,TO_NUMBER(null)), 'BURDENED_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',pftc.PROJFUNC_COST_EXCHANGE_RATE,TO_NUMBER(null)), 'REVENUE',decode(ppfo.PROJFUNC_REV_RATE_TYPE,'User',pftc.PROJFUNC_REV_EXCHANGE_RATE,TO_NUMBER(null)) ,NULL ), decode(p.amount_subtype_code, 'RAW_COST',decode(ppfo.PROJFUNC_COST_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJFUNC_COST_RATE_DATE,TO_DATE(null)), 'BURDENED_COST',decode(ppfo.PROJFUNC_COST_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJFUNC_COST_RATE_DATE,TO_DATE(null)), 'REVENUE',decode(ppfo.PROJFUNC_REV_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJFUNC_REV_RATE_DATE,TO_DATE(null)) ,NULL ), decode(p.amount_subtype_code, 'RAW_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',pftc.PROJECT_COST_EXCHANGE_RATE,TO_NUMBER(null)), 'BURDENED_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',pftc.PROJECT_COST_EXCHANGE_RATE,TO_NUMBER(null)), 'REVENUE',decode(ppfo.PROJECT_REV_RATE_TYPE,'User',pftc.PROJECT_REV_EXCHANGE_RATE,TO_NUMBER(null)) ,NULL ), decode(p.amount_subtype_code, 'RAW_COST',decode(ppfo.PROJECT_COST_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJECT_COST_RATE_DATE,TO_DATE(null)), 'BURDENED_COST',decode(ppfo.PROJECT_COST_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJECT_COST_RATE_DATE,TO_DATE(null)), 'REVENUE',decode(ppfo.PROJECT_REV_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJECT_REV_RATE_DATE,TO_DATE(null)) ,NULL ) From pa_budget_versions pbv, pa_proj_fp_options ppfo, pa_projects_all pp, pa_proj_periods_denorm p, pa_amount_types_vl pmvl, pa_resource_lists prl, pa_resource_assignments pra, pa_tasks ptk, pa_fp_txn_currencies pftc, pa_resource_list_members prlm1, pa_resource_list_members prlm2 WHERE ppfo.fin_plan_version_id =pra.budget_version_id and ppfo.fin_plan_option_level_code = 'PLAN_VERSION' and ppfo.project_id = pra.project_id and ppfo.fin_plan_type_id = pbv.fin_plan_type_id and pa_fin_plan_utils.get_time_phased_code(pra.budget_version_id) IN ('P','G') and pp.project_id = pra.project_id and pra.task_id = ptk.task_id(+) and prlm2.parent_member_id = prlm1.resource_list_member_id(+) and prlm2.resource_list_member_id = pra.resource_list_member_id and pmvl.AMOUNT_TYPE_ID=p.amount_subtype_id and p.budget_version_id=pra.budget_version_id and p.object_id=pra.resource_assignment_id and p.period_profile_id=pbv.period_profile_id and pra.resource_assignment_id = p.resource_assignment_id and pra.resource_assignment_type = 'USER_ENTERED' and p.object_type_code='RES_ASSIGNMENT' and p.currency_type = 'TRANSACTION' and pftc.txn_currency_code = p.currency_code and pftc.fin_plan_version_id = ppfo.fin_plan_version_id and pftc.proj_fp_options_id = ppfo.proj_fp_options_id and pbv.budget_version_id = pra.budget_version_id and prl.resource_list_id = pbv.resource_list_id UNION select pra.budget_version_id, ppfo.FIN_PLAN_PREFERENCE_CODE, pp.name, pra.resource_assignment_id, ptk.task_number, ptk.task_name, decode(prlm2.parent_member_id, null, prlm2.alias, prlm1.alias), decode(prlm2.parent_member_id, null,decode(prl.group_resource_type_id,0,prlm2.alias,null) ,prlm2.alias), to_date(NULL), to_date(NULL), to_number(null), to_number(null), to_number(null), to_number(null), pmvl.amount_type_name, null, pmvl.amount_type_code, pmvl.amount_type_id, pftc.txn_currency_code, to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), decode(NVL(pra.UNIT_OF_MEASURE,'NONE'), 'NONE',NULL, (SELECT meaning from PA_LOOKUPS WHERE LOOKUP_TYPE = 'UNIT' AND LOOKUP_CODE = NVL(pra.UNIT_OF_MEASURE,'HOURS'))), null, null, null, null, null, null, null, null, null, null, to_number(null), to_date(null), to_number(null), to_date(null), to_number(null), to_date(null), to_number(null), to_date(null), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, decode(decode(pmvl.amount_type_code, 'RAW_COST',ppfo.PROJFUNC_COST_RATE_TYPE, 'BURDENED_COST',ppfo.PROJFUNC_COST_RATE_TYPE, 'REVENUE',ppfo.PROJFUNC_REV_RATE_TYPE, null), null,null,(select pctv1.USER_CONVERSION_TYPE from pa_conversion_types_v pctv1 where pctv1.CONVERSION_TYPE= NVL(decode(pmvl.amount_type_code, 'RAW_COST',ppfo.PROJFUNC_COST_RATE_TYPE, 'BURDENED_COST',ppfo.PROJFUNC_COST_RATE_TYPE, 'REVENUE',ppfo.PROJFUNC_REV_RATE_TYPE, null),'Corporate')) ), decode(decode(pmvl.amount_type_code, 'RAW_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',null,ppfo.PROJFUNC_COST_RATE_DATE_TYPE), 'BURDENED_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',null,ppfo.PROJFUNC_COST_RATE_DATE_TYPE), 'REVENUE',decode(ppfo.PROJFUNC_REV_RATE_TYPE,'User',null,ppfo.PROJFUNC_REV_RATE_DATE_TYPE) ,NULL ), null,null,(select plk_d1.meaning from pa_lookups plk_d1 where plk_d1.lookup_type='PA_FP_RATE_DATE_TYPE' and plk_d1.lookup_code=NVL(decode(pmvl.amount_type_code, 'RAW_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',null,ppfo.PROJFUNC_COST_RATE_DATE_TYPE), 'BURDENED_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',null,ppfo.PROJFUNC_COST_RATE_DATE_TYPE), 'REVENUE',decode(ppfo.PROJFUNC_REV_RATE_TYPE,'User',null,ppfo.PROJFUNC_REV_RATE_DATE_TYPE) ,NULL),'FIXED_DATE')) ), decode(decode(pmvl.amount_type_code, 'RAW_COST',ppfo.PROJECT_COST_RATE_TYPE, 'BURDENED_COST',ppfo.PROJECT_COST_RATE_TYPE, 'REVENUE',ppfo.PROJECT_REV_RATE_TYPE, null), null,null,(select pctv2.USER_CONVERSION_TYPE from pa_conversion_types_v pctv2 where pctv2.CONVERSION_TYPE= NVL(decode(pmvl.amount_type_code, 'RAW_COST',ppfo.PROJECT_COST_RATE_TYPE, 'BURDENED_COST',ppfo.PROJECT_COST_RATE_TYPE, 'REVENUE',ppfo.PROJECT_REV_RATE_TYPE, null),'Corporate')) ), decode(decode(pmvl.amount_type_code, 'RAW_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',null,ppfo.PROJECT_COST_RATE_DATE_TYPE), 'BURDENED_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',null,ppfo.PROJECT_COST_RATE_DATE_TYPE), 'REVENUE',decode(ppfo.PROJECT_REV_RATE_TYPE,'User',null,ppfo.PROJECT_REV_RATE_DATE_TYPE) ,NULL ), null,null,(select plk_d2.meaning from pa_lookups plk_d2 where plk_d2.lookup_type='PA_FP_RATE_DATE_TYPE' and plk_d2.lookup_code=NVL(decode(pmvl.amount_type_code, 'RAW_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',null,ppfo.PROJECT_COST_RATE_DATE_TYPE), 'BURDENED_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',null,ppfo.PROJECT_COST_RATE_DATE_TYPE), 'REVENUE',decode(ppfo.PROJECT_REV_RATE_TYPE,'User',null,ppfo.PROJECT_REV_RATE_DATE_TYPE) ,NULL),'FIXED_DATE')) ), decode(pmvl.amount_type_code, 'RAW_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',pftc.PROJFUNC_COST_EXCHANGE_RATE,TO_NUMBER(null)), 'BURDENED_COST',decode(ppfo.PROJFUNC_COST_RATE_TYPE,'User',pftc.PROJFUNC_COST_EXCHANGE_RATE,TO_NUMBER(null)), 'REVENUE',decode(ppfo.PROJFUNC_REV_RATE_TYPE,'User',pftc.PROJFUNC_REV_EXCHANGE_RATE,TO_NUMBER(null)) ,NULL ), decode(pmvl.amount_type_code, 'RAW_COST',decode(ppfo.PROJFUNC_COST_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJFUNC_COST_RATE_DATE,TO_DATE(null)), 'BURDENED_COST',decode(ppfo.PROJFUNC_COST_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJFUNC_COST_RATE_DATE,TO_DATE(null)), 'REVENUE',decode(ppfo.PROJFUNC_REV_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJFUNC_REV_RATE_DATE,TO_DATE(null)) ,NULL ), decode(pmvl.amount_type_code, 'RAW_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',pftc.PROJECT_COST_EXCHANGE_RATE,TO_NUMBER(null)), 'BURDENED_COST',decode(ppfo.PROJECT_COST_RATE_TYPE,'User',pftc.PROJECT_COST_EXCHANGE_RATE,TO_NUMBER(null)), 'REVENUE',decode(ppfo.PROJECT_REV_RATE_TYPE,'User',pftc.PROJECT_REV_EXCHANGE_RATE,TO_NUMBER(null)) ,NULL ), decode(pmvl.amount_type_code, 'RAW_COST',decode(ppfo.PROJECT_COST_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJECT_COST_RATE_DATE,TO_DATE(null)), 'BURDENED_COST',decode(ppfo.PROJECT_COST_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJECT_COST_RATE_DATE,TO_DATE(null)), 'REVENUE',decode(ppfo.PROJECT_REV_RATE_DATE_TYPE,'FIXED_DATE',ppfo.PROJECT_REV_RATE_DATE,TO_DATE(null)) ,NULL ) From pa_proj_fp_options ppfo, pa_projects_all pp, pa_resource_assignments pra, pa_tasks ptk, pa_resource_lists prl, pa_budget_versions pbv, pa_fp_txn_currencies pftc, pa_amount_types_vl pmvl, pa_resource_list_members prlm1, pa_resource_list_members prlm2 where ppfo.fin_plan_version_id=pra.budget_version_id and ppfo.project_id = pra.project_id and ppfo.fin_plan_type_id = pbv.fin_plan_type_id and ppfo.fin_plan_option_level_code = 'PLAN_VERSION' and pa_fin_plan_utils.get_time_phased_code(pra.budget_version_id) IN ('P','G') and pp.project_id = pra.project_id and pra.resource_assignment_id NOT IN ( select pbl.resource_assignment_id from pa_budget_lines pbl where pbl.budget_version_id = pra.budget_version_id) and pra.resource_assignment_type = 'USER_ENTERED' and pra.task_id = ptk.task_id(+) and prlm2.parent_member_id = prlm1.resource_list_member_id(+) and prlm2.resource_list_member_id = pra.resource_list_member_id and pmvl.amount_type_code IN ('RAW_COST','BURDENED_COST','REVENUE','QUANTITY') and ppfo.proj_fp_options_id=pftc.proj_fp_options_id and decode(ppfo.fin_plan_preference_code,'COST_ONLY',pftc.default_cost_curr_flag, 'REVENUE_ONLY',pftc.default_rev_curr_flag, pftc.default_all_curr_flag)= 'Y' and pbv.budget_version_id = pra.budget_version_id and prl.resource_list_id = pbv.resource_list_id UNION Select pra.budget_version_id, ppfo.fin_plan_preference_code, p.name, pra.resource_assignment_id, ptk.task_number, ptk.task_name, decode(prlm2.parent_member_id, null, prlm2.alias, prlm1.alias), decode(prlm2.parent_member_id, null,decode(prl.group_resource_type_id,0,prlm2.alias,null) ,prlm2.alias), nvl(b.start_date,nvl(ptk.start_date, p.start_date)), nvl(b.end_date,nvl(ptk.completion_date, p.completion_date)), b.QUANTITY, b.TXN_RAW_COST, b.TXN_BURDENED_COST, b.TXN_REVENUE, 'Quantity', 'QUANTITY', 'QUANTITY', 215, NVL(b.TXN_CURRENCY_CODE,pftc.txn_currency_code), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), decode(NVL(pra.UNIT_OF_MEASURE,'NONE'), 'NONE', NULL, (SELECT meaning from PA_LOOKUPS WHERE LOOKUP_TYPE = 'UNIT' AND LOOKUP_CODE = NVL(pra.UNIT_OF_MEASURE,'HOURS'))), b.DESCRIPTION, decode(b.CHANGE_REASON_CODE,null,null,(select meaning from PA_LOOKUPS where LOOKUP_TYPE='BUDGET CHANGE REASON' and LOOKUP_CODE= nvl(b.change_reason_code, ( select lookup_code from pa_lookups where lookup_type='BUDGET CHANGE REASON' and rownum=1))) ), decode(NVL(b.PROJFUNC_COST_RATE_TYPE,ppfo.PROJFUNC_COST_RATE_TYPE),null,null, (select pctv1.USER_CONVERSION_TYPE from pa_conversion_types_v pctv1 where pctv1.CONVERSION_TYPE=NVL(NVL(b.PROJFUNC_COST_RATE_TYPE,ppfo.PROJFUNC_COST_RATE_TYPE),'Corporate')) ), decode( NVL(b.PROJFUNC_COST_RATE_DATE_TYPE,decode(NVL(b.PROJFUNC_COST_RATE_TYPE,ppfo.PROJFUNC_COST_RATE_TYPE),'User',null,ppfo.PROJFUNC_COST_RATE_DATE_TYPE)) ,null,null, (select plk_d1.meaning from pa_lookups plk_d1 where plk_d1.lookup_type='PA_FP_RATE_DATE_TYPE' and plk_d1.lookup_code=NVL(NVL(b.PROJFUNC_COST_RATE_DATE_TYPE, decode(nvl(b.PROJFUNC_COST_RATE_TYPE,ppfo.PROJFUNC_COST_RATE_TYPE),'User', null,ppfo.PROJFUNC_COST_RATE_DATE_TYPE)),'FIXED_DATE')) ), decode(NVL(b.PROJECT_COST_RATE_TYPE,ppfo.PROJECT_COST_RATE_TYPE),null,null, (select pctv2.USER_CONVERSION_TYPE from pa_conversion_types_v pctv2 where pctv2.CONVERSION_TYPE=NVL(NVL(b.PROJECT_COST_RATE_TYPE,ppfo.PROJECT_COST_RATE_TYPE),'Corporate')) ), decode( NVL(b.PROJECT_COST_RATE_DATE_TYPE,decode(NVL(b.PROJECT_COST_RATE_TYPE,ppfo.PROJECT_COST_RATE_TYPE),'User',null,ppfo.PROJECT_COST_RATE_DATE_TYPE)) ,null,null,(select plk_d2.meaning from pa_lookups plk_d2 where plk_d2.lookup_type='PA_FP_RATE_DATE_TYPE' and plk_d2.lookup_code=NVL(NVL(b.PROJECT_COST_RATE_DATE_TYPE, decode(nvl(b.PROJECT_COST_RATE_TYPE,ppfo.PROJECT_COST_RATE_TYPE),'User',null,ppfo.PROJECT_COST_RATE_DATE_TYPE)),'FIXED_DATE')) ), decode(NVL(b.PROJFUNC_REV_RATE_TYPE, ppfo.PROJFUNC_REV_RATE_TYPE),null,null, (select pctv3.USER_CONVERSION_TYPE from pa_conversion_types_v pctv3 where pctv3.CONVERSION_TYPE=NVL(NVL(b.PROJFUNC_REV_RATE_TYPE,ppfo.PROJFUNC_REV_RATE_TYPE),'Corporate')) ), decode( NVL(b.PROJFUNC_REV_RATE_DATE_TYPE,decode(NVL(b.PROJFUNC_REV_RATE_TYPE,ppfo.PROJFUNC_REV_RATE_TYPE),'User',null,ppfo.PROJFUNC_REV_RATE_DATE_TYPE)) ,null,null, (select plk_d3.meaning from pa_lookups plk_d3 where plk_d3.lookup_type='PA_FP_RATE_DATE_TYPE' and plk_d3.lookup_code=NVL(NVL(b.PROJFUNC_REV_RATE_DATE_TYPE, decode(nvl(b.PROJFUNC_REV_RATE_TYPE,ppfo.PROJFUNC_REV_RATE_TYPE),'User',null,ppfo.PROJFUNC_REV_RATE_DATE_TYPE)),'FIXED_DATE')) ), decode(NVL(b.PROJECT_REV_RATE_TYPE, ppfo.PROJECT_REV_RATE_TYPE),null,null, (select pctv4.USER_CONVERSION_TYPE from pa_conversion_types_v pctv4 where pctv4.CONVERSION_TYPE=NVL(NVL(b.PROJECT_REV_RATE_TYPE,ppfo.PROJECT_REV_RATE_TYPE),'Corporate')) ), decode( NVL(b.PROJECT_REV_RATE_DATE_TYPE,decode(NVL(b.PROJECT_REV_RATE_TYPE,ppfo.PROJECT_REV_RATE_TYPE),'User',null,ppfo.PROJECT_REV_RATE_DATE_TYPE)) ,null,null,(select plk_d4.meaning from pa_lookups plk_d4 where plk_d4.lookup_type='PA_FP_RATE_DATE_TYPE' and plk_d4.lookup_code=NVL(NVL(b.PROJECT_REV_RATE_DATE_TYPE, decode(nvl(b.PROJECT_REV_RATE_TYPE,ppfo.PROJECT_REV_RATE_TYPE),'User',null,ppfo.PROJECT_REV_RATE_DATE_TYPE)),'FIXED_DATE')) ), NVL(b.PROJFUNC_COST_EXCHANGE_RATE,decode(NVL(b.PROJFUNC_COST_RATE_TYPE,ppfo.PROJFUNC_COST_RATE_TYPE), 'User', pftc.PROJFUNC_COST_EXCHANGE_RATE, to_number(null))), NVL(b.PROJFUNC_COST_RATE_DATE,decode(NVL(b.PROJFUNC_COST_RATE_DATE_TYPE,ppfo.PROJFUNC_COST_RATE_DATE_TYPE), 'FIXED_DATE', ppfo.PROJFUNC_COST_RATE_DATE, to_date(null))), NVL(b.PROJECT_COST_EXCHANGE_RATE,decode(NVL(b.PROJECT_COST_RATE_TYPE,ppfo.PROJECT_COST_RATE_TYPE), 'User', pftc.PROJECT_COST_EXCHANGE_RATE, to_number(null))), NVL(b.PROJECT_COST_RATE_DATE, decode(NVL(b.PROJECT_COST_RATE_DATE_TYPE,ppfo.PROJECT_COST_RATE_DATE_TYPE), 'FIXED_DATE', ppfo.PROJECT_COST_RATE_DATE, to_date(null))), NVL(b.PROJFUNC_REV_EXCHANGE_RATE, decode(NVL(b.PROJFUNC_REV_RATE_TYPE,ppfo.PROJFUNC_REV_RATE_TYPE), 'User', pftc.PROJFUNC_REV_EXCHANGE_RATE, to_number(null))), NVL(b.PROJFUNC_REV_RATE_DATE,decode(NVL(b.PROJFUNC_REV_RATE_DATE_TYPE,ppfo.PROJFUNC_REV_RATE_DATE_TYPE), 'FIXED_DATE', ppfo.PROJFUNC_REV_RATE_DATE, to_date(null))), NVL(b.PROJECT_REV_EXCHANGE_RATE,decode(NVL(b.PROJECT_REV_RATE_TYPE,ppfo.PROJECT_REV_RATE_TYPE), 'User', pftc.PROJECT_REV_EXCHANGE_RATE, to_number(null))), NVL(b.PROJECT_REV_RATE_DATE,decode(NVL(b.PROJECT_REV_RATE_DATE_TYPE,ppfo.PROJECT_REV_RATE_DATE_TYPE), 'FIXED_DATE', ppfo.PROJECT_REV_RATE_DATE, to_date(null))), b.ATTRIBUTE_CATEGORY, b.ATTRIBUTE1, b.ATTRIBUTE2, b.ATTRIBUTE3, b.ATTRIBUTE4, b.ATTRIBUTE5, b.ATTRIBUTE6, b.ATTRIBUTE7, b.ATTRIBUTE8, b.ATTRIBUTE9, b.ATTRIBUTE10, b.ATTRIBUTE11, b.ATTRIBUTE12, b.ATTRIBUTE13, b.ATTRIBUTE14, b.ATTRIBUTE15, null, null, null, null, to_number(null), to_date(null), to_number(null), to_date(null) From pa_projects_all p, pa_budget_lines b, pa_resource_assignments pra, pa_tasks ptk, pa_resource_lists prl, pa_budget_versions pbv, pa_fp_txn_currencies pftc, pa_proj_fp_options ppfo, pa_resource_list_members prlm1, pa_resource_list_members prlm2 where p.project_id = pra.project_id and b.resource_assignment_id(+)=pra.resource_assignment_id and pra.task_id=ptk.task_id(+) and prlm2.parent_member_id=prlm1.resource_list_member_id(+) and prlm2.resource_list_member_id=pra.resource_list_member_id and pra.resource_assignment_type = 'USER_ENTERED' and ppfo.project_id = pra.project_id and ppfo.fin_plan_type_id = pbv.fin_plan_type_id and ppfo.fin_plan_version_id = pra.budget_version_id and ppfo.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION' and pa_fin_plan_utils.get_time_phased_code(pra.budget_version_id) NOT IN ('P','G') and ppfo.proj_fp_options_id=pftc.proj_fp_options_id and decode(ppfo.fin_plan_preference_code,'COST_ONLY',pftc.default_cost_curr_flag, 'REVENUE_ONLY',pftc.default_rev_curr_flag, pftc.default_all_curr_flag)= 'Y' and pbv.budget_version_id = pra.budget_version_id and prl.resource_list_id = pbv.resource_list_id

View Text - HTML Formatted

SELECT PRA.BUDGET_VERSION_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PP.NAME
, PRA.RESOURCE_ASSIGNMENT_ID
, PTK.TASK_NUMBER
, PTK.TASK_NAME
, DECODE(PRLM2.PARENT_MEMBER_ID
, NULL
, PRLM2.ALIAS
, PRLM1.ALIAS)
, DECODE(PRLM2.PARENT_MEMBER_ID
, NULL
, DECODE(PRL.GROUP_RESOURCE_TYPE_ID
, 0
, PRLM2.ALIAS
, NULL)
, PRLM2.ALIAS)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PMVL.AMOUNT_TYPE_NAME
, P.AMOUNT_TYPE_CODE
, P.AMOUNT_SUBTYPE_CODE
, PMVL.AMOUNT_TYPE_ID
, P.CURRENCY_CODE
, P.PRECEDING_PERIODS_AMOUNT
, P.SUCCEEDING_PERIODS_AMOUNT
, P.PERIOD_AMOUNT1
, P.PERIOD_AMOUNT2
, P.PERIOD_AMOUNT3
, P.PERIOD_AMOUNT4
, P.PERIOD_AMOUNT5
, P.PERIOD_AMOUNT6
, P.PERIOD_AMOUNT7
, P.PERIOD_AMOUNT8
, P.PERIOD_AMOUNT9
, P.PERIOD_AMOUNT10
, P.PERIOD_AMOUNT11
, P.PERIOD_AMOUNT12
, P.PERIOD_AMOUNT13
, P.PERIOD_AMOUNT14
, P.PERIOD_AMOUNT15
, P.PERIOD_AMOUNT16
, P.PERIOD_AMOUNT17
, P.PERIOD_AMOUNT18
, P.PERIOD_AMOUNT19
, P.PERIOD_AMOUNT20
, P.PERIOD_AMOUNT21
, P.PERIOD_AMOUNT22
, P.PERIOD_AMOUNT23
, P.PERIOD_AMOUNT24
, P.PERIOD_AMOUNT25
, P.PERIOD_AMOUNT26
, P.PERIOD_AMOUNT27
, P.PERIOD_AMOUNT28
, P.PERIOD_AMOUNT29
, P.PERIOD_AMOUNT30
, P.PERIOD_AMOUNT31
, P.PERIOD_AMOUNT32
, P.PERIOD_AMOUNT33
, P.PERIOD_AMOUNT34
, P.PERIOD_AMOUNT35
, P.PERIOD_AMOUNT36
, P.PERIOD_AMOUNT37
, P.PERIOD_AMOUNT38
, P.PERIOD_AMOUNT39
, P.PERIOD_AMOUNT40
, P.PERIOD_AMOUNT41
, P.PERIOD_AMOUNT42
, P.PERIOD_AMOUNT43
, P.PERIOD_AMOUNT44
, P.PERIOD_AMOUNT45
, P.PERIOD_AMOUNT46
, P.PERIOD_AMOUNT47
, P.PERIOD_AMOUNT48
, P.PERIOD_AMOUNT49
, P.PERIOD_AMOUNT50
, P.PERIOD_AMOUNT51
, P.PERIOD_AMOUNT52
, DECODE(NVL(PRA.UNIT_OF_MEASURE
, 'NONE')
, 'NONE'
, NULL
, (SELECT MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'UNIT'
AND LOOKUP_CODE = NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')))
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DECODE(DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, PPFO.PROJFUNC_COST_RATE_TYPE
, 'BURDENED_COST'
, PPFO.PROJFUNC_COST_RATE_TYPE
, 'REVENUE'
, PPFO.PROJFUNC_REV_RATE_TYPE
, NULL)
, NULL
, NULL
, (SELECT PCTV1.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV1
WHERE PCTV1.CONVERSION_TYPE= NVL(DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, PPFO.PROJFUNC_COST_RATE_TYPE
, 'BURDENED_COST'
, PPFO.PROJFUNC_COST_RATE_TYPE
, 'REVENUE'
, PPFO.PROJFUNC_REV_RATE_TYPE
, NULL)
, 'CORPORATE')) )
, DECODE(DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, 'BURDENED_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, 'REVENUE'
, DECODE(PPFO.PROJFUNC_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_REV_RATE_DATE_TYPE)
, NULL )
, NULL
, NULL
, (SELECT PLK_D1.MEANING
FROM PA_LOOKUPS PLK_D1
WHERE PLK_D1.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D1.LOOKUP_CODE=NVL(DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, 'BURDENED_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, 'REVENUE'
, DECODE(PPFO.PROJFUNC_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_REV_RATE_DATE_TYPE)
, NULL)
, 'FIXED_DATE')) )
, DECODE(DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, PPFO.PROJECT_COST_RATE_TYPE
, 'BURDENED_COST'
, PPFO.PROJECT_COST_RATE_TYPE
, 'REVENUE'
, PPFO.PROJECT_REV_RATE_TYPE
, NULL)
, NULL
, NULL
, (SELECT PCTV2.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV2
WHERE PCTV2.CONVERSION_TYPE= NVL(DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, PPFO.PROJECT_COST_RATE_TYPE
, 'BURDENED_COST'
, PPFO.PROJECT_COST_RATE_TYPE
, 'REVENUE'
, PPFO.PROJECT_REV_RATE_TYPE
, NULL)
, 'CORPORATE')) )
, DECODE(DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, 'BURDENED_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, 'REVENUE'
, DECODE(PPFO.PROJECT_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_REV_RATE_DATE_TYPE)
, NULL )
, NULL
, NULL
, (SELECT PLK_D2.MEANING
FROM PA_LOOKUPS PLK_D2
WHERE PLK_D2.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D2.LOOKUP_CODE=NVL(DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, 'BURDENED_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, 'REVENUE'
, DECODE(PPFO.PROJECT_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_REV_RATE_DATE_TYPE)
, NULL)
, 'FIXED_DATE')) )
, DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, PFTC.PROJFUNC_COST_EXCHANGE_RATE
, TO_NUMBER(NULL))
, 'BURDENED_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, PFTC.PROJFUNC_COST_EXCHANGE_RATE
, TO_NUMBER(NULL))
, 'REVENUE'
, DECODE(PPFO.PROJFUNC_REV_RATE_TYPE
, 'USER'
, PFTC.PROJFUNC_REV_EXCHANGE_RATE
, TO_NUMBER(NULL))
, NULL )
, DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJFUNC_COST_RATE_DATE
, TO_DATE(NULL))
, 'BURDENED_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJFUNC_COST_RATE_DATE
, TO_DATE(NULL))
, 'REVENUE'
, DECODE(PPFO.PROJFUNC_REV_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJFUNC_REV_RATE_DATE
, TO_DATE(NULL))
, NULL )
, DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, PFTC.PROJECT_COST_EXCHANGE_RATE
, TO_NUMBER(NULL))
, 'BURDENED_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, PFTC.PROJECT_COST_EXCHANGE_RATE
, TO_NUMBER(NULL))
, 'REVENUE'
, DECODE(PPFO.PROJECT_REV_RATE_TYPE
, 'USER'
, PFTC.PROJECT_REV_EXCHANGE_RATE
, TO_NUMBER(NULL))
, NULL )
, DECODE(P.AMOUNT_SUBTYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJECT_COST_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJECT_COST_RATE_DATE
, TO_DATE(NULL))
, 'BURDENED_COST'
, DECODE(PPFO.PROJECT_COST_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJECT_COST_RATE_DATE
, TO_DATE(NULL))
, 'REVENUE'
, DECODE(PPFO.PROJECT_REV_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJECT_REV_RATE_DATE
, TO_DATE(NULL))
, NULL )
FROM PA_BUDGET_VERSIONS PBV
, PA_PROJ_FP_OPTIONS PPFO
, PA_PROJECTS_ALL PP
, PA_PROJ_PERIODS_DENORM P
, PA_AMOUNT_TYPES_VL PMVL
, PA_RESOURCE_LISTS PRL
, PA_RESOURCE_ASSIGNMENTS PRA
, PA_TASKS PTK
, PA_FP_TXN_CURRENCIES PFTC
, PA_RESOURCE_LIST_MEMBERS PRLM1
, PA_RESOURCE_LIST_MEMBERS PRLM2
WHERE PPFO.FIN_PLAN_VERSION_ID =PRA.BUDGET_VERSION_ID
AND PPFO.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION'
AND PPFO.PROJECT_ID = PRA.PROJECT_ID
AND PPFO.FIN_PLAN_TYPE_ID = PBV.FIN_PLAN_TYPE_ID
AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(PRA.BUDGET_VERSION_ID) IN ('P'
, 'G')
AND PP.PROJECT_ID = PRA.PROJECT_ID
AND PRA.TASK_ID = PTK.TASK_ID(+)
AND PRLM2.PARENT_MEMBER_ID = PRLM1.RESOURCE_LIST_MEMBER_ID(+)
AND PRLM2.RESOURCE_LIST_MEMBER_ID = PRA.RESOURCE_LIST_MEMBER_ID
AND PMVL.AMOUNT_TYPE_ID=P.AMOUNT_SUBTYPE_ID
AND P.BUDGET_VERSION_ID=PRA.BUDGET_VERSION_ID
AND P.OBJECT_ID=PRA.RESOURCE_ASSIGNMENT_ID
AND P.PERIOD_PROFILE_ID=PBV.PERIOD_PROFILE_ID
AND PRA.RESOURCE_ASSIGNMENT_ID = P.RESOURCE_ASSIGNMENT_ID
AND PRA.RESOURCE_ASSIGNMENT_TYPE = 'USER_ENTERED'
AND P.OBJECT_TYPE_CODE='RES_ASSIGNMENT'
AND P.CURRENCY_TYPE = 'TRANSACTION'
AND PFTC.TXN_CURRENCY_CODE = P.CURRENCY_CODE
AND PFTC.FIN_PLAN_VERSION_ID = PPFO.FIN_PLAN_VERSION_ID
AND PFTC.PROJ_FP_OPTIONS_ID = PPFO.PROJ_FP_OPTIONS_ID
AND PBV.BUDGET_VERSION_ID = PRA.BUDGET_VERSION_ID
AND PRL.RESOURCE_LIST_ID = PBV.RESOURCE_LIST_ID UNION SELECT PRA.BUDGET_VERSION_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, PP.NAME
, PRA.RESOURCE_ASSIGNMENT_ID
, PTK.TASK_NUMBER
, PTK.TASK_NAME
, DECODE(PRLM2.PARENT_MEMBER_ID
, NULL
, PRLM2.ALIAS
, PRLM1.ALIAS)
, DECODE(PRLM2.PARENT_MEMBER_ID
, NULL
, DECODE(PRL.GROUP_RESOURCE_TYPE_ID
, 0
, PRLM2.ALIAS
, NULL)
, PRLM2.ALIAS)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PMVL.AMOUNT_TYPE_NAME
, NULL
, PMVL.AMOUNT_TYPE_CODE
, PMVL.AMOUNT_TYPE_ID
, PFTC.TXN_CURRENCY_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(NVL(PRA.UNIT_OF_MEASURE
, 'NONE')
, 'NONE'
, NULL
, (SELECT MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'UNIT'
AND LOOKUP_CODE = NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')))
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DECODE(DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, PPFO.PROJFUNC_COST_RATE_TYPE
, 'BURDENED_COST'
, PPFO.PROJFUNC_COST_RATE_TYPE
, 'REVENUE'
, PPFO.PROJFUNC_REV_RATE_TYPE
, NULL)
, NULL
, NULL
, (SELECT PCTV1.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV1
WHERE PCTV1.CONVERSION_TYPE= NVL(DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, PPFO.PROJFUNC_COST_RATE_TYPE
, 'BURDENED_COST'
, PPFO.PROJFUNC_COST_RATE_TYPE
, 'REVENUE'
, PPFO.PROJFUNC_REV_RATE_TYPE
, NULL)
, 'CORPORATE')) )
, DECODE(DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, 'BURDENED_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, 'REVENUE'
, DECODE(PPFO.PROJFUNC_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_REV_RATE_DATE_TYPE)
, NULL )
, NULL
, NULL
, (SELECT PLK_D1.MEANING
FROM PA_LOOKUPS PLK_D1
WHERE PLK_D1.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D1.LOOKUP_CODE=NVL(DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, 'BURDENED_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, 'REVENUE'
, DECODE(PPFO.PROJFUNC_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJFUNC_REV_RATE_DATE_TYPE)
, NULL)
, 'FIXED_DATE')) )
, DECODE(DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, PPFO.PROJECT_COST_RATE_TYPE
, 'BURDENED_COST'
, PPFO.PROJECT_COST_RATE_TYPE
, 'REVENUE'
, PPFO.PROJECT_REV_RATE_TYPE
, NULL)
, NULL
, NULL
, (SELECT PCTV2.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV2
WHERE PCTV2.CONVERSION_TYPE= NVL(DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, PPFO.PROJECT_COST_RATE_TYPE
, 'BURDENED_COST'
, PPFO.PROJECT_COST_RATE_TYPE
, 'REVENUE'
, PPFO.PROJECT_REV_RATE_TYPE
, NULL)
, 'CORPORATE')) )
, DECODE(DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, 'BURDENED_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, 'REVENUE'
, DECODE(PPFO.PROJECT_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_REV_RATE_DATE_TYPE)
, NULL )
, NULL
, NULL
, (SELECT PLK_D2.MEANING
FROM PA_LOOKUPS PLK_D2
WHERE PLK_D2.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D2.LOOKUP_CODE=NVL(DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, 'BURDENED_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, 'REVENUE'
, DECODE(PPFO.PROJECT_REV_RATE_TYPE
, 'USER'
, NULL
, PPFO.PROJECT_REV_RATE_DATE_TYPE)
, NULL)
, 'FIXED_DATE')) )
, DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, PFTC.PROJFUNC_COST_EXCHANGE_RATE
, TO_NUMBER(NULL))
, 'BURDENED_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_TYPE
, 'USER'
, PFTC.PROJFUNC_COST_EXCHANGE_RATE
, TO_NUMBER(NULL))
, 'REVENUE'
, DECODE(PPFO.PROJFUNC_REV_RATE_TYPE
, 'USER'
, PFTC.PROJFUNC_REV_EXCHANGE_RATE
, TO_NUMBER(NULL))
, NULL )
, DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJFUNC_COST_RATE_DATE
, TO_DATE(NULL))
, 'BURDENED_COST'
, DECODE(PPFO.PROJFUNC_COST_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJFUNC_COST_RATE_DATE
, TO_DATE(NULL))
, 'REVENUE'
, DECODE(PPFO.PROJFUNC_REV_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJFUNC_REV_RATE_DATE
, TO_DATE(NULL))
, NULL )
, DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, PFTC.PROJECT_COST_EXCHANGE_RATE
, TO_NUMBER(NULL))
, 'BURDENED_COST'
, DECODE(PPFO.PROJECT_COST_RATE_TYPE
, 'USER'
, PFTC.PROJECT_COST_EXCHANGE_RATE
, TO_NUMBER(NULL))
, 'REVENUE'
, DECODE(PPFO.PROJECT_REV_RATE_TYPE
, 'USER'
, PFTC.PROJECT_REV_EXCHANGE_RATE
, TO_NUMBER(NULL))
, NULL )
, DECODE(PMVL.AMOUNT_TYPE_CODE
, 'RAW_COST'
, DECODE(PPFO.PROJECT_COST_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJECT_COST_RATE_DATE
, TO_DATE(NULL))
, 'BURDENED_COST'
, DECODE(PPFO.PROJECT_COST_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJECT_COST_RATE_DATE
, TO_DATE(NULL))
, 'REVENUE'
, DECODE(PPFO.PROJECT_REV_RATE_DATE_TYPE
, 'FIXED_DATE'
, PPFO.PROJECT_REV_RATE_DATE
, TO_DATE(NULL))
, NULL )
FROM PA_PROJ_FP_OPTIONS PPFO
, PA_PROJECTS_ALL PP
, PA_RESOURCE_ASSIGNMENTS PRA
, PA_TASKS PTK
, PA_RESOURCE_LISTS PRL
, PA_BUDGET_VERSIONS PBV
, PA_FP_TXN_CURRENCIES PFTC
, PA_AMOUNT_TYPES_VL PMVL
, PA_RESOURCE_LIST_MEMBERS PRLM1
, PA_RESOURCE_LIST_MEMBERS PRLM2
WHERE PPFO.FIN_PLAN_VERSION_ID=PRA.BUDGET_VERSION_ID
AND PPFO.PROJECT_ID = PRA.PROJECT_ID
AND PPFO.FIN_PLAN_TYPE_ID = PBV.FIN_PLAN_TYPE_ID
AND PPFO.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION'
AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(PRA.BUDGET_VERSION_ID) IN ('P'
, 'G')
AND PP.PROJECT_ID = PRA.PROJECT_ID
AND PRA.RESOURCE_ASSIGNMENT_ID NOT IN ( SELECT PBL.RESOURCE_ASSIGNMENT_ID
FROM PA_BUDGET_LINES PBL
WHERE PBL.BUDGET_VERSION_ID = PRA.BUDGET_VERSION_ID)
AND PRA.RESOURCE_ASSIGNMENT_TYPE = 'USER_ENTERED'
AND PRA.TASK_ID = PTK.TASK_ID(+)
AND PRLM2.PARENT_MEMBER_ID = PRLM1.RESOURCE_LIST_MEMBER_ID(+)
AND PRLM2.RESOURCE_LIST_MEMBER_ID = PRA.RESOURCE_LIST_MEMBER_ID
AND PMVL.AMOUNT_TYPE_CODE IN ('RAW_COST'
, 'BURDENED_COST'
, 'REVENUE'
, 'QUANTITY')
AND PPFO.PROJ_FP_OPTIONS_ID=PFTC.PROJ_FP_OPTIONS_ID
AND DECODE(PPFO.FIN_PLAN_PREFERENCE_CODE
, 'COST_ONLY'
, PFTC.DEFAULT_COST_CURR_FLAG
, 'REVENUE_ONLY'
, PFTC.DEFAULT_REV_CURR_FLAG
, PFTC.DEFAULT_ALL_CURR_FLAG)= 'Y'
AND PBV.BUDGET_VERSION_ID = PRA.BUDGET_VERSION_ID
AND PRL.RESOURCE_LIST_ID = PBV.RESOURCE_LIST_ID UNION SELECT PRA.BUDGET_VERSION_ID
, PPFO.FIN_PLAN_PREFERENCE_CODE
, P.NAME
, PRA.RESOURCE_ASSIGNMENT_ID
, PTK.TASK_NUMBER
, PTK.TASK_NAME
, DECODE(PRLM2.PARENT_MEMBER_ID
, NULL
, PRLM2.ALIAS
, PRLM1.ALIAS)
, DECODE(PRLM2.PARENT_MEMBER_ID
, NULL
, DECODE(PRL.GROUP_RESOURCE_TYPE_ID
, 0
, PRLM2.ALIAS
, NULL)
, PRLM2.ALIAS)
, NVL(B.START_DATE
, NVL(PTK.START_DATE
, P.START_DATE))
, NVL(B.END_DATE
, NVL(PTK.COMPLETION_DATE
, P.COMPLETION_DATE))
, B.QUANTITY
, B.TXN_RAW_COST
, B.TXN_BURDENED_COST
, B.TXN_REVENUE
, 'QUANTITY'
, 'QUANTITY'
, 'QUANTITY'
, 215
, NVL(B.TXN_CURRENCY_CODE
, PFTC.TXN_CURRENCY_CODE)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(NVL(PRA.UNIT_OF_MEASURE
, 'NONE')
, 'NONE'
, NULL
, (SELECT MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'UNIT'
AND LOOKUP_CODE = NVL(PRA.UNIT_OF_MEASURE
, 'HOURS')))
, B.DESCRIPTION
, DECODE(B.CHANGE_REASON_CODE
, NULL
, NULL
, (SELECT MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE='BUDGET CHANGE REASON'
AND LOOKUP_CODE= NVL(B.CHANGE_REASON_CODE
, ( SELECT LOOKUP_CODE
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE='BUDGET CHANGE REASON'
AND ROWNUM=1))) )
, DECODE(NVL(B.PROJFUNC_COST_RATE_TYPE
, PPFO.PROJFUNC_COST_RATE_TYPE)
, NULL
, NULL
, (SELECT PCTV1.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV1
WHERE PCTV1.CONVERSION_TYPE=NVL(NVL(B.PROJFUNC_COST_RATE_TYPE
, PPFO.PROJFUNC_COST_RATE_TYPE)
, 'CORPORATE')) )
, DECODE( NVL(B.PROJFUNC_COST_RATE_DATE_TYPE
, DECODE(NVL(B.PROJFUNC_COST_RATE_TYPE
, PPFO.PROJFUNC_COST_RATE_TYPE)
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE))
, NULL
, NULL
, (SELECT PLK_D1.MEANING
FROM PA_LOOKUPS PLK_D1
WHERE PLK_D1.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D1.LOOKUP_CODE=NVL(NVL(B.PROJFUNC_COST_RATE_DATE_TYPE
, DECODE(NVL(B.PROJFUNC_COST_RATE_TYPE
, PPFO.PROJFUNC_COST_RATE_TYPE)
, 'USER'
, NULL
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE))
, 'FIXED_DATE')) )
, DECODE(NVL(B.PROJECT_COST_RATE_TYPE
, PPFO.PROJECT_COST_RATE_TYPE)
, NULL
, NULL
, (SELECT PCTV2.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV2
WHERE PCTV2.CONVERSION_TYPE=NVL(NVL(B.PROJECT_COST_RATE_TYPE
, PPFO.PROJECT_COST_RATE_TYPE)
, 'CORPORATE')) )
, DECODE( NVL(B.PROJECT_COST_RATE_DATE_TYPE
, DECODE(NVL(B.PROJECT_COST_RATE_TYPE
, PPFO.PROJECT_COST_RATE_TYPE)
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE))
, NULL
, NULL
, (SELECT PLK_D2.MEANING
FROM PA_LOOKUPS PLK_D2
WHERE PLK_D2.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D2.LOOKUP_CODE=NVL(NVL(B.PROJECT_COST_RATE_DATE_TYPE
, DECODE(NVL(B.PROJECT_COST_RATE_TYPE
, PPFO.PROJECT_COST_RATE_TYPE)
, 'USER'
, NULL
, PPFO.PROJECT_COST_RATE_DATE_TYPE))
, 'FIXED_DATE')) )
, DECODE(NVL(B.PROJFUNC_REV_RATE_TYPE
, PPFO.PROJFUNC_REV_RATE_TYPE)
, NULL
, NULL
, (SELECT PCTV3.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV3
WHERE PCTV3.CONVERSION_TYPE=NVL(NVL(B.PROJFUNC_REV_RATE_TYPE
, PPFO.PROJFUNC_REV_RATE_TYPE)
, 'CORPORATE')) )
, DECODE( NVL(B.PROJFUNC_REV_RATE_DATE_TYPE
, DECODE(NVL(B.PROJFUNC_REV_RATE_TYPE
, PPFO.PROJFUNC_REV_RATE_TYPE)
, 'USER'
, NULL
, PPFO.PROJFUNC_REV_RATE_DATE_TYPE))
, NULL
, NULL
, (SELECT PLK_D3.MEANING
FROM PA_LOOKUPS PLK_D3
WHERE PLK_D3.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D3.LOOKUP_CODE=NVL(NVL(B.PROJFUNC_REV_RATE_DATE_TYPE
, DECODE(NVL(B.PROJFUNC_REV_RATE_TYPE
, PPFO.PROJFUNC_REV_RATE_TYPE)
, 'USER'
, NULL
, PPFO.PROJFUNC_REV_RATE_DATE_TYPE))
, 'FIXED_DATE')) )
, DECODE(NVL(B.PROJECT_REV_RATE_TYPE
, PPFO.PROJECT_REV_RATE_TYPE)
, NULL
, NULL
, (SELECT PCTV4.USER_CONVERSION_TYPE
FROM PA_CONVERSION_TYPES_V PCTV4
WHERE PCTV4.CONVERSION_TYPE=NVL(NVL(B.PROJECT_REV_RATE_TYPE
, PPFO.PROJECT_REV_RATE_TYPE)
, 'CORPORATE')) )
, DECODE( NVL(B.PROJECT_REV_RATE_DATE_TYPE
, DECODE(NVL(B.PROJECT_REV_RATE_TYPE
, PPFO.PROJECT_REV_RATE_TYPE)
, 'USER'
, NULL
, PPFO.PROJECT_REV_RATE_DATE_TYPE))
, NULL
, NULL
, (SELECT PLK_D4.MEANING
FROM PA_LOOKUPS PLK_D4
WHERE PLK_D4.LOOKUP_TYPE='PA_FP_RATE_DATE_TYPE'
AND PLK_D4.LOOKUP_CODE=NVL(NVL(B.PROJECT_REV_RATE_DATE_TYPE
, DECODE(NVL(B.PROJECT_REV_RATE_TYPE
, PPFO.PROJECT_REV_RATE_TYPE)
, 'USER'
, NULL
, PPFO.PROJECT_REV_RATE_DATE_TYPE))
, 'FIXED_DATE')) )
, NVL(B.PROJFUNC_COST_EXCHANGE_RATE
, DECODE(NVL(B.PROJFUNC_COST_RATE_TYPE
, PPFO.PROJFUNC_COST_RATE_TYPE)
, 'USER'
, PFTC.PROJFUNC_COST_EXCHANGE_RATE
, TO_NUMBER(NULL)))
, NVL(B.PROJFUNC_COST_RATE_DATE
, DECODE(NVL(B.PROJFUNC_COST_RATE_DATE_TYPE
, PPFO.PROJFUNC_COST_RATE_DATE_TYPE)
, 'FIXED_DATE'
, PPFO.PROJFUNC_COST_RATE_DATE
, TO_DATE(NULL)))
, NVL(B.PROJECT_COST_EXCHANGE_RATE
, DECODE(NVL(B.PROJECT_COST_RATE_TYPE
, PPFO.PROJECT_COST_RATE_TYPE)
, 'USER'
, PFTC.PROJECT_COST_EXCHANGE_RATE
, TO_NUMBER(NULL)))
, NVL(B.PROJECT_COST_RATE_DATE
, DECODE(NVL(B.PROJECT_COST_RATE_DATE_TYPE
, PPFO.PROJECT_COST_RATE_DATE_TYPE)
, 'FIXED_DATE'
, PPFO.PROJECT_COST_RATE_DATE
, TO_DATE(NULL)))
, NVL(B.PROJFUNC_REV_EXCHANGE_RATE
, DECODE(NVL(B.PROJFUNC_REV_RATE_TYPE
, PPFO.PROJFUNC_REV_RATE_TYPE)
, 'USER'
, PFTC.PROJFUNC_REV_EXCHANGE_RATE
, TO_NUMBER(NULL)))
, NVL(B.PROJFUNC_REV_RATE_DATE
, DECODE(NVL(B.PROJFUNC_REV_RATE_DATE_TYPE
, PPFO.PROJFUNC_REV_RATE_DATE_TYPE)
, 'FIXED_DATE'
, PPFO.PROJFUNC_REV_RATE_DATE
, TO_DATE(NULL)))
, NVL(B.PROJECT_REV_EXCHANGE_RATE
, DECODE(NVL(B.PROJECT_REV_RATE_TYPE
, PPFO.PROJECT_REV_RATE_TYPE)
, 'USER'
, PFTC.PROJECT_REV_EXCHANGE_RATE
, TO_NUMBER(NULL)))
, NVL(B.PROJECT_REV_RATE_DATE
, DECODE(NVL(B.PROJECT_REV_RATE_DATE_TYPE
, PPFO.PROJECT_REV_RATE_DATE_TYPE)
, 'FIXED_DATE'
, PPFO.PROJECT_REV_RATE_DATE
, TO_DATE(NULL)))
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
FROM PA_PROJECTS_ALL P
, PA_BUDGET_LINES B
, PA_RESOURCE_ASSIGNMENTS PRA
, PA_TASKS PTK
, PA_RESOURCE_LISTS PRL
, PA_BUDGET_VERSIONS PBV
, PA_FP_TXN_CURRENCIES PFTC
, PA_PROJ_FP_OPTIONS PPFO
, PA_RESOURCE_LIST_MEMBERS PRLM1
, PA_RESOURCE_LIST_MEMBERS PRLM2
WHERE P.PROJECT_ID = PRA.PROJECT_ID
AND B.RESOURCE_ASSIGNMENT_ID(+)=PRA.RESOURCE_ASSIGNMENT_ID
AND PRA.TASK_ID=PTK.TASK_ID(+)
AND PRLM2.PARENT_MEMBER_ID=PRLM1.RESOURCE_LIST_MEMBER_ID(+)
AND PRLM2.RESOURCE_LIST_MEMBER_ID=PRA.RESOURCE_LIST_MEMBER_ID
AND PRA.RESOURCE_ASSIGNMENT_TYPE = 'USER_ENTERED'
AND PPFO.PROJECT_ID = PRA.PROJECT_ID
AND PPFO.FIN_PLAN_TYPE_ID = PBV.FIN_PLAN_TYPE_ID
AND PPFO.FIN_PLAN_VERSION_ID = PRA.BUDGET_VERSION_ID
AND PPFO.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION'
AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(PRA.BUDGET_VERSION_ID) NOT IN ('P'
, 'G')
AND PPFO.PROJ_FP_OPTIONS_ID=PFTC.PROJ_FP_OPTIONS_ID
AND DECODE(PPFO.FIN_PLAN_PREFERENCE_CODE
, 'COST_ONLY'
, PFTC.DEFAULT_COST_CURR_FLAG
, 'REVENUE_ONLY'
, PFTC.DEFAULT_REV_CURR_FLAG
, PFTC.DEFAULT_ALL_CURR_FLAG)= 'Y'
AND PBV.BUDGET_VERSION_ID = PRA.BUDGET_VERSION_ID
AND PRL.RESOURCE_LIST_ID = PBV.RESOURCE_LIST_ID