APPS.PA_RESOURCE_PVT dependencies on PA_FORECAST_ITEMS

Line 81: FROM pa_forecast_items

77: * from and to
78:
79: SELECT min(item_date)
80: INTO l_available_date
81: FROM pa_forecast_items
82: WHERE resource_id = p_resource_id
83: AND forecast_item_type = 'U'
84: AND delete_flag = 'N'
85: AND availability_flag = 'Y'

Line 1749: FROM pa_forecast_items

1745: BEGIN
1746:
1747: SELECT sum(nvl(capacity_quantity,0) - nvl(confirmed_qty,0))
1748: INTO l_conf_availability
1749: FROM pa_forecast_items
1750: WHERE resource_id = p_resource_id
1751: AND delete_flag = 'N'
1752: AND forecast_item_type = 'U'
1753: AND item_date between p_start_date

Line 1781: FROM pa_forecast_items

1777: BEGIN
1778:
1779: SELECT sum(nvl(capacity_quantity,0) - nvl(confirmed_qty,0) - nvl(provisional_qty,0))
1780: INTO l_prov_conf_availability
1781: FROM pa_forecast_items
1782: WHERE resource_id = p_resource_id
1783: AND delete_flag = 'N'
1784: AND forecast_item_type = 'U'
1785: AND item_date between p_start_date

Line 1881: from pa_forecast_items

1877: over ( order by item_date) as b,
1878: (nvl(capacity_quantity,0) - nvl(confirmed_qty,0))/capacity_quantity c,
1879: item_date,
1880: resource_id
1881: from pa_forecast_items
1882: where forecast_item_type = ' || '''U''' ||
1883: ' and resource_id = ' || p_resource_id || '
1884: and capacity_quantity > 0
1885: and delete_flag = ' || '''N''' || '

Line 1923: from pa_forecast_items

1919: over ( order by item_date) as b,
1920: (nvl(capacity_quantity,0) - nvl(confirmed_qty,0))/capacity_quantity c,
1921: item_date,
1922: resource_id
1923: from pa_forecast_items
1924: where forecast_item_type = :u
1925: and resource_id = :resource_id
1926: and capacity_quantity > 0
1927: and delete_flag = :n

Line 1965: from pa_forecast_items

1961: over ( order by item_date) as b,
1962: (nvl(capacity_quantity,0) - nvl(confirmed_qty,0) - nvl(provisional_qty,0))/capacity_quantity c,
1963: item_date,
1964: resource_id
1965: from pa_forecast_items
1966: where forecast_item_type = ' || '''U''' ||
1967: ' and resource_id = ' || p_resource_id || '
1968: and capacity_quantity > 0
1969: and delete_flag = ' || '''N''' || '

Line 2006: from pa_forecast_items

2002: over ( order by item_date) as b,
2003: (nvl(capacity_quantity,0) - nvl(confirmed_qty,0) - nvl(provisional_qty,0))/capacity_quantity c,
2004: item_date,
2005: resource_id
2006: from pa_forecast_items
2007: where forecast_item_type = :u
2008: and resource_id = :resource_id
2009: and capacity_quantity > 0
2010: and delete_flag = :n

Line 2299: from pa_forecast_items

2295: select (global_exp_period_end_date - 6) d,
2296: resource_id,
2297: sum(capacity_quantity) a1,
2298: sum(confirmed_qty) a2
2299: from pa_forecast_items
2300: where forecast_item_type = ' || '''U''' ||
2301: 'and resource_id = ' || p_resource_id || '
2302: and capacity_quantity > 0
2303: and delete_flag = ' || '''N''' || '

Line 2348: from pa_forecast_items

2344: select (global_exp_period_end_date - 6) d,
2345: resource_id,
2346: sum(capacity_quantity) a1,
2347: sum(confirmed_qty) a2
2348: from pa_forecast_items
2349: where forecast_item_type = :u
2350: and resource_id = :resource_id
2351: and capacity_quantity > 0
2352: and delete_flag = :n

Line 2399: from pa_forecast_items

2395: resource_id,
2396: sum(capacity_quantity) a1,
2397: sum(confirmed_qty) a2,
2398: sum(provisional_qty) a3
2399: from pa_forecast_items
2400: where forecast_item_type = ' || '''U''' ||
2401: 'and resource_id = ' || p_resource_id || '
2402: and capacity_quantity > 0
2403: and delete_flag = ' || '''N''' || '

Line 2449: from pa_forecast_items

2445: resource_id,
2446: sum(capacity_quantity) a1,
2447: sum(confirmed_qty) a2,
2448: sum(provisional_qty) a3
2449: from pa_forecast_items
2450: where forecast_item_type = :u
2451: and resource_id = :resource_id
2452: and capacity_quantity > 0
2453: and delete_flag = :n