eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.QP_PREQ_PUB dependencies on QP_PREQ_LINE_ATTRS_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 4422: FROM qp_preq_line_attrs_tmp qla2, qp_pricing_attributes qpa2

4418: AND ql.pricing_status_code IN (QP_PREQ_PUB.G_STATUS_UPDATED,
4419: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION,
4420: QP_PREQ_PUB.G_STATUS_UNCHANGED)
4421: AND NOT EXISTS (SELECT qla2.line_index
4422: FROM qp_preq_line_attrs_tmp qla2, qp_pricing_attributes qpa2
4423: WHERE qpa2.list_line_id = p_list_line_id
4424: AND qpa2.excluder_flag = G_YES
4425: AND qla2.line_index = qla.line_index
4426: AND qla2.context = qpa2.product_attribute_context

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

Line 7491: FROM qp_preq_line_attrs_tmp qla2, qp_pricing_attributes qpa2

7487: AND ql.pricing_status_code IN (QP_PREQ_PUB.G_STATUS_UPDATED,
7488: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION,
7489: QP_PREQ_PUB.G_STATUS_UNCHANGED)
7490: AND NOT EXISTS (SELECT qla2.line_index
7491: FROM qp_preq_line_attrs_tmp qla2, qp_pricing_attributes qpa2
7492: WHERE qpa2.list_line_id = p_list_line_id
7493: AND qpa2.excluder_flag = G_YES
7494: AND qla2.line_index = qla.line_index
7495: AND qla2.context = qpa2.product_attribute_context