eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on OE_ORDER_LINES

Line 205: FROM OE_ORDER_LINES

201: l_item_type_code,
202: l_line_set_id,
203: l_ship_from_org_id,
204: l_ordered_quantity2
205: FROM OE_ORDER_LINES
206: WHERE line_id = p_req_qty_tbl(J).line_id;
207:
208: IF l_debug_level > 0 THEN
209: oe_debug_pub.add( 'REQUESTED/ORDER QUANTITY : '||P_REQ_QTY_TBL ( J ) .REQUESTED_QUANTITY||'/'||L_ORDERED_QUANTITY , 3

Line 482: FROM oe_order_lines

478: LOOP
479:
480: SELECT top_model_line_id
481: INTO l_top_model_line_id
482: FROM oe_order_lines
483: WHERE line_id = p_line_tbl(J).line_id;
484:
485:
486: l_line_id_mod := mod(p_line_tbl(J).line_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918

Line 501: FROM oe_order_lines

497: END IF;
498:
499: SELECT top_model_line_id
500: INTO l_top_model_line_id
501: FROM oe_order_lines
502: WHERE line_id = l_top_model_line_id
503: FOR UPDATE NOWAIT;
504:
505: IF l_debug_level > 0 THEN

Line 545: FROM OE_ORDER_LINES

541: l_item_type_code,
542: l_header_id,
543: l_calculate_price_flag,
544: l_smc_flag
545: FROM OE_ORDER_LINES
546: WHERE line_id = p_line_tbl(J).line_id
547: FOR UPDATE NOWAIT;
548:
549: l_ship_set_id_mod := mod(l_ship_set_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918

Line 797: FROM oe_order_lines

793: THEN
794:
795: SELECT ato_line_id
796: INTO l_count
797: FROM oe_order_lines
798: WHERE line_id = l_top_model_line_id;
799:
800: IF l_count is NULL THEN
801:

Line 811: FROM OE_ORDER_LINES

807:
808: --bug3480047 contd
809: SELECT COUNT(*)
810: INTO l_shippable_lines
811: FROM OE_ORDER_LINES
812: WHERE top_model_line_id = l_top_model_line_id
813: AND NVL(CANCELLED_FLAG,'N')='N'
814: AND NVL(SHIPPABLE_FLAG,'N')='Y';
815:

Line 820: FROM oe_order_lines

816: IF l_shippable_lines > 1 THEN
817:
818: SELECT count(*)
819: INTO l_count
820: FROM oe_order_lines
821: WHERE top_model_line_id = l_top_model_line_id
822: AND cancelled_flag = 'N'
823: AND source_type_code = 'EXTERNAL';
824:

Line 841: FROM oe_order_lines oe1

837:
838: /* MOAC_SQL_CHANGE */
839: SELECT count(*)
840: INTO l_count
841: FROM oe_order_lines oe1
842: WHERE top_model_line_id = l_top_model_line_id
843: AND ato_line_id = line_id
844: AND item_type_code = 'CLASS'
845: AND cancelled_flag = 'N'

Line 848: FROM oe_order_lines_all

844: AND item_type_code = 'CLASS'
845: AND cancelled_flag = 'N'
846: AND not exists
847: (SELECT NULL
848: FROM oe_order_lines_all
849: WHERE top_model_line_id = l_top_model_line_id
850: AND ato_line_id = oe1.line_id
851: AND cancelled_flag = 'N'
852: AND item_type_code = 'CONFIG');

Line 869: FROM oe_order_lines

865: SELECT 1 INTO l_count
866: FROM DUAL
867: WHERE EXISTS (
868: SELECT NULL
869: FROM oe_order_lines
870: WHERE top_model_line_id = l_top_model_line_id
871: AND cancelled_flag = 'N'
872: AND schedule_ship_date is NULL);
873: EXCEPTION

Line 890: UPDATE oe_order_lines

886: IF l_make_remnant = 'Y' THEN -- bug 4701487
887: IF l_debug_level > 0 THEN
888: oe_debug_pub.add( 'Making the model REMNANT:'|| L_TOP_MODEL_LINE_ID , 3 ) ;
889: END IF;
890: UPDATE oe_order_lines
891: SET model_remnant_flag = 'Y'
892: WHERE top_model_line_id = l_top_model_line_id;
893:
894: l_model_remnant_flag := 'Y';

Line 1053: UPDATE OE_ORDER_LINES

1049: l_line_tbl(J).ship_tolerance_below := l_ship_tolerance_below_upd;
1050: l_notify := TRUE;
1051: END IF; /* need to update global picture */
1052:
1053: UPDATE OE_ORDER_LINES
1054: SET shipping_quantity = p_line_tbl(J).shipping_quantity,
1055: shipping_quantity2 = p_line_tbl(J).shipping_quantity2,
1056: shipped_quantity2 = p_line_tbl(J).shipping_quantity2,
1057: shipping_quantity_uom = p_line_tbl(J).shipping_quantity_uom,

Line 1107: UPDATE OE_ORDER_LINES

1103:
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'CALCULATE PRICE FLAG : '||L_CALCULATE_PRICE_FLAG , 3 ) ;
1106: END IF;
1107: UPDATE OE_ORDER_LINES
1108: SET shipping_quantity = p_line_tbl(J).shipping_quantity,
1109: shipping_quantity2 = p_line_tbl(J).shipping_quantity2,
1110: shipped_quantity2 = p_line_tbl(J).shipping_quantity2,
1111: shipping_quantity_uom = p_line_tbl(J).shipping_quantity_uom,

Line 2003: FROM oe_order_lines_all

1999: AND p_ship_line_rec.model_remnant_flag(p_index) = 'Y' THEN
2000:
2001: SELECT item_type_code
2002: INTO l_line_tbl(1).item_type_code
2003: FROM oe_order_lines_all
2004: WHERE line_id = p_ship_line_rec.ato_line_id(p_index);
2005:
2006: l_line_tbl(1).line_id := p_ship_line_rec.ato_line_id(p_index);
2007: l_line_tbl(1).ato_line_id := p_ship_line_rec.ato_line_id(p_index);

Line 2272: FROM oe_order_lines

2268: SELECT line_id, ordered_quantity
2269: ,ordered_quantity2 -- bug 12731457
2270: ,header_id, actual_shipment_date, order_firmed_date
2271: ,blanket_number,blanket_line_number,blanket_version_number
2272: FROM oe_order_lines
2273: WHERE top_model_line_id = p_top_model_line_id
2274: AND nvl(ato_line_id,-99) = -99 /*added for bug 6640292*/
2275: AND shippable_flag = 'N'
2276: AND model_remnant_flag = 'Y';

Line 2489: UPDATE oe_order_lines

2485: END IF;
2486:
2487: IF p_ato_only = 'Y' THEN
2488:
2489: UPDATE oe_order_lines
2490: SET shipped_quantity = (ordered_quantity *
2491: p_ship_line_rec.shipped_quantity(p_index)/
2492: p_ship_line_rec.ordered_quantity(p_index))
2493: ,actual_shipment_date

Line 2738: FROM oe_order_lines

2734: l_line_model_ordered_qty NUMBER; --added for bug 8774783
2735:
2736: CURSOR shipped_lines IS
2737: SELECT line_id, ordered_quantity, shipped_quantity
2738: FROM oe_order_lines
2739: WHERE shippable_flag = 'Y'
2740: AND shipped_quantity is NOT NULL
2741: AND top_model_line_id = p_top_model_line_id;
2742: BEGIN

Line 2746: FROM oe_order_lines

2742: BEGIN
2743:
2744: SELECT count(*)
2745: INTO l_count1
2746: FROM oe_order_lines
2747: WHERE top_model_line_id = p_top_model_line_id
2748: AND cancelled_flag = 'N'
2749: AND shippable_flag = 'Y';
2750:

Line 2762: FROM oe_order_lines

2758: -- if ato+pto with external lines, make it remnant.
2759: IF l_count1 > 1 THEN
2760: SELECT count(*)
2761: INTO l_count
2762: FROM oe_order_lines
2763: WHERE top_model_line_id = p_top_model_line_id
2764: AND cancelled_flag = 'N'
2765: AND source_type_code = 'EXTERNAL';
2766:

Line 2784: FROM oe_order_lines oe1

2780:
2781: /* MOAC_SQL_CHANGE */
2782: SELECT count(*)
2783: INTO l_count
2784: FROM oe_order_lines oe1
2785: WHERE top_model_line_id = p_top_model_line_id
2786: AND ato_line_id = line_id
2787: AND item_type_code = 'CLASS'
2788: AND cancelled_flag = 'N'

Line 2791: FROM oe_order_lines_all

2787: AND item_type_code = 'CLASS'
2788: AND cancelled_flag = 'N'
2789: AND not exists
2790: (SELECT NULL
2791: FROM oe_order_lines_all
2792: WHERE top_model_line_id = p_top_model_line_id
2793: AND ato_line_id = oe1.line_id
2794: AND cancelled_flag = 'N'
2795: AND item_type_code = 'CONFIG');

Line 2812: FROM oe_order_lines

2808: SELECT 1 INTO l_count
2809: FROM DUAL
2810: WHERE EXISTS (
2811: SELECT NULL
2812: FROM oe_order_lines
2813: WHERE top_model_line_id = p_top_model_line_id
2814: AND cancelled_flag = 'N'
2815: AND schedule_ship_date is NULL);
2816: EXCEPTION

Line 2834: UPDATE oe_order_lines

2830: IF l_debug_level > 0 THEN
2831: oe_debug_pub.add( 'Making the model REMNANT:'|| p_TOP_MODEL_LINE_ID , 2) ;
2832: END IF;
2833:
2834: UPDATE oe_order_lines
2835: SET model_remnant_flag = 'Y'
2836: ,lock_control = lock_control + 1
2837: WHERE top_model_line_id = p_top_model_line_id
2838: AND cancelled_flag = 'N';

Line 2856: FROM oe_order_lines

2852: IF l_model_remnant_flag = 'N' THEN
2853:
2854: SELECT count(*)
2855: INTO l_count
2856: FROM oe_order_lines
2857: WHERE top_model_line_id = p_top_model_line_id
2858: AND shippable_flag = 'Y'
2859: AND NVL(CANCELLED_FLAG,'N')='N' --9822866
2860: AND shipped_quantity is NULL;

Line 2873: FROM oe_order_lines oe1

2869:
2870: /* MOAC_SQL_CHANGE */
2871: SELECT count(*)
2872: INTO l_count
2873: FROM oe_order_lines oe1
2874: WHERE top_model_line_id = p_top_model_line_id
2875: AND shippable_flag = 'Y'
2876: AND NVL(OE1.CANCELLED_FLAG,'N')='N' --9822866
2877: AND ordered_quantity/shipped_quantity = ALL

Line 2879: FROM oe_order_lines_all oe2

2875: AND shippable_flag = 'Y'
2876: AND NVL(OE1.CANCELLED_FLAG,'N')='N' --9822866
2877: AND ordered_quantity/shipped_quantity = ALL
2878: (SELECT ordered_quantity/shipped_quantity
2879: FROM oe_order_lines_all oe2
2880: WHERE oe2.top_model_line_id = oe1.top_model_line_id
2881: AND oe2.line_id <> oe1.line_id
2882: AND oe2.shippable_flag = 'Y'
2883: AND NVL(OE2.CANCELLED_FLAG,'N')='N' --9822866

Line 2899: FROM oe_order_lines_all

2895: /* -- commented for bug 8774783
2896:
2897: SELECT shipped_quantity/ordered_quantity
2898: INTO l_shipped_ratio
2899: FROM oe_order_lines_all
2900: WHERE top_model_line_id = p_top_model_line_id
2901: AND shippable_flag = 'Y'
2902: AND ROWNUM =1;
2903:

Line 2906: FROM oe_order_lines_all

2902: AND ROWNUM =1;
2903:
2904: SELECT ordered_quantity
2905: into l_model_ordered_qty
2906: FROM oe_order_lines_all
2907: WHERE line_id = p_top_model_line_id;
2908:
2909: l_new_model_shipped_qty :=(l_model_ordered_qty *l_shipped_ratio);
2910: */ --end comment for bug 8774783

Line 2913: FROM oe_order_lines_all

2909: l_new_model_shipped_qty :=(l_model_ordered_qty *l_shipped_ratio);
2910: */ --end comment for bug 8774783
2911: SELECT shipped_quantity,ordered_quantity
2912: INTO l_line_model_shipped_qty,l_line_model_ordered_qty
2913: FROM oe_order_lines_all
2914: WHERE top_model_line_id = p_top_model_line_id
2915: AND shippable_flag = 'Y'
2916: AND ROWNUM =1;
2917:

Line 2920: FROM oe_order_lines_all

2916: AND ROWNUM =1;
2917:
2918: SELECT ordered_quantity
2919: into l_model_ordered_qty
2920: FROM oe_order_lines_all
2921: WHERE line_id = p_top_model_line_id;
2922:
2923: l_new_model_shipped_qty :=(l_model_ordered_qty *l_line_model_shipped_qty/l_line_model_ordered_qty);
2924:

Line 2958: UPDATE oe_order_lines

2954: --------------- handle proportional shipment --------------------
2955:
2956: IF l_proportional_ship = 'Y' THEN
2957:
2958: UPDATE oe_order_lines
2959: SET shipped_quantity = (ordered_quantity *
2960: p_ship_line_rec.shipped_quantity(p_index)/
2961: p_ship_line_rec.ordered_quantity(p_index))
2962: ,actual_shipment_date =

Line 3003: FROM oe_order_lines

2999: p_ship_line_rec.ato_line_id(l_index),
3000: p_ship_line_rec.top_model_line_id(l_index),
3001: p_ship_line_rec.item_type_code(l_index),
3002: p_ship_line_rec.ship_from_org_id(l_index) -- Bug 10338240
3003: FROM oe_order_lines
3004: WHERE line_id = p_top_model_line_id;
3005:
3006:
3007: IF l_debug_level > 0 THEN

Line 3188: FROM oe_order_lines

3184: p_ship_line_rec.ordered_quantity(l_index),
3185: p_ship_line_rec.header_id(l_index),
3186: p_ship_line_rec.ato_line_id(l_index),
3187: p_ship_line_rec.item_type_code(l_index)
3188: FROM oe_order_lines
3189: WHERE line_id = l_split_line_tbl(I).line_id;
3190:
3191: p_ship_line_rec.top_model_line_id(l_index) := p_top_model_line_id;
3192: -- the top model line id is actually diff, this is to make

Line 3342: FROM oe_order_lines oe

3338: CURSOR split_lines IS
3339: SELECT line_id, line_set_id, ordered_quantity, ordered_quantity2,
3340: order_quantity_uom, ordered_quantity_uom2, inventory_item_id,
3341: header_id
3342: FROM oe_order_lines oe
3343: WHERE line_id in
3344: (SELECT line_id
3345: FROM oe_order_lines_all
3346: WHERE line_set_id = p_ship_line_rec.line_set_id(p_index)

Line 3345: FROM oe_order_lines_all

3341: header_id
3342: FROM oe_order_lines oe
3343: WHERE line_id in
3344: (SELECT line_id
3345: FROM oe_order_lines_all
3346: WHERE line_set_id = p_ship_line_rec.line_set_id(p_index)
3347: AND line_id <> p_ship_line_rec.line_id(p_index))
3348: AND open_flag = 'Y'
3349: AND shipped_quantity is NULL

Line 3442: UPDATE OE_ORDER_LINES

3438: IF l_debug_level > 0 THEN
3439: oe_debug_pub.add('Before quantities db update', 3);
3440: END IF;
3441:
3442: UPDATE OE_ORDER_LINES
3443: SET shipping_quantity = l_line_set_rec.shipping_quantity(I),
3444: shipped_quantity = l_line_set_rec.shipped_quantity(I),
3445: shipping_quantity2 = l_line_set_rec.shipping_quantity2(I),
3446: shipped_quantity2 = l_line_set_rec.shipped_quantity2(I),

Line 3582: FROM oe_order_lines

3578: nvl(model_remnant_flag, 'N') model_remnant_flag,
3579: fulfilled_quantity,
3580: open_flag,
3581: invoiced_quantity
3582: FROM oe_order_lines
3583: WHERE ship_set_id = p_ship_set_id
3584: AND shipped_quantity is NULL;
3585:
3586: I NUMBER;

Line 3623: UPDATE oe_order_lines

3619: oe_debug_pub.add('DIRECT UPDATE LINE ID: '||line_rec.line_id,3);
3620: END IF;
3621:
3622: -- do direct update
3623: UPDATE oe_order_lines
3624: SET ship_set_id = NULL
3625: WHERE line_id=line_rec.line_id;
3626:
3627: ELSE

Line 3631: FROM oe_order_lines

3627: ELSE
3628: -- lock the lines belonging to the particular set
3629: SELECT line_id
3630: INTO l_line_id
3631: FROM oe_order_lines
3632: WHERE line_id = line_rec.line_id
3633: FOR UPDATE NOWAIT;
3634:
3635: J := J + 1;

Line 3799: FROM oe_order_lines_all

3795: ship_tolerance_above
3796: INTO p_ship_line_rec.ordered_quantity(I),
3797: p_ship_line_rec.ship_tolerance_below(I),
3798: p_ship_line_rec.ship_tolerance_above(I)
3799: FROM oe_order_lines_all
3800: WHERE line_id = p_ship_line_rec.line_id(I);
3801: END LOOP;
3802: END IF;
3803:

Line 3858: FROM OE_ORDER_LINES

3854: END IF;
3855: --
3856: SELECT top_model_line_id, shippable_flag
3857: INTO p_ship_line_rec.top_model_line_id(I), p_ship_line_rec.shippable_flag(I)
3858: FROM OE_ORDER_LINES
3859: WHERE line_id = p_ship_line_rec.line_id(I)
3860: FOR UPDATE NOWAIT;
3861: --
3862:

Line 3875: FROM oe_order_lines

3871: p_ship_line_rec.top_model_line_id(I) <> l_rem_top_model_line_id THEN
3872:
3873: SELECT top_model_line_id
3874: INTO l_rem_top_model_line_id
3875: FROM oe_order_lines
3876: WHERE line_id = p_ship_line_rec.top_model_line_id(I)
3877: FOR UPDATE NOWAIT;
3878: --Bug #5058663 End of changes.
3879: IF l_debug_level > 0 THEN

Line 4016: UPDATE OE_ORDER_LINES

4012: Call_Notification_Framework
4013: ( p_ship_line_rec => p_ship_line_rec
4014: ,p_caller => 'HANDLE_NON_BULK');
4015:
4016: UPDATE OE_ORDER_LINES
4017: SET shipping_quantity = p_ship_line_rec.shipping_quantity(I),
4018: shipping_quantity2 = p_ship_line_rec.shipping_quantity2(I),
4019: shipped_quantity2 = p_ship_line_rec.shipping_quantity2(I),
4020: shipped_quantity = p_ship_line_rec.shipped_quantity(I),

Line 4168: FROM oe_order_lines_all

4164:
4165: l_cnt_config := 0 ;
4166: SELECT Count(*)
4167: INTO l_cnt_config
4168: FROM oe_order_lines_all
4169: WHERE ato_line_id = p_ship_line_rec.ato_line_id(I)
4170: AND item_type_code = 'CONFIG' ;
4171:
4172: IF l_debug_level > 0 THEN

Line 4548: UPDATE OE_ORDER_LINES_ALL

4544: ,p_caller => 'HANDLE_BULK');
4545:
4546: FORALL I in p_start_index..p_end_index
4547:
4548: UPDATE OE_ORDER_LINES_ALL
4549: SET shipping_quantity = p_ship_line_rec.shipping_quantity(I),
4550: shipping_quantity2 = p_ship_line_rec.shipping_quantity2(I),
4551: shipped_quantity2 = p_ship_line_rec.shipping_quantity2(I),
4552: shipped_quantity = p_ship_line_rec.ordered_quantity(I),

Line 4575: UPDATE OE_ORDER_LINES_ALL oe1

4571: 'SHIPPED');
4572: END LOOP;
4573:
4574: FORALL I in p_start_index..p_end_index
4575: UPDATE OE_ORDER_LINES_ALL oe1
4576: SET model_remnant_flag = 'Y'
4577: WHERE top_model_line_id is not NULL
4578: AND top_model_line_id = p_ship_line_rec.top_model_line_id(I)
4579: AND model_remnant_flag is NULL

Line 4581: FROM oe_order_lines_all oe2

4577: WHERE top_model_line_id is not NULL
4578: AND top_model_line_id = p_ship_line_rec.top_model_line_id(I)
4579: AND model_remnant_flag is NULL
4580: AND (EXISTS (SELECT NULL
4581: FROM oe_order_lines_all oe2
4582: WHERE oe2.top_model_line_id = oe1.top_model_line_id
4583: AND source_type_code = 'EXTERNAL')
4584: OR -- added for bug 4701487
4585: EXISTS (SELECT NULL

Line 4586: FROM oe_order_lines_all oe3

4582: WHERE oe2.top_model_line_id = oe1.top_model_line_id
4583: AND source_type_code = 'EXTERNAL')
4584: OR -- added for bug 4701487
4585: EXISTS (SELECT NULL
4586: FROM oe_order_lines_all oe3
4587: WHERE oe3.top_model_line_id = oe1.top_model_line_id
4588: AND cancelled_flag = 'N'
4589: AND schedule_ship_date is NULL));
4590:

Line 4638: FROM oe_order_lines_all

4634: -- Modified for 7450821 end
4635:
4636: SELECT calculate_price_flag
4637: INTO p_ship_line_rec.calculate_price_flag(i)
4638: FROM oe_order_lines_all
4639: WHERE line_id = p_ship_line_rec.line_id(i);
4640:
4641: IF p_ship_line_rec.calculate_price_flag(i) IN ('Y','P') OR
4642: (p_ship_line_rec.shipping_quantity2(I) IS NOT NULL

Line 4808: UPDATE oe_order_lines_all

4804: IF l_debug_level > 0 THEN
4805: oe_debug_pub.ADD('gg1 '|| p_start_index ||'-' ||p_end_index,1);
4806: END IF;
4807: FORALL i in p_start_index..p_end_index
4808: UPDATE oe_order_lines_all
4809: SET shipped_quantity = ordered_quantity, -- INVCONV
4810: shipped_quantity2 = ordered_quantity2 -- INVCONV
4811: ,actual_shipment_date = p_ship_line_rec.actual_shipment_date(i)
4812: ,lock_control = lock_control + 1

Line 4815: FROM oe_order_lines_all

4811: ,actual_shipment_date = p_ship_line_rec.actual_shipment_date(i)
4812: ,lock_control = lock_control + 1
4813: WHERE line_id in
4814: (SELECT line_id
4815: FROM oe_order_lines_all
4816: WHERE top_model_line_id =
4817: p_ship_line_rec.top_model_line_id(i))
4818: AND shippable_flag = 'N'
4819: AND p_ship_line_rec.error_flag(i) = 'N'

Line 4858: UPDATE oe_order_lines_all

4854: x_top_container_model => l_top_container_model,
4855: x_part_of_container => l_part_of_container);
4856:
4857: IF l_part_of_container = 'Y' THEN
4858: UPDATE oe_order_lines_all
4859: SET shipped_quantity = NULL
4860: ,actual_shipment_date = NULL
4861: ,lock_control = lock_control + 1
4862: WHERE line_id = g_non_shippable_rec.line_id(I);

Line 4901: UPDATE oe_order_lines_all

4897: END IF;
4898:
4899: IF g_non_shippable_rec.model_remnant_flag(I) = 'Y' THEN
4900:
4901: UPDATE oe_order_lines_all
4902: SET shipped_quantity = null
4903: ,lock_control = lock_control + 1
4904: WHERE line_id = g_non_shippable_rec.line_id(I);
4905:

Line 4932: UPDATE OE_ORDER_LINES_ALL oe1

4928:
4929: END IF; -- if non shippable lines
4930: -- 4052633
4931: FORALL I in p_start_index..p_end_index
4932: UPDATE OE_ORDER_LINES_ALL oe1
4933: SET ship_set_id = NULL
4934: WHERE ship_set_id is not NULL
4935: AND shipped_quantity is NULL
4936: AND ship_set_id = p_ship_line_rec.ship_set_id(I);

Line 4969: UPDATE OE_ORDER_LINES_ALL

4965: -- bug3309470 ends }
4966:
4967: IF x_return_status = 'W' THEN
4968: FORALL i in p_start_index..p_end_index
4969: UPDATE OE_ORDER_LINES_ALL
4970: SET shipping_quantity = null,
4971: shipping_quantity2 = null,
4972: shipped_quantity2 = null,
4973: shipped_quantity = null,