APPS.QP_ATTR_MAPPING_PUB dependencies on QP_LIST_HEADERS_B

Line 830: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c

826: --Changes made by rnayani Bug # 4960639 START
827: /**
828: SELECT 'Y'
829: INTO v_is_used
830: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
831: WHERE a.pricing_attribute_context = l_context_name
832: AND a.pricing_attribute = l_attribute_name
833: AND a.price_formula_id = b.price_by_formula_id
834: AND b.list_header_id = c.list_header_id

Line 844: FROM qp_list_lines b, qp_list_headers_b c

840: FROM qp_price_formula_lines a
841: WHERE a.pricing_attribute_context = l_context_name AND
842: a.pricing_attribute = l_attribute_name AND
843: EXISTS (SELECT 'x'
844: FROM qp_list_lines b, qp_list_headers_b c
845: WHERE a.price_formula_id = b.price_by_formula_id AND
846: b.list_header_id = c.list_header_id AND
847: c.active_flag = 'Y')
848: AND ROWNUM < 2;

Line 883: (SELECT list_header_id FROM qp_list_headers_b

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
884: WHERE active_flag = 'Y')
885: AND ROWNUM < 2;
886:
887: EXCEPTION

Line 898: (SELECT list_header_id FROM qp_list_headers_b

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
899: WHERE active_flag = 'Y')
900: AND ROWNUM < 2;
901:
902: EXCEPTION

Line 908: FROM qp_limits a, qp_list_headers_b b

904: BEGIN
905:
906: SELECT 'Y'
907: INTO v_is_used
908: FROM qp_limits a, qp_list_headers_b b
909: WHERE ((a.multival_attr1_context = l_context_name
910: AND a.multival_attribute1 = l_attribute_name)
911: OR (a.multival_attr2_context = l_context_name
912: AND a.multival_attribute2 = l_attribute_name))

Line 923: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c

919: BEGIN
920:
921: SELECT 'Y'
922: INTO v_is_used
923: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c
924: WHERE a.limit_attribute_context = l_context_name
925: AND a.limit_attribute = l_attribute_name
926: AND a.limit_id = b.limit_id
927: AND b.list_header_id = c.list_header_id

Line 1454: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c

1450: --Changes made by rnayani Bug # 4960639 START
1451: /**
1452: SELECT 'Y'
1453: INTO v_is_used
1454: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
1455: WHERE a.pricing_attribute_context = l_context_name
1456: AND a.pricing_attribute = l_attribute_name
1457: AND a.price_formula_id = b.price_by_formula_id
1458: AND b.list_header_id = c.list_header_id

Line 1468: FROM qp_list_lines b, qp_list_headers_b c

1464: FROM qp_price_formula_lines a
1465: WHERE a.pricing_attribute_context = l_context_name AND
1466: a.pricing_attribute = l_attribute_name AND
1467: EXISTS (SELECT /*+ no_unest */ 'x'
1468: FROM qp_list_lines b, qp_list_headers_b c
1469: WHERE a.price_formula_id = b.price_by_formula_id AND
1470: b.list_header_id = c.list_header_id AND
1471: c.active_flag = 'Y')
1472: AND ROWNUM < 2;

Line 1518: (SELECT list_header_id FROM qp_list_headers_b

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
1519: WHERE active_flag = 'Y')
1520: AND ROWNUM < 2;
1521:
1522: EXCEPTION

Line 1533: (SELECT list_header_id FROM qp_list_headers_b

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
1534: WHERE active_flag = 'Y')
1535: AND ROWNUM < 2;
1536:
1537: EXCEPTION

Line 1543: FROM qp_limits a, qp_list_headers_b b

1539: BEGIN
1540:
1541: SELECT 'Y'
1542: INTO v_is_used
1543: FROM qp_limits a, qp_list_headers_b b
1544: WHERE ((a.multival_attr1_context = l_context_name
1545: AND a.multival_attribute1 = l_attribute_name)
1546: OR (a.multival_attr2_context = l_context_name
1547: AND a.multival_attribute2 = l_attribute_name))

Line 1558: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c

1554: BEGIN
1555:
1556: SELECT 'Y'
1557: INTO v_is_used
1558: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c
1559: WHERE a.limit_attribute_context = l_context_name
1560: AND a.limit_attribute = l_attribute_name
1561: AND a.limit_id = b.limit_id
1562: AND b.list_header_id = c.list_header_id

Line 1572: FROM qp_list_lines a, qp_list_headers_b b

1568: WHEN NO_DATA_FOUND THEN
1569: BEGIN
1570: SELECT 'Y'
1571: INTO v_is_used
1572: FROM qp_list_lines a, qp_list_headers_b b
1573: WHERE ((a.break_uom_context = l_context_name
1574: AND a.break_uom_attribute = l_attribute_name)
1575: OR
1576: (a.accum_context = l_context_name