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 200: FROM OE_ORDER_LINES

196: l_item_type_code,
197: l_line_set_id,
198: l_ship_from_org_id,
199: l_ordered_quantity2
200: FROM OE_ORDER_LINES
201: WHERE line_id = p_req_qty_tbl(J).line_id;
202:
203: IF l_debug_level > 0 THEN
204: oe_debug_pub.add( 'REQUESTED/ORDER QUANTITY : '||P_REQ_QTY_TBL ( J ) .REQUESTED_QUANTITY||'/'||L_ORDERED_QUANTITY , 3 ) ;

Line 473: FROM oe_order_lines

469: LOOP
470:
471: SELECT top_model_line_id
472: INTO l_top_model_line_id
473: FROM oe_order_lines
474: WHERE line_id = p_line_tbl(J).line_id;
475:
476:
477: --bug3549422

Line 490: FROM oe_order_lines

486: END IF;
487:
488: SELECT top_model_line_id
489: INTO l_top_model_line_id
490: FROM oe_order_lines
491: WHERE line_id = l_top_model_line_id
492: FOR UPDATE NOWAIT;
493:
494: IF l_debug_level > 0 THEN

Line 534: FROM OE_ORDER_LINES

530: l_item_type_code,
531: l_header_id,
532: l_calculate_price_flag,
533: l_smc_flag
534: FROM OE_ORDER_LINES
535: WHERE line_id = p_line_tbl(J).line_id
536: FOR UPDATE NOWAIT;
537:
538: EXCEPTION

Line 782: FROM oe_order_lines

778: THEN
779:
780: SELECT ato_line_id
781: INTO l_count
782: FROM oe_order_lines
783: WHERE line_id = l_top_model_line_id;
784:
785: IF l_count is NULL THEN
786:

Line 796: FROM OE_ORDER_LINES

792:
793: --bug3480047 contd
794: SELECT COUNT(*)
795: INTO l_shippable_lines
796: FROM OE_ORDER_LINES
797: WHERE top_model_line_id = l_top_model_line_id
798: AND NVL(CANCELLED_FLAG,'N')='N'
799: AND NVL(SHIPPABLE_FLAG,'N')='Y';
800:

Line 805: FROM oe_order_lines

801: IF l_shippable_lines > 1 THEN
802:
803: SELECT count(*)
804: INTO l_count
805: FROM oe_order_lines
806: WHERE top_model_line_id = l_top_model_line_id
807: AND cancelled_flag = 'N'
808: AND source_type_code = 'EXTERNAL';
809:

Line 826: FROM oe_order_lines oe1

822:
823: /* MOAC_SQL_CHANGE */
824: SELECT count(*)
825: INTO l_count
826: FROM oe_order_lines oe1
827: WHERE top_model_line_id = l_top_model_line_id
828: AND ato_line_id = line_id
829: AND item_type_code = 'CLASS'
830: AND cancelled_flag = 'N'

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 854: FROM oe_order_lines

850: SELECT 1 INTO l_count
851: FROM DUAL
852: WHERE EXISTS (
853: SELECT NULL
854: FROM oe_order_lines
855: WHERE top_model_line_id = l_top_model_line_id
856: AND cancelled_flag = 'N'
857: AND schedule_ship_date is NULL);
858: EXCEPTION

Line 875: UPDATE oe_order_lines

871: IF l_make_remnant = 'Y' THEN -- bug 4701487
872: IF l_debug_level > 0 THEN
873: oe_debug_pub.add( 'Making the model REMNANT:'|| L_TOP_MODEL_LINE_ID , 3 ) ;
874: END IF;
875: UPDATE oe_order_lines
876: SET model_remnant_flag = 'Y'
877: WHERE top_model_line_id = l_top_model_line_id;
878:
879: l_model_remnant_flag := 'Y';

Line 1025: UPDATE OE_ORDER_LINES

1021: l_line_tbl(J).ship_tolerance_below := l_ship_tolerance_below_upd;
1022: l_notify := TRUE;
1023: END IF; /* need to update global picture */
1024:
1025: UPDATE OE_ORDER_LINES
1026: SET shipping_quantity = p_line_tbl(J).shipping_quantity,
1027: shipping_quantity2 = p_line_tbl(J).shipping_quantity2,
1028: shipped_quantity2 = p_line_tbl(J).shipping_quantity2,
1029: shipping_quantity_uom = p_line_tbl(J).shipping_quantity_uom,

Line 1078: UPDATE OE_ORDER_LINES

