DBA Data[Home] [Help]

APPS.QP_CALCULATE_PRICE_PUB dependencies on QP_QUALIFIERS

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