APPS.QP_PRICE_BOOK_PVT dependencies on QP_PREQ_LINE_ATTRS_TMP

Line 1379: FROM qp_preq_line_attrs_tmp a, qp_list_headers_vl b

1375: a.comparison_operator_type_code, a.setup_value_from,
1376: a.setup_value_to, a.datatype,
1377: decode(a.attribute_type, QP_PREQ_GRP.G_PRICING_TYPE,
1378: 'PRICING_ATTRIBUTE', a.attribute_type) attribute_type
1379: FROM qp_preq_line_attrs_tmp a, qp_list_headers_vl b
1380: WHERE a.line_index = l_line_index2_tbl(k)
1381: AND a.line_detail_index = l_line_detail_index2_tbl(k)
1382: AND a.list_header_id = b.list_header_id
1383: AND b.list_type_code = 'PRL'

Line 1408: SELECT /*+ ORDERED index(a QP_PREQ_LINE_ATTRS_TMP_N3) */ qp_price_book_break_lines_s.nextval, l_pb_line_det_id_tbl(k),

1404: pricing_attribute_datatype, operand, application_method,
1405: recurring_value,
1406: creation_date, created_by, last_update_date, last_updated_by,
1407: last_update_login)
1408: SELECT /*+ ORDERED index(a QP_PREQ_LINE_ATTRS_TMP_N3) */ qp_price_book_break_lines_s.nextval, l_pb_line_det_id_tbl(k),
1409: l_pb_line_id_tbl(k), p_price_book_header_id,
1410: a.context, a.attribute, a.value_from,
1411: a.value_to, a.comparison_operator_type_code,
1412: a.datatype, b.operand_value, b.operand_calculation_code,

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

1411: a.value_to, a.comparison_operator_type_code,
1412: a.datatype, b.operand_value, b.operand_calculation_code,
1413: b.recurring_value,
1414: sysdate, l_user_id, sysdate, l_user_id, l_login_id
1415: FROM qp_preq_rltd_lines_tmp r, qp_preq_ldets_tmp b, qp_preq_line_attrs_tmp a
1416: WHERE l_list_line_type_code2_tbl(k) = 'PBH'
1417: AND r.line_index = l_line_index2_tbl(k)
1418: AND r.line_detail_index = l_line_detail_index2_tbl(k)
1419: AND r.relationship_type_code = QP_PREQ_GRP.G_PBH_LINE -- just in case db goes to table before first condition