APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_PLAN_RES_DEFAULTS

Line 23: from pa_plan_res_defaults

19: where ((exists (select 'Y'
20: from pa_resource_list_members
21: where spread_curve_id = p_spread_curve_id))
22: OR (exists (select 'Y'
23: from pa_plan_res_defaults
24: where spread_curve_id = p_spread_curve_id)));
25:
26: l_exists VARCHAR2(1) := 'N';
27: l_return BOOLEAN := FALSE;

Line 1699: FROM pa_plan_res_defaults def

1695:
1696: BEGIN
1697: SELECT def.item_category_set_id
1698: INTO l_item_category_set_id
1699: FROM pa_plan_res_defaults def
1700: -- , pa_resource_classes_b cl
1701: WHERE def.resource_class_id = 3
1702: AND def.object_type ='CLASS';
1703: --AND cl.resource_class_id = def.resource_class_id

Line 1741: FROM pa_plan_res_defaults def

1737: ELSIF p_res_type_code = 'INVENTORY_ITEM' THEN
1738: BEGIN
1739: SELECT def.item_master_id
1740: INTO l_item_master_id
1741: FROM pa_plan_res_defaults def
1742: -- , pa_resource_classes_b cl
1743: WHERE def.resource_class_id = 3
1744: AND def.object_type ='CLASS';
1745: --AND cl.resource_class_id = def.resource_class_id

Line 1962: FROM pa_plan_res_defaults

1958: else
1959: UPDATE pa_res_members_temp res_temp
1960: SET res_temp.rate_expenditure_type =
1961: (SELECT expenditure_type
1962: FROM pa_plan_res_defaults
1963: WHERE resource_class_id =
1964: res_temp.resource_class_id
1965: AND ROWNUM = 1
1966: AND object_type = 'CLASS')

Line 2043: * pa_plan_res_defaults. If the planning resource has an organization,

2039: * If the resource class code is 'MATERIAL_ITEMS' and the
2040: * Inventory_item_id is not null then we need to derive the
2041: * Unit of measure from MTL_SYSTEM_ITEMS_b based on the inventory_item
2042: * And Organization id that matches the master_item_id in
2043: * pa_plan_res_defaults. If the planning resource has an organization,
2044: * use that; if not, use item master.
2045: ***************************************************************/
2046: UPDATE pa_res_members_temp res_temp
2047: SET unit_of_measure = (SELECT primary_uom_code

Line 2067: pa_plan_res_defaults def

2063: res_temp.inventory_item_id
2064: AND items.organization_id =
2065: (SELECT def.item_master_id
2066: FROM pa_resource_classes_b cls,
2067: pa_plan_res_defaults def
2068: WHERE cls.resource_class_code = 'MATERIAL_ITEMS'
2069: AND cls.resource_class_id = def.resource_class_id
2070: AND def.object_type = 'CLASS')
2071: AND ROWNUM = 1)

Line 2306: pa_plan_res_defaults def

2302: WHERE i.inventory_item_id = res_temp.inventory_item_id
2303: AND i.organization_id =
2304: (SELECT def.item_master_id
2305: FROM pa_resource_classes_b cls,
2306: pa_plan_res_defaults def
2307: WHERE cls.resource_class_code = 'MATERIAL_ITEMS'
2308: AND cls.resource_class_id = def.resource_class_id
2309: AND def.object_type = 'CLASS')
2310: AND ROWNUM = 1)

Line 3037: pa_plan_res_defaults def

3033: (select
3034: item_master_id
3035: from
3036: pa_resource_classes_b cls,
3037: pa_plan_res_defaults def
3038: where
3039: def.resource_class_id = cls.resource_class_id
3040: and cls.resource_class_code = 'MATERIAL_ITEMS'
3041: and def.object_type = 'CLASS');