APPS.QP_CALCULATE_PRICE_PUB dependencies on QP_NPREQ_LINE_ATTRS_TMP

Line 1482: FROM qp_npreq_line_attrs_tmp

1478: -- gets request line attributes to pass to the custom API call
1479: -- (only the attributes that qualified for the price break in question)
1480: CURSOR l_req_line_attrs_cur(p_list_line_id NUMBER) IS
1481: SELECT line_index, attribute_type, context, attribute, value_from, grouping_number
1482: FROM qp_npreq_line_attrs_tmp
1483: WHERE list_line_id = p_list_line_id
1484: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
1485:
1486: BEGIN

Line 1581: FROM qp_npreq_line_attrs_tmp

1577: -- try to get accum value from request line
1578: BEGIN
1579: SELECT DISTINCT value_from
1580: INTO l_accum
1581: FROM qp_npreq_line_attrs_tmp
1582: WHERE line_index = l_line_index -- (l_line_index is a global package variable)
1583: AND context = l_accum_context
1584: AND attribute = l_accum_attrib
1585: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;

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

2661:
2662: CURSOR get_list_details_cur(p_source_system_code VARCHAR2) IS
2663: SELECT /*+ ORDERED USE_NL(a b c d e) */ c.LIST_LINE_ID, c.OPERAND
2664: FROM
2665: qp_npreq_line_attrs_tmp a, QP_PRICING_ATTRIBUTES b, QP_LIST_LINES c, QP_LIST_HEADERS_B d, QP_QUALIFIERS e
2666: WHERE a.LINE_INDEX = p_line_index
2667: AND a.CONTEXT = b.PRODUCT_ATTRIBUTE_CONTEXT
2668: AND a.ATTRIBUTE = b.PRODUCT_ATTRIBUTE
2669: AND a.VALUE_FROM = b.PRODUCT_ATTR_VALUE