APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 33: rcv_shipment_headers )

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: 14-aug-2009 vkaranam for bug#4750798
37: fwdported the changes done in 115 bug 4619176 /7229349

Line 141: from rcv_shipment_headers rsh

137: where name=rsh.shipment_num
138: )
139:
140: )
141: from rcv_shipment_headers rsh
142: where shipment_header_id = cp_shipment_hdr_id
143: )
144: AND order_line_id IN ( select line_id
145: from oe_order_lines_all