APPS.QP_SOURCING_API_PUB dependencies on OE_ORDER_LINES

Line 450: FROM oe_order_lines

446: Begin
447: SELECT SUM(nvl(ordered_quantity,0)*(unit_list_price)),
448: SUM(nvl(ordered_quantity,0))
449: INTO orders_total_amt, orders_total_qty
450: FROM oe_order_lines
451: WHERE header_id=p_header_id
452: AND (cancelled_flag='N' OR cancelled_flag IS NULL)
453: AND (line_category_code<>'RETURN' OR line_category_code IS NULL)
454: GROUP BY header_id;

Line 468: FROM oe_order_lines

464: Begin
465: SELECT SUM(nvl(ordered_quantity,0)*(unit_list_price)),
466: SUM(nvl(ordered_quantity,0))
467: INTO returns_total_amt, returns_total_qty
468: FROM oe_order_lines
469: WHERE header_id=p_header_id
470: AND (cancelled_flag='N' OR cancelled_flag IS NULL)
471: AND line_category_code='RETURN'
472: GROUP BY header_id;

Line 495: FROM oe_order_lines

491: INTO returns_total_amt,
492: orders_total_amt,
493: returns_total_qty,
494: orders_total_qty
495: FROM oe_order_lines
496: WHERE header_id=p_header_id
497: AND (cancelled_flag='N' OR cancelled_flag IS NULL)
498: AND charge_periodicity_code is null; -- added for recurring charges Bug 4465168
499:

Line 602: FROM oe_order_lines_all

598: Else --non hvop
599:
600: SELECT inventory_item_id
601: INTO G_MODEL_ID
602: FROM oe_order_lines_all
603: WHERE line_id = p_top_model_line_id;
604:
605: End If; --hvop
606:

Line 1443: FROM oe_order_lines_all

1439: l_inventory_item_id NUMBER;
1440: --
1441: CURSOR l_lines_cursor(header_id_in number) is
1442: SELECT ordered_quantity,order_quantity_uom,inventory_item_id
1443: FROM oe_order_lines_all
1444: WHERE header_id = header_id_in;
1445:
1446: BEGIN
1447:

Line 1555: FROM oe_order_lines_all

1551: End Loop;
1552: Else --Non HVOP
1553: SELECT count(*)
1554: INTO x_count
1555: FROM oe_order_lines_all
1556: WHERE shippable_flag = 'Y'
1557: AND header_id = p_header_id
1558: AND rownum < 2;
1559: