[Home] [Help]
280: --Added by Sanjikum for Bug#4533114
281: CURSOR c_hdr_attribute5_1(p_delivery_name VARCHAR2)
282: IS
283: SELECT delivery_id
284: FROM wsh_new_deliveries
285: WHERE name = p_delivery_name ;
286:
287: CURSOR c_fetch_unclaim_cenvat is
288: SELECT nvl(unclaim_cenvat_flag,'N'),
1329: 3) In the cursor - line_rec, changed the condition -
1330: "and spl.delivery_id = rsh.shipment_num"
1331: to
1332: "and spl.delivery_id = decode(ltrim(translate(shipment_num,'0123456789','~'),'~'),NULL,
1333: rsh.shipment_num,(select delivery_id from wsh_new_deliveries where name=rsh.shipment_num))"
1334:
1335: 44 19-Aug-2005 Ramananda for Bug#4562844, File Version 120.6
1336: Problem
1337: -------
4199: /*and to_char(spl.delivery_id) = rsh.shipment_num*/
4200: --and spl.delivery_id = rsh.shipment_num
4201: --commented the above and added the below by Ramananda for Bug#4533114
4202: and spl.delivery_id = decode(ltrim(translate(shipment_num,'0123456789','~'),'~'),NULL,rsh.shipment_num,
4203: (select delivery_id from wsh_new_deliveries where name=rsh.shipment_num))
4204: and spl.order_line_id = sla.line_id
4205: and prla.requisition_line_id = p_requisition_line_id
4206: AND rsh.shipment_header_id = p_shipment_header_id
4207: and rownum <= (select line_num from rcv_shipment_lines where shipment_line_id = p_shipment_line_id) -- bug#3878439