APPS.QP_SOURCING_API_PUB dependencies on OE_ORDER_LINES

Line 442: FROM oe_order_lines

438: Begin
439: SELECT SUM(nvl(ordered_quantity,0)*(unit_list_price)),
440: SUM(nvl(ordered_quantity,0))
441: INTO orders_total_amt, orders_total_qty
442: FROM oe_order_lines
443: WHERE header_id=p_header_id
444: AND (cancelled_flag='N' OR cancelled_flag IS NULL)
445: AND (line_category_code<>'RETURN' OR line_category_code IS NULL)
446: GROUP BY header_id;

Line 460: FROM oe_order_lines

456: Begin
457: SELECT SUM(nvl(ordered_quantity,0)*(unit_list_price)),
458: SUM(nvl(ordered_quantity,0))
459: INTO returns_total_amt, returns_total_qty
460: FROM oe_order_lines
461: WHERE header_id=p_header_id
462: AND (cancelled_flag='N' OR cancelled_flag IS NULL)
463: AND line_category_code='RETURN'
464: GROUP BY header_id;

Line 487: FROM oe_order_lines

483: INTO returns_total_amt,
484: orders_total_amt,
485: returns_total_qty,
486: orders_total_qty
487: FROM oe_order_lines
488: WHERE header_id=p_header_id
489: AND (cancelled_flag='N' OR cancelled_flag IS NULL)
490: AND charge_periodicity_code is null; -- added for recurring charges Bug 4465168
491:

Line 594: FROM oe_order_lines_all

590: Else --non hvop
591:
592: SELECT inventory_item_id
593: INTO G_MODEL_ID
594: FROM oe_order_lines_all
595: WHERE line_id = p_top_model_line_id;
596:
597: End If; --hvop
598:

Line 1435: FROM oe_order_lines_all

1431: l_inventory_item_id NUMBER;
1432: --
1433: CURSOR l_lines_cursor(header_id_in number) is
1434: SELECT ordered_quantity,order_quantity_uom,inventory_item_id
1435: FROM oe_order_lines_all
1436: WHERE header_id = header_id_in;
1437:
1438: BEGIN
1439:

Line 1547: FROM oe_order_lines_all

1543: End Loop;
1544: Else --Non HVOP
1545: SELECT count(*)
1546: INTO x_count
1547: FROM oe_order_lines_all
1548: WHERE shippable_flag = 'Y'
1549: AND header_id = p_header_id
1550: AND rownum < 2;
1551: