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

1646: BEGIN
1647:
1648: SELECT sum(nvl(capacity_quantity,0) - nvl(confirmed_qty,0))
1649: INTO l_conf_availability
1650: FROM pa_forecast_items
1651: WHERE resource_id = p_resource_id
1652: AND delete_flag = 'N'
1653: AND forecast_item_type = 'U'
1654: AND item_date between p_start_date

Line 1682: FROM pa_forecast_items

1678: BEGIN
1679:
1680: SELECT sum(nvl(capacity_quantity,0) - nvl(confirmed_qty,0) - nvl(provisional_qty,0))
1681: INTO l_prov_conf_availability
1682: FROM pa_forecast_items
1683: WHERE resource_id = p_resource_id
1684: AND delete_flag = 'N'
1685: AND forecast_item_type = 'U'
1686: AND item_date between p_start_date

Line 1782: from pa_forecast_items

1778: over ( order by item_date) as b,
1779: (nvl(capacity_quantity,0) - nvl(confirmed_qty,0))/capacity_quantity c,
1780: item_date,
1781: resource_id
1782: from pa_forecast_items
1783: where forecast_item_type = ' || '''U''' ||
1784: ' and resource_id = ' || p_resource_id || '
1785: and capacity_quantity > 0
1786: and delete_flag = ' || '''N''' || '

Line 1824: from pa_forecast_items

1820: over ( order by item_date) as b,
1821: (nvl(capacity_quantity,0) - nvl(confirmed_qty,0))/capacity_quantity c,
1822: item_date,
1823: resource_id
1824: from pa_forecast_items
1825: where forecast_item_type = :u
1826: and resource_id = :resource_id
1827: and capacity_quantity > 0
1828: and delete_flag = :n

Line 1866: from pa_forecast_items

1862: over ( order by item_date) as b,
1863: (nvl(capacity_quantity,0) - nvl(confirmed_qty,0) - nvl(provisional_qty,0))/capacity_quantity c,
1864: item_date,
1865: resource_id
1866: from pa_forecast_items
1867: where forecast_item_type = ' || '''U''' ||
1868: ' and resource_id = ' || p_resource_id || '
1869: and capacity_quantity > 0
1870: and delete_flag = ' || '''N''' || '

Line 1907: from pa_forecast_items

1903: over ( order by item_date) as b,
1904: (nvl(capacity_quantity,0) - nvl(confirmed_qty,0) - nvl(provisional_qty,0))/capacity_quantity c,
1905: item_date,
1906: resource_id
1907: from pa_forecast_items
1908: where forecast_item_type = :u
1909: and resource_id = :resource_id
1910: and capacity_quantity > 0
1911: and delete_flag = :n

Line 2200: from pa_forecast_items

2196: select (global_exp_period_end_date - 6) d,
2197: resource_id,
2198: sum(capacity_quantity) a1,
2199: sum(confirmed_qty) a2
2200: from pa_forecast_items
2201: where forecast_item_type = ' || '''U''' ||
2202: 'and resource_id = ' || p_resource_id || '
2203: and capacity_quantity > 0
2204: and delete_flag = ' || '''N''' || '

Line 2249: from pa_forecast_items

2245: select (global_exp_period_end_date - 6) d,
2246: resource_id,
2247: sum(capacity_quantity) a1,
2248: sum(confirmed_qty) a2
2249: from pa_forecast_items
2250: where forecast_item_type = :u
2251: and resource_id = :resource_id
2252: and capacity_quantity > 0
2253: and delete_flag = :n

Line 2300: from pa_forecast_items

2296: resource_id,
2297: sum(capacity_quantity) a1,
2298: sum(confirmed_qty) a2,
2299: sum(provisional_qty) a3
2300: from pa_forecast_items
2301: where forecast_item_type = ' || '''U''' ||
2302: 'and resource_id = ' || p_resource_id || '
2303: and capacity_quantity > 0
2304: and delete_flag = ' || '''N''' || '

Line 2350: from pa_forecast_items

2346: resource_id,
2347: sum(capacity_quantity) a1,
2348: sum(confirmed_qty) a2,
2349: sum(provisional_qty) a3
2350: from pa_forecast_items
2351: where forecast_item_type = :u
2352: and resource_id = :resource_id
2353: and capacity_quantity > 0
2354: and delete_flag = :n