APPS.INV_MO_CANCEL_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1258: FROM mtl_system_items

1254: FOR UPDATE;
1255:
1256: CURSOR c_primary_uom IS
1257: SELECT primary_uom_code
1258: FROM mtl_system_items
1259: WHERE organization_id = l_organization_id
1260: AND inventory_item_id = l_inventory_item_id;
1261:
1262: /*Bug#5095840. Added the below cursor to fetch the source line id

Line 2283: FROM mtl_system_items

2279: l_retain_ato_profile VARCHAR2(1) := NVL(fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS'),'N'); --Bug 7190635
2280:
2281: CURSOR c_primary_uom IS
2282: SELECT primary_uom_code
2283: FROM mtl_system_items
2284: WHERE organization_id = l_organization_id
2285: AND inventory_item_id = l_inventory_item_id;
2286:
2287: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);