DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on OE_ORDER_LINES_ALL

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: