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 777: SELECT /+ index(qp_pricing_attributes qp_pricing_attributes_n4) / 'Y'

773: WHEN NO_DATA_FOUND THEN
774:
775: BEGIN
776:
777: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
778: INTO v_is_used
779: FROM qp_pricing_attributes
780: WHERE pricing_attribute_context = l_context_name
781: AND pricing_attribute = l_attribute_name

Line 779: FROM qp_pricing_attributes

775: BEGIN
776:
777: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
778: INTO v_is_used
779: FROM qp_pricing_attributes
780: WHERE pricing_attribute_context = l_context_name
781: AND pricing_attribute = l_attribute_name
782: AND ROWNUM < 2;
783:

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

785: WHEN NO_DATA_FOUND THEN
786:
787: BEGIN
788:
789: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
790: INTO v_is_used
791: FROM qp_pricing_attributes
792: WHERE product_attribute_context = l_context_name
793: AND product_attribute = l_attribute_name

Line 791: FROM qp_pricing_attributes

787: BEGIN
788:
789: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
790: INTO v_is_used
791: FROM qp_pricing_attributes
792: WHERE product_attribute_context = l_context_name
793: AND product_attribute = l_attribute_name
794: AND ROWNUM < 2;
795:

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

873:
874: BEGIN
875:
876:
877: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
878: INTO v_is_used
879: FROM qp_pricing_attributes
880: WHERE pricing_attribute_context = l_context_name
881: AND pricing_attribute = l_attribute_name

Line 879: FROM qp_pricing_attributes

875:
876:
877: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
878: INTO v_is_used
879: FROM qp_pricing_attributes
880: WHERE pricing_attribute_context = l_context_name
881: AND pricing_attribute = l_attribute_name
882: AND list_header_id IN
883: (SELECT list_header_id FROM qp_list_headers_b

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

888: WHEN NO_DATA_FOUND THEN
889:
890: BEGIN
891:
892: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
893: INTO v_is_used
894: FROM qp_pricing_attributes
895: WHERE product_attribute_context = l_context_name
896: AND product_attribute = l_attribute_name

Line 894: FROM qp_pricing_attributes

890: BEGIN
891:
892: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
893: INTO v_is_used
894: FROM qp_pricing_attributes
895: WHERE product_attribute_context = l_context_name
896: AND product_attribute = l_attribute_name
897: AND list_header_id IN
898: (SELECT list_header_id FROM qp_list_headers_b

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

1378: WHEN no_data_found then
1379: --bug 7494395
1380: BEGIN
1381:
1382: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
1383: INTO v_is_used
1384: FROM qp_pricing_attributes
1385: WHERE pricing_attribute_context = l_context_name
1386: AND pricing_attribute = l_attribute_name

Line 1384: FROM qp_pricing_attributes

1380: BEGIN
1381:
1382: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
1383: INTO v_is_used
1384: FROM qp_pricing_attributes
1385: WHERE pricing_attribute_context = l_context_name
1386: AND pricing_attribute = l_attribute_name
1387: AND ROWNUM < 2;
1388:

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

1390: WHEN NO_DATA_FOUND THEN
1391:
1392: BEGIN
1393:
1394: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
1395: INTO v_is_used
1396: FROM qp_pricing_attributes
1397: WHERE product_attribute_context = l_context_name
1398: AND product_attribute = l_attribute_name

Line 1396: FROM qp_pricing_attributes

1392: BEGIN
1393:
1394: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
1395: INTO v_is_used
1396: FROM qp_pricing_attributes
1397: WHERE product_attribute_context = l_context_name
1398: AND product_attribute = l_attribute_name
1399: AND ROWNUM < 2;
1400:

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

1508: WHEN no_data_found then
1509: --bug 7494395
1510: BEGIN
1511:
1512: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
1513: INTO v_is_used
1514: FROM qp_pricing_attributes
1515: WHERE pricing_attribute_context = l_context_name
1516: AND pricing_attribute = l_attribute_name

Line 1514: FROM qp_pricing_attributes

1510: BEGIN
1511:
1512: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
1513: INTO v_is_used
1514: FROM qp_pricing_attributes
1515: WHERE pricing_attribute_context = l_context_name
1516: AND pricing_attribute = l_attribute_name
1517: AND list_header_id IN
1518: (SELECT list_header_id FROM qp_list_headers_b

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

1523: WHEN NO_DATA_FOUND THEN
1524:
1525: BEGIN
1526:
1527: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
1528: INTO v_is_used
1529: FROM qp_pricing_attributes
1530: WHERE product_attribute_context = l_context_name
1531: AND product_attribute = l_attribute_name

Line 1529: FROM qp_pricing_attributes

1525: BEGIN
1526:
1527: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n1) */ 'Y'
1528: INTO v_is_used
1529: FROM qp_pricing_attributes
1530: WHERE product_attribute_context = l_context_name
1531: AND product_attribute = l_attribute_name
1532: AND list_header_id IN
1533: (SELECT list_header_id FROM qp_list_headers_b

Line 3276: FROM qp_pricing_attributes

3272: l_segment_mapping_column VARCHAR2(30);
3273:
3274: CURSOR l_pricing_attribs IS
3275: SELECT DISTINCT pricing_attribute_context, pricing_attribute
3276: FROM qp_pricing_attributes
3277: WHERE product_attribute = 'PRICING_ATTRIBUTE1'
3278: AND product_attribute_context = 'ITEM'
3279: AND product_attr_value = p_item_id
3280: AND pricing_attribute_context IS NOT NULL

Line 3453: FROM qp_pricing_attributes

3449: l_segment_mapping_column VARCHAR2(30);
3450:
3451: CURSOR l_pricing_attribs IS
3452: SELECT DISTINCT pricing_attribute_context, pricing_attribute
3453: FROM qp_pricing_attributes
3454: WHERE pricing_attribute_context IS NOT NULL
3455: AND pricing_attribute_context NOT IN ('VOLUME','ITEM')
3456: AND pricing_attribute_context <> Fnd_Api.G_MISS_CHAR
3457: AND pricing_attribute <> Fnd_Api.G_MISS_CHAR

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

3765:
3766: EXCEPTION
3767: WHEN NO_DATA_FOUND THEN
3768: BEGIN
3769: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
3770: INTO x_out
3771: FROM qp_pricing_attributes
3772: WHERE pricing_attribute_context = p_attribute_context
3773: AND pricing_attribute = p_attribute_code

Line 3771: FROM qp_pricing_attributes

3767: WHEN NO_DATA_FOUND THEN
3768: BEGIN
3769: SELECT /*+ index(qp_pricing_attributes qp_pricing_attributes_n4) */ 'Y'
3770: INTO x_out
3771: FROM qp_pricing_attributes
3772: WHERE pricing_attribute_context = p_attribute_context
3773: AND pricing_attribute = p_attribute_code
3774: AND ROWNUM < 2;
3775: