DBA Data[Home] [Help]

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: 14-aug-2009 vkaranam for bug#4750798
37: fwdported the changes done in 115 bug 4619176 /7229349
38: I havent considered shcess changes in 7229349 fix as all shcess changes are not fped.

Line 136: from wsh_new_deliveries

132: FROM JAI_OM_WSH_LINES_ALL
133: WHERE delivery_id = ( SELECT
134: decode(ltrim(translate(shipment_num,'0123456789','~'),'~'),NULL,rsh.shipment_num,
135: (select delivery_id
136: from wsh_new_deliveries
137: where name=rsh.shipment_num
138: )
139:
140: )