APPS.WSH_USA_QUANTITY_PVT dependencies on MTL_SYSTEM_ITEMS

Line 271: from mtl_system_items

267: AND rownum < 2;
268:
269: CURSOR c_is_ser_control (c_item_id NUMBER, c_organization_id NUMBER) is
270: select serial_number_control_code
271: from mtl_system_items
272: where inventory_item_id = c_item_id
273: and organization_id = c_organization_id ;
274:
275: CURSOR c_shipping_parameters(c_organization_id NUMBER) IS

Line 305: from mtl_system_items

301:
302: --bug#6407943.
303: CURSOR C_item_details(c_organization_id NUMBER,c_item_id NUMBER) IS
304: SELECT primary_uom_code
305: from mtl_system_items
306: where inventory_item_id = c_item_id
307: and organization_id = c_organization_id ;
308:
309: l_primary_uom VARCHAR2(3);

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

683: OPEN c_is_ser_control(l_inventory_item_id, l_organization_id);
684: FETCH c_is_ser_control INTO l_ser_control;
685: IF c_is_ser_control%NOTFOUND THEN
686: IF l_debug_on THEN
687: WSH_DEBUG_SV.logmsg(l_module_name, 'No records found in mtl_system_items for Item Id '||L_INVENTORY_ITEM_ID||' AND
688: organization '||L_ORGANIZATION_ID );
689: END IF;
690: raise no_data_found ;
691: END IF;