APPS.QP_ATTR_MAPPING_PUB dependencies on QP_LIST_HEADERS_ALL

Line 911: FROM qp_list_lines b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769

907: FROM qp_price_formula_lines a
908: WHERE a.pricing_attribute_context = l_context_name AND
909: a.pricing_attribute = l_attribute_name AND
910: EXISTS (SELECT 'x'
911: FROM qp_list_lines b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769
912: WHERE a.price_formula_id = b.price_by_formula_id AND
913: b.list_header_id = c.list_header_id AND
914: c.active_flag = 'Y')
915: AND ROWNUM < 2;

Line 950: (SELECT list_header_id FROM qp_list_headers_all -- qp_list_headers_b --bug 14065769

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
951: WHERE active_flag = 'Y')
952: AND ROWNUM < 2;
953:
954: EXCEPTION

Line 965: (SELECT list_header_id FROM qp_list_headers_all -- qp_list_headers_b --bug 14065769

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
966: WHERE active_flag = 'Y')
967: AND ROWNUM < 2;
968:
969: EXCEPTION

Line 975: FROM qp_limits a, qp_list_headers_all b -- qp_list_headers_b b --bug 14065769

971: BEGIN
972:
973: SELECT 'Y'
974: INTO v_is_used
975: FROM qp_limits a, qp_list_headers_all b -- qp_list_headers_b b --bug 14065769
976: WHERE ((a.multival_attr1_context = l_context_name
977: AND a.multival_attribute1 = l_attribute_name)
978: OR (a.multival_attr2_context = l_context_name
979: AND a.multival_attribute2 = l_attribute_name))

Line 990: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769

986: BEGIN
987:
988: SELECT 'Y'
989: INTO v_is_used
990: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769
991: WHERE a.limit_attribute_context = l_context_name
992: AND a.limit_attribute = l_attribute_name
993: AND a.limit_id = b.limit_id
994: AND b.list_header_id = c.list_header_id

Line 1535: FROM qp_list_lines b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769

1531: FROM qp_price_formula_lines a
1532: WHERE a.pricing_attribute_context = l_context_name AND
1533: a.pricing_attribute = l_attribute_name AND
1534: EXISTS (SELECT /*+ no_unest */ 'x'
1535: FROM qp_list_lines b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769
1536: WHERE a.price_formula_id = b.price_by_formula_id AND
1537: b.list_header_id = c.list_header_id AND
1538: c.active_flag = 'Y')
1539: AND ROWNUM < 2;

Line 1585: (SELECT list_header_id FROM qp_list_headers_all -- qp_list_headers_b --bug 14065769

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
1586: WHERE active_flag = 'Y')
1587: AND ROWNUM < 2;
1588:
1589: EXCEPTION

Line 1600: (SELECT list_header_id FROM qp_list_headers_all -- qp_list_headers_b --bug 14065769

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
1601: WHERE active_flag = 'Y')
1602: AND ROWNUM < 2;
1603:
1604: EXCEPTION

Line 1610: FROM qp_limits a, qp_list_headers_all b -- qp_list_headers_b b --bug 14065769

1606: BEGIN
1607:
1608: SELECT 'Y'
1609: INTO v_is_used
1610: FROM qp_limits a, qp_list_headers_all b -- qp_list_headers_b b --bug 14065769
1611: WHERE ((a.multival_attr1_context = l_context_name
1612: AND a.multival_attribute1 = l_attribute_name)
1613: OR (a.multival_attr2_context = l_context_name
1614: AND a.multival_attribute2 = l_attribute_name))

Line 1625: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769

1621: BEGIN
1622:
1623: SELECT 'Y'
1624: INTO v_is_used
1625: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769
1626: WHERE a.limit_attribute_context = l_context_name
1627: AND a.limit_attribute = l_attribute_name
1628: AND a.limit_id = b.limit_id
1629: AND b.list_header_id = c.list_header_id

Line 1639: FROM qp_list_lines a, qp_list_headers_all b -- qp_list_headers_b b --bug 14065769

1635: WHEN NO_DATA_FOUND THEN
1636: BEGIN
1637: SELECT 'Y'
1638: INTO v_is_used
1639: FROM qp_list_lines a, qp_list_headers_all b -- qp_list_headers_b b --bug 14065769
1640: WHERE ((a.break_uom_context = l_context_name
1641: AND a.break_uom_attribute = l_attribute_name)
1642: OR
1643: (a.accum_context = l_context_name