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.

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

4398: AND ql.pricing_status_code IN (QP_PREQ_PUB.G_STATUS_UPDATED,
4399: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION,
4400: QP_PREQ_PUB.G_STATUS_UNCHANGED)
4401: AND NOT EXISTS (SELECT qla2.line_index
4402: FROM qp_preq_line_attrs_tmp qla2, qp_pricing_attributes qpa2
4403: WHERE qpa2.list_line_id = p_list_line_id
4404: AND qpa2.excluder_flag = G_YES
4405: AND qla2.line_index = qla.line_index
4406: AND qla2.context = qpa2.product_attribute_context

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

Line 7414: FROM qp_preq_line_attrs_tmp qla2, qp_pricing_attributes qpa2

7410: AND ql.pricing_status_code IN (QP_PREQ_PUB.G_STATUS_UPDATED,
7411: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION,
7412: QP_PREQ_PUB.G_STATUS_UNCHANGED)
7413: AND NOT EXISTS (SELECT qla2.line_index
7414: FROM qp_preq_line_attrs_tmp qla2, qp_pricing_attributes qpa2
7415: WHERE qpa2.list_line_id = p_list_line_id
7416: AND qpa2.excluder_flag = G_YES
7417: AND qla2.line_index = qla.line_index
7418: AND qla2.context = qpa2.product_attribute_context