1074:
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add( 'CALCULATE PRICE FLAG : '||L_CALCULATE_PRICE_FLAG , 3 ) ;
1077: END IF;
1078: UPDATE OE_ORDER_LINES
1079: SET shipping_quantity = p_line_tbl(J).shipping_quantity,
1080: shipping_quantity2 = p_line_tbl(J).shipping_quantity2,
1081: shipped_quantity2 = p_line_tbl(J).shipping_quantity2,
1082: shipping_quantity_uom = p_line_tbl(J).shipping_quantity_uom,

Line 2129: FROM oe_order_lines

2125: CURSOR fulfill_remnant_lines IS
2126: SELECT line_id, ordered_quantity
2127: ,header_id, actual_shipment_date, order_firmed_date
2128: ,blanket_number,blanket_line_number,blanket_version_number
2129: FROM oe_order_lines
2130: WHERE top_model_line_id = p_top_model_line_id
2131: AND nvl(ato_line_id,-99) = -99 /*added for bug 6640292*/
2132: AND shippable_flag = 'N'
2133: AND model_remnant_flag = 'Y';

Line 2341: UPDATE oe_order_lines

2337: END IF;
2338:
2339: IF p_ato_only = 'Y' THEN
2340:
2341: UPDATE oe_order_lines
2342: SET shipped_quantity = (ordered_quantity *
2343: p_ship_line_rec.shipped_quantity(p_index)/
2344: p_ship_line_rec.ordered_quantity(p_index))
2345: ,actual_shipment_date

Line 2587: FROM oe_order_lines

2583: l_new_model_shipped_qty NUMBER;
2584:
2585: CURSOR shipped_lines IS
2586: SELECT line_id, ordered_quantity, shipped_quantity
2587: FROM oe_order_lines
2588: WHERE shippable_flag = 'Y'
2589: AND shipped_quantity is NOT NULL
2590: AND top_model_line_id = p_top_model_line_id;
2591: BEGIN

Line 2595: FROM oe_order_lines

2591: BEGIN
2592:
2593: SELECT count(*)
2594: INTO l_count1
2595: FROM oe_order_lines
2596: WHERE top_model_line_id = p_top_model_line_id
2597: AND cancelled_flag = 'N'
2598: AND shippable_flag = 'Y';
2599:

Line 2611: FROM oe_order_lines

2607: -- if ato+pto with external lines, make it remnant.
2608: IF l_count1 > 1 THEN
2609: SELECT count(*)
2610: INTO l_count
2611: FROM oe_order_lines
2612: WHERE top_model_line_id = p_top_model_line_id
2613: AND cancelled_flag = 'N'
2614: AND source_type_code = 'EXTERNAL';
2615:

Line 2633: FROM oe_order_lines oe1

2629:
2630: /* MOAC_SQL_CHANGE */
2631: SELECT count(*)
2632: INTO l_count
2633: FROM oe_order_lines oe1
2634: WHERE top_model_line_id = p_top_model_line_id
2635: AND ato_line_id = line_id
2636: AND item_type_code = 'CLASS'
2637: AND cancelled_flag = 'N'

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 2661: FROM oe_order_lines

2657: SELECT 1 INTO l_count
2658: FROM DUAL
2659: WHERE EXISTS (
2660: SELECT NULL
2661: FROM oe_order_lines
2662: WHERE top_model_line_id = p_top_model_line_id
2663: AND cancelled_flag = 'N'
2664: AND schedule_ship_date is NULL);
2665: EXCEPTION

Line 2683: UPDATE oe_order_lines

2679: IF l_debug_level > 0 THEN
2680: oe_debug_pub.add( 'Making the model REMNANT:'|| p_TOP_MODEL_LINE_ID , 2) ;
2681: END IF;
2682:
2683: UPDATE oe_order_lines
2684: SET model_remnant_flag = 'Y'
2685: ,lock_control = lock_control + 1
2686: WHERE top_model_line_id = p_top_model_line_id
2687: AND cancelled_flag = 'N';

Line 2705: FROM oe_order_lines

2701: IF l_model_remnant_flag = 'N' THEN
2702:
2703: SELECT count(*)
2704: INTO l_count
2705: FROM oe_order_lines
2706: WHERE top_model_line_id = p_top_model_line_id
2707: AND shippable_flag = 'Y'
2708: AND shipped_quantity is NULL;
2709:

Line 2721: FROM oe_order_lines oe1

2717:
2718: /* MOAC_SQL_CHANGE */
2719: SELECT count(*)
2720: INTO l_count
2721: FROM oe_order_lines oe1
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

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 2782: UPDATE oe_order_lines

2778: --------------- handle proportional shipment --------------------
2779:
2780: IF l_proportional_ship = 'Y' THEN
2781:
2782: UPDATE oe_order_lines
2783: SET shipped_quantity = (ordered_quantity *
2784: p_ship_line_rec.shipped_quantity(p_index)/
2785: p_ship_line_rec.ordered_quantity(p_index))
2786: ,actual_shipment_date =

