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_ALL

Line 833: FROM oe_order_lines_all

829: AND item_type_code = 'CLASS'
830: AND cancelled_flag = 'N'
831: AND not exists
832: (SELECT NULL
833: FROM oe_order_lines_all
834: WHERE top_model_line_id = l_top_model_line_id
835: AND ato_line_id = oe1.line_id
836: AND cancelled_flag = 'N'
837: AND item_type_code = 'CONFIG');

Line 2640: FROM oe_order_lines_all

2636: AND item_type_code = 'CLASS'
2637: AND cancelled_flag = 'N'
2638: AND not exists
2639: (SELECT NULL
2640: FROM oe_order_lines_all
2641: WHERE top_model_line_id = p_top_model_line_id
2642: AND ato_line_id = oe1.line_id
2643: AND cancelled_flag = 'N'
2644: AND item_type_code = 'CONFIG');

Line 2726: FROM oe_order_lines_all oe2

2722: WHERE top_model_line_id = p_top_model_line_id
2723: AND shippable_flag = 'Y'
2724: AND ordered_quantity/shipped_quantity = ALL
2725: (SELECT ordered_quantity/shipped_quantity
2726: FROM oe_order_lines_all oe2
2727: WHERE oe2.top_model_line_id = oe1.top_model_line_id
2728: AND oe2.line_id <> oe1.line_id
2729: AND oe2.shippable_flag = 'Y');
2730:

Line 2740: FROM oe_order_lines_all

2736: /* bug fix 4466040 */
2737: -- getting shipped ratio for shippable lines
2738: SELECT shipped_quantity/ordered_quantity
2739: INTO l_shipped_ratio
2740: FROM oe_order_lines_all
2741: WHERE top_model_line_id = p_top_model_line_id
2742: AND shippable_flag = 'Y'
2743: AND ROWNUM =1;
2744:

Line 2747: FROM oe_order_lines_all

2743: AND ROWNUM =1;
2744:
2745: SELECT ordered_quantity
2746: into l_model_ordered_qty
2747: FROM oe_order_lines_all
2748: WHERE line_id = p_top_model_line_id;
2749:
2750: l_new_model_shipped_qty :=(l_model_ordered_qty *l_shipped_ratio);
2751: IF ((l_new_model_shipped_qty -TRUNC(l_new_model_shipped_qty,0))=0) THEN

Line 3167: FROM oe_order_lines_all

3163: header_id
3164: FROM oe_order_lines oe
3165: WHERE line_id in
3166: (SELECT line_id
3167: FROM oe_order_lines_all
3168: WHERE line_set_id = p_ship_line_rec.line_set_id(p_index)
3169: AND line_id <> p_ship_line_rec.line_id(p_index))
3170: AND open_flag = 'Y'
3171: AND shipped_quantity is NULL

Line 3605: FROM oe_order_lines_all

3601: ship_tolerance_above
3602: INTO p_ship_line_rec.ordered_quantity(I),
3603: p_ship_line_rec.ship_tolerance_below(I),
3604: p_ship_line_rec.ship_tolerance_above(I)
3605: FROM oe_order_lines_all
3606: WHERE line_id = p_ship_line_rec.line_id(I);
3607: END LOOP;
3608: END IF;
3609:

Line 4257: UPDATE OE_ORDER_LINES_ALL

4253: ,p_caller => 'HANDLE_BULK');
4254:
4255: FORALL I in p_start_index..p_end_index
4256:
4257: UPDATE OE_ORDER_LINES_ALL
4258: SET shipping_quantity = p_ship_line_rec.shipping_quantity(I),
4259: shipping_quantity2 = p_ship_line_rec.shipping_quantity2(I),
4260: shipped_quantity2 = p_ship_line_rec.shipping_quantity2(I),
4261: shipped_quantity = p_ship_line_rec.ordered_quantity(I),

Line 4277: UPDATE OE_ORDER_LINES_ALL oe1

4273: END IF;
4274:
4275:
4276: FORALL I in p_start_index..p_end_index
4277: UPDATE OE_ORDER_LINES_ALL oe1
4278: SET model_remnant_flag = 'Y'
4279: WHERE top_model_line_id is not NULL
4280: AND top_model_line_id = p_ship_line_rec.top_model_line_id(I)
4281: AND model_remnant_flag is NULL

Line 4283: FROM oe_order_lines_all oe2

