DBA Data[Home] [Help]

APPS.QP_CALCULATE_PRICE_PUB dependencies on QP_PRICING_ATTRIBUTES

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