APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on WSH_NEW_DELIVERIES

Line 34: or delivery_id ( wsh_new_deliveries ) based on whether delivery_id is

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: --------------------------------------------------------------------------------------
38: */

Line 121: from wsh_new_deliveries

117: FROM JAI_OM_WSH_LINES_ALL
118: WHERE delivery_id = ( SELECT
119: decode(ltrim(translate(shipment_num,'0123456789','~'),'~'),NULL,rsh.shipment_num,
120: (select delivery_id
121: from wsh_new_deliveries
122: where name=rsh.shipment_num
123: )
124:
125: )