259: IF p_serial_number IS NULL THEN
260: SELECT 1 INTO l_onhand FROM dual
261: WHERE exists
262: (SELECT organization_id
263: FROM mtl_onhand_quantities_detail moq
264: WHERE (moq.lot_number = p_lot_number
265: OR (p_lot_number IS NULL AND moq.lot_number IS NULL))
266: AND (moq.revision = p_revision
267: OR (p_revision IS NULL AND moq.revision IS NULL))
824: IF p_lpn_id IS NULL THEN
825: IF p_serial_number IS NULL THEN
826: SELECT moq.cost_group_id -- Loose material, no serial control
827: INTO x_cost_group_id
828: FROM mtl_onhand_quantities_detail moq
829: WHERE (moq.lot_number = p_lot_number
830: OR (p_lot_number IS NULL AND moq.lot_number IS NULL))
831: AND (moq.revision = p_revision
832: OR (p_revision IS NULL AND moq.revision IS NULL))
876: AND wlpn.lpn_id = p_lpn_id
877: AND ROWNUM = 1
878: UNION --Bug#6133411.Added the UNION and outer SELECT as well.
879: SELECT moq.cost_group_id
880: FROM mtl_onhand_quantities_detail moq
881: WHERE (moq.lot_number = p_lot_number
882: OR (p_lot_number IS NULL AND moq.lot_number IS NULL))
883: AND (moq.revision = p_revision
884: OR (p_revision IS NULL AND moq.revision IS NULL))