APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_PLAN_RES_DEFAULTS

Line 19: from pa_plan_res_defaults

15: where ((exists (select 'Y'
16: from pa_resource_list_members
17: where spread_curve_id = p_spread_curve_id))
18: OR (exists (select 'Y'
19: from pa_plan_res_defaults
20: where spread_curve_id = p_spread_curve_id)));
21:
22: l_exists VARCHAR2(1) := 'N';
23: l_return BOOLEAN := FALSE;

Line 1686: FROM pa_plan_res_defaults def

1682:
1683: BEGIN
1684: SELECT def.item_category_set_id
1685: INTO l_item_category_set_id
1686: FROM pa_plan_res_defaults def
1687: -- , pa_resource_classes_b cl
1688: WHERE def.resource_class_id = 3
1689: AND def.object_type ='CLASS';
1690: --AND cl.resource_class_id = def.resource_class_id

Line 1728: FROM pa_plan_res_defaults def

1724: ELSIF p_res_type_code = 'INVENTORY_ITEM' THEN
1725: BEGIN
1726: SELECT def.item_master_id
1727: INTO l_item_master_id
1728: FROM pa_plan_res_defaults def
1729: -- , pa_resource_classes_b cl
1730: WHERE def.resource_class_id = 3
1731: AND def.object_type ='CLASS';
1732: --AND cl.resource_class_id = def.resource_class_id

Line 1924: FROM pa_plan_res_defaults

1920: * **************************************************/
1921: UPDATE pa_res_members_temp res_temp
1922: SET res_temp.rate_expenditure_type =
1923: (SELECT expenditure_type
1924: FROM pa_plan_res_defaults
1925: WHERE resource_class_id =
1926: res_temp.resource_class_id
1927: AND ROWNUM = 1
1928: AND object_type = 'CLASS')

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

1999: * If the resource class code is 'MATERIAL_ITEMS' and the
2000: * Inventory_item_id is not null then we need to derive the
2001: * Unit of measure from MTL_SYSTEM_ITEMS_b based on the inventory_item
2002: * And Organization id that matches the master_item_id in
2003: * pa_plan_res_defaults. If the planning resource has an organization,
2004: * use that; if not, use item master.
2005: ***************************************************************/
2006: UPDATE pa_res_members_temp res_temp
2007: SET unit_of_measure = (SELECT primary_uom_code

Line 2027: pa_plan_res_defaults def

2023: res_temp.inventory_item_id
2024: AND items.organization_id =
2025: (SELECT def.item_master_id
2026: FROM pa_resource_classes_b cls,
2027: pa_plan_res_defaults def
2028: WHERE cls.resource_class_code = 'MATERIAL_ITEMS'
2029: AND cls.resource_class_id = def.resource_class_id
2030: AND def.object_type = 'CLASS')
2031: AND ROWNUM = 1)

Line 2266: pa_plan_res_defaults def

2262: WHERE i.inventory_item_id = res_temp.inventory_item_id
2263: AND i.organization_id =
2264: (SELECT def.item_master_id
2265: FROM pa_resource_classes_b cls,
2266: pa_plan_res_defaults def
2267: WHERE cls.resource_class_code = 'MATERIAL_ITEMS'
2268: AND cls.resource_class_id = def.resource_class_id
2269: AND def.object_type = 'CLASS')
2270: AND ROWNUM = 1)

Line 2996: pa_plan_res_defaults def

2992: (select
2993: item_master_id
2994: from
2995: pa_resource_classes_b cls,
2996: pa_plan_res_defaults def
2997: where
2998: def.resource_class_id = cls.resource_class_id
2999: and cls.resource_class_code = 'MATERIAL_ITEMS'
3000: and def.object_type = 'CLASS');