203: CURSOR l_drpshp_count IS
204: SELECT
205: count(*)
206: FROM
207: oe_drop_ship_sources
208: WHERE po_header_id = x_movement_transaction.po_header_id
209: AND po_line_id = x_movement_transaction.po_line_id
210: AND line_location_id = x_movement_transaction.po_line_location_id
211: GROUP BY line_location_id;
230: , line_id
231: , drop_ship_source_id
232: , destination_organization_id
233: FROM
234: OE_DROP_SHIP_SOURCES
235: WHERE po_header_id = x_movement_transaction.po_header_id
236: AND po_line_id = x_movement_transaction.po_line_id
237: AND line_location_id = x_movement_transaction.po_line_location_id
238: ORDER BY line_id;