29:
30: 18/11/2008 vumaasha
31: Forward porting the changes in the 115bug 4545776
32: Changed the cursor c_source_orgn_loc to fetch shipment_num (
33: rcv_shipment_headers )
34: or delivery_id ( wsh_new_deliveries ) based on whether delivery_id is
35: number or character value respectively.
36:
37: --------------------------------------------------------------------------------------
122: where name=rsh.shipment_num
123: )
124:
125: )
126: from rcv_shipment_headers rsh
127: where shipment_header_id = cp_shipment_hdr_id
128: )
129: AND order_line_id IN ( select line_id
130: from oe_order_lines_all