197: CURSOR l_drpshp_count IS
198: SELECT
199: count(*)
200: FROM
201: oe_drop_ship_sources
202: WHERE po_header_id = x_movement_transaction.po_header_id
203: AND po_line_id = x_movement_transaction.po_line_id
204: AND line_location_id = x_movement_transaction.po_line_location_id
205: GROUP BY line_location_id;
224: , line_id
225: , drop_ship_source_id
226: , destination_organization_id
227: FROM
228: OE_DROP_SHIP_SOURCES
229: WHERE po_header_id = x_movement_transaction.po_header_id
230: AND po_line_id = x_movement_transaction.po_line_id
231: AND line_location_id = x_movement_transaction.po_line_location_id
232: ORDER BY line_id;