DBA Data[Home] [Help]

APPS.QP_PREQ_PUB dependencies on QP_PREQ_LINES_TMP

Line 4391: FROM qp_preq_line_attrs_tmp qla, qp_pricing_attributes qpa, qp_preq_lines_tmp ql

4387: -- pair. exclude logic included. price_flag clause included to
4388: -- ignore free goods.
4389: CURSOR l_prod_attr_info(p_list_line_id NUMBER) IS
4390: SELECT DISTINCT qla.line_index, ql.priced_quantity, ql.unit_price
4391: FROM qp_preq_line_attrs_tmp qla, qp_pricing_attributes qpa, qp_preq_lines_tmp ql
4392: WHERE qpa.list_line_id = p_list_line_id
4393: AND qla.context = qpa.product_attribute_context
4394: AND qla.attribute = qpa.product_attribute
4395: AND qla.value_from = qpa.product_attr_value

Line 7403: FROM qp_preq_line_attrs_tmp qla, qp_pricing_attributes qpa, qp_preq_lines_tmp ql

7399: -- pair. exclude logic included. price_flag clause included to
7400: -- ignore free goods.
7401: CURSOR l_prod_attr_info(p_list_line_id NUMBER) IS
7402: SELECT DISTINCT qla.line_index, ql.priced_quantity, ql.unit_price
7403: FROM qp_preq_line_attrs_tmp qla, qp_pricing_attributes qpa, qp_preq_lines_tmp ql
7404: WHERE qpa.list_line_id = p_list_line_id
7405: AND qla.context = qpa.product_attribute_context
7406: AND qla.attribute = qpa.product_attribute
7407: AND qla.value_from = qpa.product_attr_value