[Home] [Help]
258: --Added by Sanjikum for Bug#4533114
259: CURSOR c_hdr_attribute5_1(p_delivery_name VARCHAR2)
260: IS
261: SELECT delivery_id
262: FROM wsh_new_deliveries
263: WHERE name = p_delivery_name ;
264:
265: CURSOR c_fetch_unclaim_cenvat is
266: SELECT nvl(unclaim_cenvat_flag,'N'),
1237: 3) In the cursor - line_rec, changed the condition -
1238: "and spl.delivery_id = rsh.shipment_num"
1239: to
1240: "and spl.delivery_id = decode(ltrim(translate(shipment_num,'0123456789','~'),'~'),NULL,
1241: rsh.shipment_num,(select delivery_id from wsh_new_deliveries where name=rsh.shipment_num))"
1242:
1243: 44 19-Aug-2005 Ramananda for Bug#4562844, File Version 120.6
1244: Problem
1245: -------
3065: /*and to_char(spl.delivery_id) = rsh.shipment_num*/
3066: --and spl.delivery_id = rsh.shipment_num
3067: --commented the above and added the below by Ramananda for Bug#4533114
3068: and spl.delivery_id = decode(ltrim(translate(shipment_num,'0123456789','~'),'~'),NULL,rsh.shipment_num,
3069: (select delivery_id from wsh_new_deliveries where name=rsh.shipment_num))
3070: and spl.order_line_id = sla.line_id
3071: and prla.requisition_line_id = p_requisition_line_id
3072: AND rsh.shipment_header_id = p_shipment_header_id
3073: and rownum <= (select line_num from rcv_shipment_lines where shipment_line_id = p_shipment_line_id) -- bug#3878439