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 GL_DATE_PERIOD_MAP

Line 435: gl_date_period_map dpm,

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
439: AND pfi.forecast_item_type in ('A','R','U')

Line 528: gl_date_period_map dpm,

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
532: AND pfi.forecast_item_type in ('A','R','U')