259: rsl.unit_of_measure,
260: rsl.primary_unit_of_measure,
261: rsl.to_organization_id
262: FROM rcv_shipment_lines rsl,
263: rcv_supply rs
264: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
265: AND ( p_organization_id IS NULL
266: OR p_organization_id = rsl.to_organization_id)
267: AND ( p_item_id IS NULL
346: rsl.unit_of_measure,
347: rsl.primary_unit_of_measure,
348: rsl.to_organization_id
349: FROM rcv_shipment_lines rsl,
350: rcv_supply rs
351: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
352: AND ( p_organization_id IS NULL
353: OR p_organization_id = rsl.to_organization_id)
354: AND ( p_item_id IS NULL
444: rsl.unit_of_measure,
445: rsl.primary_unit_of_measure,
446: rsl.to_organization_id
447: FROM rcv_shipment_lines rsl,
448: rcv_supply rs
449: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
450: AND ( p_organization_id IS NULL
451: OR p_organization_id = rsl.to_organization_id)
452: AND ( p_item_id IS NULL
561: rsl.unit_of_measure,
562: rsl.primary_unit_of_measure,
563: rsl.to_organization_id
564: FROM rcv_shipment_lines rsl,
565: rcv_supply rs
566: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
567: AND ( p_organization_id IS NULL
568: OR p_organization_id = rsl.to_organization_id)
569: AND ( p_item_id IS NULL