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_RESOURCE_UTILS dependencies on PA_FORECAST_ITEMS

Line 2342: FROM pa_forecast_items

2338: BEGIN
2339:
2340: SELECT sum(capacity_quantity)
2341: INTO capacity
2342: FROM pa_forecast_items
2343: WHERE resource_id = res_id
2344: AND delete_flag = 'N'
2345: AND forecast_item_type = 'U'
2346: AND item_date between week_start_date

Line 3045: FROM pa_forecast_items

3041: BEGIN
3042:
3043: SELECT sum(capacity_quantity)
3044: INTO l_capacity
3045: FROM pa_forecast_items
3046: WHERE resource_id = p_resource_id
3047: AND delete_flag = 'N'
3048: AND forecast_item_type = 'U'
3049: AND item_date between p_start_date

Line 3284: from pa_forecast_items pfi

3280: l_date2,
3281: g_provisional_hours,
3282: g_confirmed_hours,
3283: l_resource_id
3284: from pa_forecast_items pfi
3285: where pfi.forecast_item_type = 'A'
3286: and pfi.delete_flag = 'N'
3287: and pfi.resource_id = p_resource_id
3288: and pfi.item_date = p_week_date