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 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 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 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 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 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 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 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,