APPS.WSH_USA_QUANTITY_PVT dependencies on MTL_SYSTEM_ITEMS

Line 247: from mtl_system_items

243: AND rownum < 2;
244:
245: CURSOR c_is_ser_control (c_item_id NUMBER, c_organization_id NUMBER) is
246: select serial_number_control_code
247: from mtl_system_items
248: where inventory_item_id = c_item_id
249: and organization_id = c_organization_id ;
250:
251: CURSOR c_shipping_parameters(c_organization_id NUMBER) IS

Line 281: from mtl_system_items

277:
278: --bug#6407943.
279: CURSOR C_item_details(c_organization_id NUMBER,c_item_id NUMBER) IS
280: SELECT primary_uom_code
281: from mtl_system_items
282: where inventory_item_id = c_item_id
283: and organization_id = c_organization_id ;
284:
285: l_primary_uom VARCHAR2(3);

Line 627: WSH_DEBUG_SV.logmsg(l_module_name, 'No records found in mtl_system_items for Item Id '||L_INVENTORY_ITEM_ID||' AND

623: OPEN c_is_ser_control(l_inventory_item_id, l_organization_id);
624: FETCH c_is_ser_control INTO l_ser_control;
625: IF c_is_ser_control%NOTFOUND THEN
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.logmsg(l_module_name, 'No records found in mtl_system_items for Item Id '||L_INVENTORY_ITEM_ID||' AND
628: organization '||L_ORGANIZATION_ID );
629: END IF;
630: raise no_data_found ;
631: END IF;