APPS.OE_PRICE_ORDER_PVT_OBSOLETE dependencies on QP_PREQ_LINES_TMP

Line 726: from qp_preq_lines_tmp

722: , adjusted_unit_price
723: , priced_quantity
724: , line_quantity
725: , priced_uom_code
726: from qp_preq_lines_tmp
727: where process_status <> 'NOT_VALID' and
728: (pricing_status_code not in
729: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
730: QP_PREQ_GRP.G_STATUS_UPDATED,

Line 744: , qp_preq_lines_tmp lines

740: , lines.line_quantity
741: , l.shipped_quantity
742: , l.header_id
743: from oe_order_lines l
744: , qp_preq_lines_tmp lines
745: where lines.line_id = l.line_id
746: and lines.line_type_code='LINE'
747: and l.booked_flag = 'Y'
748: and l.item_type_code NOT IN ('INCLUDED','CONFIG')

Line 1271: , QP_PREQ_LINES_TMP lines

1267: , ldets.OPERAND_value operand_per_pqty
1268: , ldets.adjustment_amount adjusted_amount_per_pqty
1269: FROM
1270: QP_LDETS_v ldets
1271: , QP_PREQ_LINES_TMP lines
1272: , QP_LIST_HEADERS_B QH
1273: WHERE
1274: ldets.list_header_id=qh.list_header_id
1275: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)

Line 1536: select /*+ INDEX(lines qp_preq_lines_tmp_n1) */

1532: END IF;
1533:
1534: BEGIN
1535:
1536: select /*+ INDEX(lines qp_preq_lines_tmp_n1) */
1537: nvl(lines.order_uom_selling_price, lines.ADJUSTED_UNIT_PRICE * lines.priced_quantity /l_line_rec.ordered_quantity)
1538: , nvl(lines.line_unit_price, lines.UNIT_PRICE * lines.priced_quantity/l_line_rec.ordered_quantity)
1539: , lines.ADJUSTED_UNIT_PRICE
1540: , lines.UNIT_PRICE

Line 1561: from qp_preq_lines_tmp lines

1557: , l_line_rec.PRICE_LIST_ID
1558: , l_line_rec.UNIT_LIST_PERCENT
1559: , l_line_rec.UNIT_PERCENT_BASE_PRICE
1560: , l_line_rec.UNIT_SELLING_PERCENT
1561: from qp_preq_lines_tmp lines
1562: where lines.line_id=l_line_rec.line_id
1563: and lines.line_type_code='LINE'
1564: and l_line_rec.ordered_quantity <> 0
1565: and lines.process_status <> 'NOT_VALID'