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 2459: FROM pa_forecast_items

2455: BEGIN
2456:
2457: SELECT sum(capacity_quantity)
2458: INTO capacity
2459: FROM pa_forecast_items
2460: WHERE resource_id = res_id
2461: AND delete_flag = 'N'
2462: AND forecast_item_type = 'U'
2463: AND item_date between week_start_date

Line 3306: FROM pa_forecast_items

3302: BEGIN
3303:
3304: SELECT sum(capacity_quantity)
3305: INTO l_capacity
3306: FROM pa_forecast_items
3307: WHERE resource_id = p_resource_id
3308: AND delete_flag = 'N'
3309: AND forecast_item_type = 'U'
3310: AND item_date between p_start_date

Line 3545: from pa_forecast_items pfi

3541: l_date2,
3542: g_provisional_hours,
3543: g_confirmed_hours,
3544: l_resource_id
3545: from pa_forecast_items pfi
3546: where pfi.forecast_item_type = 'A'
3547: and pfi.delete_flag = 'N'
3548: and pfi.resource_id = p_resource_id
3549: and pfi.item_date = p_week_date