APPS.QP_CALCULATE_PRICE_PUB dependencies on QP_NPREQ_LINE_ATTRS_TMP

Line 1474: FROM qp_npreq_line_attrs_tmp

1470: -- gets request line attributes to pass to the custom API call
1471: -- (only the attributes that qualified for the price break in question)
1472: CURSOR l_req_line_attrs_cur(p_list_line_id NUMBER) IS
1473: SELECT line_index, attribute_type, context, attribute, value_from, grouping_number
1474: FROM qp_npreq_line_attrs_tmp
1475: WHERE list_line_id = p_list_line_id
1476: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
1477:
1478: BEGIN

Line 1573: FROM qp_npreq_line_attrs_tmp

1569: -- try to get accum value from request line
1570: BEGIN
1571: SELECT DISTINCT value_from
1572: INTO l_accum
1573: FROM qp_npreq_line_attrs_tmp
1574: WHERE line_index = l_line_index -- (l_line_index is a global package variable)
1575: AND context = l_accum_context
1576: AND attribute = l_accum_attrib
1577: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;

Line 2609: qp_npreq_line_attrs_tmp a, QP_PRICING_ATTRIBUTES b, QP_LIST_LINES c, QP_LIST_HEADERS_B d, QP_QUALIFIERS e

2605:
2606: CURSOR get_list_details_cur(p_source_system_code VARCHAR2) IS
2607: SELECT /*+ ORDERED USE_NL(a b c d e) */ c.LIST_LINE_ID, c.OPERAND
2608: FROM
2609: qp_npreq_line_attrs_tmp a, QP_PRICING_ATTRIBUTES b, QP_LIST_LINES c, QP_LIST_HEADERS_B d, QP_QUALIFIERS e
2610: WHERE a.LINE_INDEX = p_line_index
2611: AND a.CONTEXT = b.PRODUCT_ATTRIBUTE_CONTEXT
2612: AND a.ATTRIBUTE = b.PRODUCT_ATTRIBUTE
2613: AND a.VALUE_FROM = b.PRODUCT_ATTR_VALUE