Line 2825: FROM oe_order_lines

2821: p_ship_line_rec.order_quantity_uom2(l_index), -- INVCONV 4199186
2822: p_ship_line_rec.ato_line_id(l_index),
2823: p_ship_line_rec.top_model_line_id(l_index),
2824: p_ship_line_rec.item_type_code(l_index)
2825: FROM oe_order_lines
2826: WHERE line_id = p_top_model_line_id;
2827:
2828:
2829: IF l_debug_level > 0 THEN

Line 3010: FROM oe_order_lines

3006: p_ship_line_rec.ordered_quantity(l_index),
3007: p_ship_line_rec.header_id(l_index),
3008: p_ship_line_rec.ato_line_id(l_index),
3009: p_ship_line_rec.item_type_code(l_index)
3010: FROM oe_order_lines
3011: WHERE line_id = l_split_line_tbl(I).line_id;
3012:
3013: p_ship_line_rec.top_model_line_id(l_index) := p_top_model_line_id;
3014: -- the top model line id is actually diff, this is to make

Line 3164: FROM oe_order_lines oe

3160: CURSOR split_lines IS
3161: SELECT line_id, line_set_id, ordered_quantity, ordered_quantity2,
3162: order_quantity_uom, ordered_quantity_uom2, inventory_item_id,
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)

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 3265: UPDATE OE_ORDER_LINES

3261: IF l_debug_level > 0 THEN
3262: oe_debug_pub.add('Before quantities db update', 3);
3263: END IF;
3264:
3265: UPDATE OE_ORDER_LINES
3266: SET shipping_quantity = l_line_set_rec.shipping_quantity(I),
3267: shipped_quantity = l_line_set_rec.shipped_quantity(I),
3268: shipping_quantity2 = l_line_set_rec.shipping_quantity2(I),
3269: shipped_quantity2 = l_line_set_rec.shipped_quantity2(I),

Line 3401: FROM oe_order_lines

3397: nvl(model_remnant_flag, 'N') model_remnant_flag,
3398: fulfilled_quantity,
3399: open_flag,
3400: invoiced_quantity
3401: FROM oe_order_lines
3402: WHERE ship_set_id = p_ship_set_id
3403: AND shipped_quantity is NULL;
3404:
3405: I NUMBER;

Line 3441: UPDATE oe_order_lines

3437: oe_debug_pub.add('DIRECT UPDATE LINE ID: '||line_rec.line_id,3);
3438: END IF;
3439:
3440: -- do direct update
3441: UPDATE oe_order_lines
3442: SET ship_set_id = NULL
3443: WHERE line_id=line_rec.line_id;
3444:
3445: ELSE

Line 3449: FROM oe_order_lines

3445: ELSE
3446: -- lock the lines belonging to the particular set
3447: SELECT line_id
3448: INTO l_line_id
3449: FROM oe_order_lines
3450: WHERE line_id = line_rec.line_id
3451: FOR UPDATE NOWAIT;
3452:
3453: J := J + 1;

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 3660: FROM OE_ORDER_LINES

3656: END IF;
3657: --
3658: SELECT top_model_line_id, shippable_flag
3659: INTO p_ship_line_rec.top_model_line_id(I), p_ship_line_rec.shippable_flag(I)
3660: FROM OE_ORDER_LINES
3661: WHERE line_id = p_ship_line_rec.line_id(I)
3662: FOR UPDATE NOWAIT;
3663: --
3664:

Line 3677: FROM oe_order_lines

3673: p_ship_line_rec.top_model_line_id(I) <> l_rem_top_model_line_id THEN
3674:
3675: SELECT top_model_line_id
3676: INTO l_rem_top_model_line_id
3677: FROM oe_order_lines
3678: WHERE line_id = p_ship_line_rec.top_model_line_id(I)
3679: FOR UPDATE NOWAIT;
3680: --Bug #5058663 End of changes.
3681: IF l_debug_level > 0 THEN

Line 3818: UPDATE OE_ORDER_LINES

3814: Call_Notification_Framework
3815: ( p_ship_line_rec => p_ship_line_rec
3816: ,p_caller => 'HANDLE_NON_BULK');
3817:
3818: UPDATE OE_ORDER_LINES
3819: SET shipping_quantity = p_ship_line_rec.shipping_quantity(I),
3820: shipping_quantity2 = p_ship_line_rec.shipping_quantity2(I),
3821: shipped_quantity2 = p_ship_line_rec.shipping_quantity2(I),
3822: shipped_quantity = p_ship_line_rec.shipped_quantity(I),

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,