APPS.OE_PRICE_ORDER_PVT dependencies on QP_PREQ_LINES_TMP

Line 930: from qp_preq_lines_tmp

926: , adjusted_unit_price
927: , priced_quantity
928: , line_quantity
929: , priced_uom_code
930: from qp_preq_lines_tmp
931: where process_status <> 'NOT_VALID' and
932: (pricing_status_code not in
933: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
934: QP_PREQ_GRP.G_STATUS_UPDATED,

Line 948: , qp_preq_lines_tmp lines

944: , lines.line_quantity
945: , l.shipped_quantity
946: , l.header_id
947: from oe_order_lines l
948: , qp_preq_lines_tmp lines
949: where lines.line_id = l.line_id
950: and lines.line_type_code='LINE'
951: and l.booked_flag = 'Y'
952: and l.item_type_code NOT IN ('INCLUDED','CONFIG')

Line 1480: , QP_PREQ_LINES_TMP lines

1476: , ldets.adjustment_amount adjusted_amount_per_pqty
1477: , nvl(ldets.line_detail_type_code, 'DIS') line_detail_type_code
1478: FROM
1479: QP_LDETS_v ldets
1480: , QP_PREQ_LINES_TMP lines
1481: , QP_LIST_HEADERS_B QH
1482: WHERE
1483: ldets.list_header_id=qh.list_header_id
1484: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)

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

1758: END IF;
1759:
1760: BEGIN
1761:
1762: select /*+ INDEX(lines qp_preq_lines_tmp_n1) */
1763: nvl(lines.order_uom_selling_price, lines.ADJUSTED_UNIT_PRICE * lines.priced_quantity /l_line_rec.ordered_quantity)
1764: , nvl(lines.line_unit_price, lines.UNIT_PRICE * lines.priced_quantity/l_line_rec.ordered_quantity)
1765: , lines.ADJUSTED_UNIT_PRICE
1766: , lines.UNIT_PRICE

Line 1787: from qp_preq_lines_tmp lines

1783: , l_line_rec.PRICE_LIST_ID
1784: , l_line_rec.UNIT_LIST_PERCENT
1785: , l_line_rec.UNIT_PERCENT_BASE_PRICE
1786: , l_line_rec.UNIT_SELLING_PERCENT
1787: from qp_preq_lines_tmp lines
1788: where lines.line_id=l_line_rec.line_id
1789: and lines.line_type_code='LINE'
1790: and l_line_rec.ordered_quantity <> 0
1791: and lines.process_status <> 'NOT_VALID'