APPS.QP_PRICE_BOOK_PVT dependencies on QP_PREQ_LINE_ATTRS_TMP

Line 1399: FROM qp_preq_line_attrs_tmp a, qp_list_headers_vl b

1395: a.comparison_operator_type_code, a.setup_value_from,
1396: a.setup_value_to, a.datatype,
1397: decode(a.attribute_type, QP_PREQ_GRP.G_PRICING_TYPE,
1398: 'PRICING_ATTRIBUTE', a.attribute_type) attribute_type
1399: FROM qp_preq_line_attrs_tmp a, qp_list_headers_vl b
1400: WHERE a.line_index = l_line_index2_tbl(k)
1401: AND a.line_detail_index = l_line_detail_index2_tbl(k)
1402: AND a.list_header_id = b.list_header_id
1403: AND b.list_type_code = 'PRL'

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

1424: pricing_attribute_datatype, operand, application_method,
1425: recurring_value,
1426: creation_date, created_by, last_update_date, last_updated_by,
1427: last_update_login)
1428: SELECT /*+ ORDERED index(a QP_PREQ_LINE_ATTRS_TMP_N3) */ qp_price_book_break_lines_s.nextval, l_pb_line_det_id_tbl(k),
1429: l_pb_line_id_tbl(k), p_price_book_header_id,
1430: a.context, a.attribute, a.value_from,
1431: a.value_to, a.comparison_operator_type_code,
1432: a.datatype, b.operand_value, b.operand_calculation_code,

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