APPS.QP_PRICE_BOOK_PVT dependencies on QP_PREQ_LDETS_TMP

Line 483: FROM qp_preq_ldets_tmp a, qp_preq_lines_tmp b

479: a.order_qty_adj_amt adjustment_amount,
480: a.created_from_list_line_type, a.pricing_phase_id,
481: a.price_break_type_code, a.line_index, a.line_detail_index,
482: b.line_id
483: FROM qp_preq_ldets_tmp a, qp_preq_lines_tmp b
484: WHERE a.line_index = b.line_index
485: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
486: AND a.line_detail_type_code = 'NULL' --not a child line
487: AND a.applied_flag = 'Y' --automatic and applied discounts

Line 1435: FROM qp_preq_rltd_lines_tmp r, qp_preq_ldets_tmp b, qp_preq_line_attrs_tmp a

1431: a.value_to, a.comparison_operator_type_code,
1432: a.datatype, b.operand_value, b.operand_calculation_code,
1433: b.recurring_value,
1434: sysdate, l_user_id, sysdate, l_user_id, l_login_id
1435: FROM qp_preq_rltd_lines_tmp r, qp_preq_ldets_tmp b, qp_preq_line_attrs_tmp a
1436: WHERE l_list_line_type_code2_tbl(k) = 'PBH'
1437: AND r.line_index = l_line_index2_tbl(k)
1438: AND r.line_detail_index = l_line_detail_index2_tbl(k)
1439: AND r.relationship_type_code = QP_PREQ_GRP.G_PBH_LINE -- just in case db goes to table before first condition