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_ATTR_MAPPING_PUB dependencies on QP_PRICING_ATTRIBUTES

Line 844: SELECT /+ index(qp_pricing_attributes qp_pricing_attributes_n4) / 'Y'

840: WHEN NO_DATA_FOUND THEN
841:
842: BEGIN
843:
844: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
845: INTO v_is_used
846: FROM qp_pricing_attributes
847: WHERE pricing_attribute_context = l_context_name
848: AND pricing_attribute = l_attribute_name

Line 846: FROM qp_pricing_attributes

842: BEGIN
843:
844: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
845: INTO v_is_used
846: FROM qp_pricing_attributes
847: WHERE pricing_attribute_context = l_context_name
848: AND pricing_attribute = l_attribute_name
849: AND ROWNUM < 2;
850:

Line 856: SELECT /+ index(qp_pricing_attributes qp_pricing_attributes_n1) / 'Y'

852: WHEN NO_DATA_FOUND THEN
853:
854: BEGIN
855:
856: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
857: INTO v_is_used
858: FROM qp_pricing_attributes
859: WHERE product_attribute_context = l_context_name
860: AND product_attribute = l_attribute_name

Line 858: FROM qp_pricing_attributes

854: BEGIN
855:
856: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
857: INTO v_is_used
858: FROM qp_pricing_attributes
859: WHERE product_attribute_context = l_context_name
860: AND product_attribute = l_attribute_name
861: AND ROWNUM < 2;
862:

Line 944: SELECT /+ index(qp_pricing_attributes qp_pricing_attributes_n4) / 'Y'

940:
941: BEGIN
942:
943:
944: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
945: INTO v_is_used
946: FROM qp_pricing_attributes
947: WHERE pricing_attribute_context = l_context_name
948: AND pricing_attribute = l_attribute_name

Line 946: FROM qp_pricing_attributes