4279: WHERE top_model_line_id is not NULL
4280: AND top_model_line_id = p_ship_line_rec.top_model_line_id(I)
4281: AND model_remnant_flag is NULL
4282: AND (EXISTS (SELECT NULL
4283: FROM oe_order_lines_all oe2
4284: WHERE oe2.top_model_line_id = oe1.top_model_line_id
4285: AND source_type_code = 'EXTERNAL')
4286: OR -- added for bug 4701487
4287: EXISTS (SELECT NULL

Line 4288: FROM oe_order_lines_all oe3

4284: WHERE oe2.top_model_line_id = oe1.top_model_line_id
4285: AND source_type_code = 'EXTERNAL')
4286: OR -- added for bug 4701487
4287: EXISTS (SELECT NULL
4288: FROM oe_order_lines_all oe3
4289: WHERE oe3.top_model_line_id = oe1.top_model_line_id
4290: AND cancelled_flag = 'N'
4291: AND schedule_ship_date is NULL));
4292:

Line 4340: FROM oe_order_lines_all

4336: -- Modified for 7450821 end
4337:
4338: SELECT calculate_price_flag
4339: INTO p_ship_line_rec.calculate_price_flag(i)
4340: FROM oe_order_lines_all
4341: WHERE line_id = p_ship_line_rec.line_id(i);
4342:
4343: IF p_ship_line_rec.calculate_price_flag(i) IN ('Y','P') OR
4344: (p_ship_line_rec.shipping_quantity2(I) IS NOT NULL

Line 4471: UPDATE oe_order_lines_all

4467: IF l_debug_level > 0 THEN
4468: oe_debug_pub.ADD('gg1 '|| p_start_index ||'-' ||p_end_index,1);
4469: END IF;
4470: FORALL i in p_start_index..p_end_index
4471: UPDATE oe_order_lines_all
4472: SET shipped_quantity = ordered_quantity, -- INVCONV
4473: shipped_quantity2 = ordered_quantity2 -- INVCONV
4474: ,actual_shipment_date = p_ship_line_rec.actual_shipment_date(i)
4475: ,lock_control = lock_control + 1

Line 4478: FROM oe_order_lines_all

4474: ,actual_shipment_date = p_ship_line_rec.actual_shipment_date(i)
4475: ,lock_control = lock_control + 1
4476: WHERE line_id in
4477: (SELECT line_id
4478: FROM oe_order_lines_all
4479: WHERE top_model_line_id =
4480: p_ship_line_rec.top_model_line_id(i))
4481: AND shippable_flag = 'N'
4482: AND p_ship_line_rec.error_flag(i) = 'N'

Line 4521: UPDATE oe_order_lines_all

4517: x_top_container_model => l_top_container_model,
4518: x_part_of_container => l_part_of_container);
4519:
4520: IF l_part_of_container = 'Y' THEN
4521: UPDATE oe_order_lines_all
4522: SET shipped_quantity = NULL
4523: ,actual_shipment_date = NULL
4524: ,lock_control = lock_control + 1
4525: WHERE line_id = g_non_shippable_rec.line_id(I);

Line 4556: UPDATE oe_order_lines_all

4552: END IF;
4553:
4554: IF g_non_shippable_rec.model_remnant_flag(I) = 'Y' THEN
4555:
4556: UPDATE oe_order_lines_all
4557: SET shipped_quantity = null
4558: ,lock_control = lock_control + 1
4559: WHERE line_id = g_non_shippable_rec.line_id(I);
4560:

Line 4587: UPDATE OE_ORDER_LINES_ALL oe1

4583:
4584: END IF; -- if non shippable lines
4585: -- 4052633
4586: FORALL I in p_start_index..p_end_index
4587: UPDATE OE_ORDER_LINES_ALL oe1
4588: SET ship_set_id = NULL
4589: WHERE ship_set_id is not NULL
4590: AND shipped_quantity is NULL
4591: AND ship_set_id = p_ship_line_rec.ship_set_id(I);

Line 4624: UPDATE OE_ORDER_LINES_ALL

4620: -- bug3309470 ends }
4621:
4622: IF x_return_status = 'W' THEN
4623: FORALL i in p_start_index..p_end_index
4624: UPDATE OE_ORDER_LINES_ALL
4625: SET shipping_quantity = null,
4626: shipping_quantity2 = null,
4627: shipped_quantity2 = null,
4628: shipped_quantity = null,