DBA Data[Home] [Help]

APPS.CSP_VALIDATE_PUB dependencies on MTL_RESERVATIONS

Line 230: from mtl_reservations

226: IF l_serial_status = 3 THEN
227: l_onhand_qty := 1;
228: -- check whether the item with that specified serial number is reserved
229: select count(inventory_item_id) into l_count_qty
230: from mtl_reservations
231: where inventory_item_id = p_inventory_item_id
232: and organization_id = p_organization_id
233: and serial_number = p_serial_number;
234: