DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on OE_ORDER_LINES_ALL

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: