DBA Data[Home] [Help]

APPS.MRP_RELEASE_SO dependencies on MTL_SYSTEM_ITEMS

Line 31: from mtl_system_items

27:
28:
29: CURSOR mtl_primary_uom (p_item_id NUMBER, p_org_id NUMBER) IS
30: select primary_uom_code
31: from mtl_system_items
32: where inventory_item_id = p_item_id
33: and organization_id = p_org_id;
34:
35: CURSOR ord_num_c(p_line_id number) IS

Line 424: p_uom_code || ' mtl_system_items UOM, primary UOM = '|| l_primary_uom_code);

420: CLOSE mtl_primary_uom;
421:
422: IF p_uom_code <> l_primary_uom_code THEN
423: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UOM code is different : OM UOM = ' ||
424: p_uom_code || ' mtl_system_items UOM, primary UOM = '|| l_primary_uom_code);
425: -- convert the qty from ascp workbench back to OM qty
426: l_converted_qty :=
427: inv_convert.inv_um_convert(p_so_table(i).inventory_item_id,
428: 6,