APPS.PA_PLANNING_RESOURCE_UTILS dependencies on MTL_SYSTEM_ITEMS_B

Line 1242: FROM MTL_SYSTEM_ITEMS_b b

1238: * with the MTL_SYSTEM_ITEMS_tl table.
1239: *******************************************/
1240: CURSOR c_ids IS
1241: SELECT b.INVENTORY_ITEM_ID
1242: FROM MTL_SYSTEM_ITEMS_b b
1243: WHERE b.organization_id = p_item_master_id
1244: AND b.ENABLED_FLAG = 'Y'
1245: --AND b.INVENTORY_ITEM_ID = t.INVENTORY_ITEM_ID
1246: --AND b.organization_id = t.organization_id

Line 1264: FROM MTL_SYSTEM_ITEMS_b b

1260: * table.
1261: *******************************************/
1262: SELECT b.INVENTORY_ITEM_ID
1263: INTO x_item_id
1264: FROM MTL_SYSTEM_ITEMS_b b
1265: WHERE b.organization_id = p_item_master_id
1266: AND b.ENABLED_FLAG = 'Y'
1267: --AND b.INVENTORY_ITEM_ID = t.INVENTORY_ITEM_ID
1268: --AND b.organization_id = t.organization_id

Line 1329: FROM MTL_SYSTEM_ITEMS_b b

1325: * with the MTL_SYSTEM_ITEMS_tl table.
1326: *******************************************/
1327: SELECT b.INVENTORY_ITEM_ID
1328: INTO x_item_id
1329: FROM MTL_SYSTEM_ITEMS_b b
1330: WHERE b.organization_id = p_item_master_id
1331: AND b.ENABLED_FLAG = 'Y'
1332: --AND b.INVENTORY_ITEM_ID = t.INVENTORY_ITEM_ID
1333: --AND b.organization_id = t.organization_id

Line 2001: * Unit of measure from MTL_SYSTEM_ITEMS_b based on the inventory_item

1997:
1998: /***********************************************************
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: ***************************************************************/

Line 2008: FROM mtl_system_items_b items

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
2008: FROM mtl_system_items_b items
2009: WHERE items.inventory_item_id =
2010: res_temp.inventory_item_id
2011: AND items.organization_id =
2012: res_temp.organization_id

Line 2021: FROM mtl_system_items_b items

2017: AND res_temp.inventory_item_id IS NOT NULL;
2018:
2019: UPDATE pa_res_members_temp res_temp
2020: SET unit_of_measure = (SELECT primary_uom_code
2021: FROM mtl_system_items_b items
2022: WHERE items.inventory_item_id =
2023: res_temp.inventory_item_id
2024: AND items.organization_id =
2025: (SELECT def.item_master_id

Line 2261: FROM mtl_system_items_b i

2257: * We are deriving the value for organization_id
2258: * ***************************************************/
2259: UPDATE pa_res_members_temp res_temp
2260: SET organization_id = (SELECT i.organization_id
2261: FROM mtl_system_items_b i
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,

Line 2341: from mtl_system_items_b item,

2337: WHERE res_temp.resource_class_code
2338: = 'MATERIAL_ITEMS'
2339: AND res_temp.inventory_item_id IS NOT NULL
2340: AND NOT EXISTS (select 'Y'
2341: from mtl_system_items_b item,
2342: mtl_units_of_measure meas
2343: where item.inventory_item_id =
2344: res_temp.inventory_item_id
2345: and item.primary_uom_code = meas.uom_code

Line 2980: * segment1 field from Mtl_System_Items_b table as the

2976:
2977: /**********************************************************
2978: * Bug - 3566965
2979: * Desc - Instead of the description we are now selecting the
2980: * segment1 field from Mtl_System_Items_b table as the
2981: * resource name.
2982: **********************************************************/
2983: Cursor c_Inven_Item (P_Inven_Item_Id IN Number ) Is
2984: Select

Line 2987: Mtl_System_Items_b

2983: Cursor c_Inven_Item (P_Inven_Item_Id IN Number ) Is
2984: Select
2985: segment1
2986: From
2987: Mtl_System_Items_b
2988: Where
2989: --Language = USERENV('LANG')
2990: Inventory_Item_Id = P_Inven_Item_Id
2991: and organization_id =

Line 7330: from mtl_system_items_b item,

7326: SELECT 'Y'
7327: INTO l_rate_based_flag
7328: FROM dual
7329: WHERE NOT EXISTS (select 'Y'
7330: from mtl_system_items_b item,
7331: mtl_units_of_measure meas
7332: where item.inventory_item_id =
7333: l_res_details.inventory_item_id
7334: and item.primary_uom_code = meas.uom_code