DBA Data[Home] [Help]

APPS.QP_PREQ_PUB dependencies on QP_PREQ_LINES_TMP

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

4407: -- pair. exclude logic included. price_flag clause included to
4408: -- ignore free goods.
4409: CURSOR l_prod_attr_info(p_list_line_id NUMBER) IS
4410: SELECT DISTINCT qla.line_index, ql.priced_quantity, ql.unit_price
4411: FROM qp_preq_line_attrs_tmp qla, qp_pricing_attributes qpa, qp_preq_lines_tmp ql
4412: WHERE qpa.list_line_id = p_list_line_id
4413: AND qla.context = qpa.product_attribute_context
4414: AND qla.attribute = qpa.product_attribute
4415: AND qla.value_from = qpa.product_attr_value

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

7476: -- pair. exclude logic included. price_flag clause included to
7477: -- ignore free goods.
7478: CURSOR l_prod_attr_info(p_list_line_id NUMBER) IS
7479: SELECT DISTINCT qla.line_index, ql.priced_quantity, ql.unit_price
7480: FROM qp_preq_line_attrs_tmp qla, qp_pricing_attributes qpa, qp_preq_lines_tmp ql
7481: WHERE qpa.list_line_id = p_list_line_id
7482: AND qla.context = qpa.product_attribute_context
7483: AND qla.attribute = qpa.product_attribute
7484: AND qla.value_from = qpa.product_attr_value