APPS.PA_PLANNING_RESOURCE_UTILS dependencies on MTL_SYSTEM_ITEMS_B

Line 1246: FROM MTL_SYSTEM_ITEMS_b b

1242: * with the MTL_SYSTEM_ITEMS_tl table.
1243: *******************************************/
1244: CURSOR c_ids IS
1245: SELECT b.INVENTORY_ITEM_ID
1246: FROM MTL_SYSTEM_ITEMS_b b
1247: WHERE b.organization_id = p_item_master_id
1248: AND b.ENABLED_FLAG = 'Y'
1249: --AND b.INVENTORY_ITEM_ID = t.INVENTORY_ITEM_ID
1250: --AND b.organization_id = t.organization_id

Line 1268: FROM MTL_SYSTEM_ITEMS_b b

1264: * table.
1265: *******************************************/
1266: SELECT b.INVENTORY_ITEM_ID
1267: INTO x_item_id
1268: FROM MTL_SYSTEM_ITEMS_b b
1269: WHERE b.organization_id = p_item_master_id
1270: AND b.ENABLED_FLAG = 'Y'
1271: --AND b.INVENTORY_ITEM_ID = t.INVENTORY_ITEM_ID
1272: --AND b.organization_id = t.organization_id

Line 1333: FROM MTL_SYSTEM_ITEMS_b b

1329: * with the MTL_SYSTEM_ITEMS_tl table.
1330: *******************************************/
1331: SELECT b.INVENTORY_ITEM_ID
1332: INTO x_item_id
1333: FROM MTL_SYSTEM_ITEMS_b b
1334: WHERE b.organization_id = p_item_master_id
1335: AND b.ENABLED_FLAG = 'Y'
1336: --AND b.INVENTORY_ITEM_ID = t.INVENTORY_ITEM_ID
1337: --AND b.organization_id = t.organization_id

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

2037:
2038: /***********************************************************
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: ***************************************************************/

Line 2048: FROM mtl_system_items_b items

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
2048: FROM mtl_system_items_b items
2049: WHERE items.inventory_item_id =
2050: res_temp.inventory_item_id
2051: AND items.organization_id =
2052: res_temp.organization_id

Line 2061: FROM mtl_system_items_b items

2057: AND res_temp.inventory_item_id IS NOT NULL;
2058:
2059: UPDATE pa_res_members_temp res_temp
2060: SET unit_of_measure = (SELECT primary_uom_code
2061: FROM mtl_system_items_b items
2062: WHERE items.inventory_item_id =
2063: res_temp.inventory_item_id
2064: AND items.organization_id =
2065: (SELECT def.item_master_id

Line 2301: FROM mtl_system_items_b i

2297: * We are deriving the value for organization_id
2298: * ***************************************************/
2299: UPDATE pa_res_members_temp res_temp
2300: SET organization_id = (SELECT i.organization_id
2301: FROM mtl_system_items_b i
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,

Line 2381: from mtl_system_items_b item,

2377: WHERE res_temp.resource_class_code
2378: = 'MATERIAL_ITEMS'
2379: AND res_temp.inventory_item_id IS NOT NULL
2380: AND NOT EXISTS (select 'Y'
2381: from mtl_system_items_b item,
2382: mtl_units_of_measure meas
2383: where item.inventory_item_id =
2384: res_temp.inventory_item_id
2385: and item.organization_id = res_temp.organization_id -- bug 10121923

Line 3021: * segment1 field from Mtl_System_Items_b table as the

3017:
3018: /**********************************************************
3019: * Bug - 3566965
3020: * Desc - Instead of the description we are now selecting the
3021: * segment1 field from Mtl_System_Items_b table as the
3022: * resource name.
3023: **********************************************************/
3024: Cursor c_Inven_Item (P_Inven_Item_Id IN Number ) Is
3025: Select

Line 3028: Mtl_System_Items_b

3024: Cursor c_Inven_Item (P_Inven_Item_Id IN Number ) Is
3025: Select
3026: segment1
3027: From
3028: Mtl_System_Items_b
3029: Where
3030: --Language = USERENV('LANG')
3031: Inventory_Item_Id = P_Inven_Item_Id
3032: and organization_id =

Line 7488: from mtl_system_items_b item,

7484: SELECT 'Y'
7485: INTO l_rate_based_flag
7486: FROM dual
7487: WHERE NOT EXISTS (select 'Y'
7488: from mtl_system_items_b item,
7489: mtl_units_of_measure meas
7490: where item.inventory_item_id =
7491: l_res_details.inventory_item_id
7492: and item.primary_uom_code = meas.uom_code