942:
943:
944: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
945: INTO v_is_used
946: FROM qp_pricing_attributes
947: WHERE pricing_attribute_context = l_context_name
948: AND pricing_attribute = l_attribute_name
949: AND list_header_id IN
950: (SELECT list_header_id FROM qp_list_headers_all -- qp_list_headers_b --bug 14065769

Line 959: SELECT /+ index(qp_pricing_attributes qp_pricing_attributes_n1) / 'Y'

955: WHEN NO_DATA_FOUND THEN
956:
957: BEGIN
958:
959: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
960: INTO v_is_used
961: FROM qp_pricing_attributes
962: WHERE product_attribute_context = l_context_name
963: AND product_attribute = l_attribute_name

Line 961: FROM qp_pricing_attributes

957: BEGIN
958:
959: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
960: INTO v_is_used
961: FROM qp_pricing_attributes
962: WHERE product_attribute_context = l_context_name
963: AND product_attribute = l_attribute_name
964: AND list_header_id IN
965: (SELECT list_header_id FROM qp_list_headers_all -- qp_list_headers_b --bug 14065769

Line 1449: SELECT /+ index(qp_pricing_attributes qp_pricing_attributes_n4) / 'Y'

1445: WHEN no_data_found then
1446: --bug 7494395
1447: BEGIN
1448:
1449: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
1450: INTO v_is_used
1451: FROM qp_pricing_attributes
1452: WHERE pricing_attribute_context = l_context_name
1453: AND pricing_attribute = l_attribute_name

Line 1451: FROM qp_pricing_attributes

1447: BEGIN
1448:
1449: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
1450: INTO v_is_used
1451: FROM qp_pricing_attributes
1452: WHERE pricing_attribute_context = l_context_name
1453: AND pricing_attribute = l_attribute_name
1454: AND ROWNUM < 2;
1455:

Line 1461: SELECT /+ index(qp_pricing_attributes qp_pricing_attributes_n1) / 'Y'

1457: WHEN NO_DATA_FOUND THEN
1458:
1459: BEGIN
1460:
1461: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
1462: INTO v_is_used
1463: FROM qp_pricing_attributes
1464: WHERE product_attribute_context = l_context_name
1465: AND product_attribute = l_attribute_name

Line 1463: FROM qp_pricing_attributes

1459: BEGIN
1460:
1461: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
1462: INTO v_is_used
1463: FROM qp_pricing_attributes
1464: WHERE product_attribute_context = l_context_name
1465: AND product_attribute = l_attribute_name
1466: AND ROWNUM < 2;
1467:

Line 1579: SELECT /+ index(qp_pricing_attributes qp_pricing_attributes_n4) / 'Y'

1575: WHEN no_data_found then
1576: --bug 7494395
1577: BEGIN
1578:
1579: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
1580: INTO v_is_used
1581: FROM qp_pricing_attributes
1582: WHERE pricing_attribute_context = l_context_name
1583: AND pricing_attribute = l_attribute_name

Line 1581: FROM qp_pricing_attributes

1577: BEGIN
1578:
1579: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
1580: INTO v_is_used
1581: FROM qp_pricing_attributes
1582: WHERE pricing_attribute_context = l_context_name
1583: AND pricing_attribute = l_attribute_name
1584: AND list_header_id IN
1585: (SELECT list_header_id FROM qp_list_headers_all -- qp_list_headers_b --bug 14065769

Line 1594: SELECT /+ index(qp_pricing_attributes qp_pricing_attributes_n1) / 'Y'

1590: WHEN NO_DATA_FOUND THEN
1591:
1592: BEGIN
1593:
1594: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
1595: INTO v_is_used
1596: FROM qp_pricing_attributes
1597: WHERE product_attribute_context = l_context_name
1598: AND product_attribute = l_attribute_name

Line 1596: FROM qp_pricing_attributes

1592: BEGIN
1593:
1594: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
1595: INTO v_is_used
1596: FROM qp_pricing_attributes
1597: WHERE product_attribute_context = l_context_name
1598: AND product_attribute = l_attribute_name
1599: AND list_header_id IN
1600: (SELECT list_header_id FROM qp_list_headers_all -- qp_list_headers_b --bug 14065769

Line 3534: FROM qp_pricing_attributes

3530: l_segment_mapping_column VARCHAR2(30);
3531:
3532: CURSOR l_pricing_attribs IS
3533: SELECT DISTINCT pricing_attribute_context, pricing_attribute
3534: FROM qp_pricing_attributes
3535: WHERE product_attribute = 'PRICING_ATTRIBUTE1'
3536: AND product_attribute_context = 'ITEM'
3537: AND product_attr_value = p_item_id
3538: AND pricing_attribute_context IS NOT NULL

Line 3711: FROM qp_pricing_attributes

3707: l_segment_mapping_column VARCHAR2(30);
3708:
3709: CURSOR l_pricing_attribs IS
3710: SELECT DISTINCT pricing_attribute_context, pricing_attribute
3711: FROM qp_pricing_attributes
3712: WHERE pricing_attribute_context IS NOT NULL
3713: AND pricing_attribute_context NOT IN ('VOLUME','ITEM')
3714: AND pricing_attribute_context <> Fnd_Api.G_MISS_CHAR
3715: AND pricing_attribute <> Fnd_Api.G_MISS_CHAR

Line 4027: SELECT /+ index(qp_pricing_attributes qp_pricing_attributes_n4) / 'Y'

4023:
4024: EXCEPTION
4025: WHEN NO_DATA_FOUND THEN
4026: BEGIN
4027: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
4028: INTO x_out
4029: FROM qp_pricing_attributes
4030: WHERE pricing_attribute_context = p_attribute_context
4031: AND pricing_attribute = p_attribute_code

Line 4029: FROM qp_pricing_attributes

4025: WHEN NO_DATA_FOUND THEN
4026: BEGIN
4027: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
4028: INTO x_out
4029: FROM qp_pricing_attributes
4030: WHERE pricing_attribute_context = p_attribute_context
4031: AND pricing_attribute = p_attribute_code
4032: AND ROWNUM < 2;
4033: