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.

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_FORECAST_ITEMS

Line 227: l_pfi_assignment_id pa_forecast_items.assignment_id%TYPE;

223: l_org_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
224: l_own_task_id pa_tasks.task_id%TYPE;
225: l_prob_percent pa_probability_members.probability_percentage%TYPE;
226: l_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;
227: l_pfi_assignment_id pa_forecast_items.assignment_id%TYPE;
228: l_pfi_resource_id pa_forecast_items.resource_id%TYPE;
229: l_own_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
230: l_proj_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
231: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;

Line 228: l_pfi_resource_id pa_forecast_items.resource_id%TYPE;

224: l_own_task_id pa_tasks.task_id%TYPE;
225: l_prob_percent pa_probability_members.probability_percentage%TYPE;
226: l_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;
227: l_pfi_assignment_id pa_forecast_items.assignment_id%TYPE;
228: l_pfi_resource_id pa_forecast_items.resource_id%TYPE;
229: l_own_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
230: l_proj_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
231: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
232: l_prv_forecast_element_id pa_org_fcst_elements.forecast_element_id%TYPE;

Line 434: FROM pa_forecast_items pfi,

430: DECODE(pfi.project_organization_id,l_organization_id,
431: DECODE(pfi.project_org_id,l_org_id,
432: DECODE(pfi.tp_amount_type,'REVENUE_TRANSFER',
433: NVL(sum(pfi.projfunc_transfer_price),0),0),0),0) tp_rev_out
434: FROM pa_forecast_items pfi,
435: gl_date_period_map dpm,
436: gl_periods gp
437: WHERE pfi.project_organization_id = l_organization_id
438: and nvl(pfi.project_org_id,-99) = l_org_id

Line 527: FROM pa_forecast_items pfi,

523: DECODE(pfi.project_organization_id,l_organization_id,
524: DECODE(pfi.project_org_id,l_org_id,
525: DECODE(pfi.tp_amount_type,'REVENUE_TRANSFER',
526: NVL(sum(pfi.projfunc_transfer_price),0),0),0),0) tp_rev_out
527: FROM pa_forecast_items pfi,
528: gl_date_period_map dpm,
529: gl_periods gp
530: WHERE pfi.expenditure_organization_id = l_organization_id
531: and nvl(pfi.expenditure_org_id,-99) = l_org_id