APPS.QP_ATTR_MAPPING_PUB dependencies on QP_LIST_LINES

Line 818: FROM QP_LIST_LINES B

814: WHERE A.PRICING_ATTRIBUTE_CONTEXT = l_context_name
815: AND A.PRICING_ATTRIBUTE = l_attribute_name
816: AND EXISTS
817: (SELECT /*+ no_unest */ 'x'
818: FROM QP_LIST_LINES B
819: WHERE A.PRICE_FORMULA_ID = B.PRICE_BY_FORMULA_ID)
820: AND ROWNUM < 2;
821:
822: EXCEPTION

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

893: --Changes made by rnayani Bug # 4960639 START
894: /**
895: SELECT 'Y'
896: INTO v_is_used
897: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
898: WHERE a.pricing_attribute_context = l_context_name
899: AND a.pricing_attribute = l_attribute_name
900: AND a.price_formula_id = b.price_by_formula_id
901: AND b.list_header_id = c.list_header_id

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 1406: FROM qp_list_lines b

1402: WHERE a.pricing_attribute_context = l_context_name
1403: AND a.pricing_attribute = l_attribute_name
1404: AND EXISTS
1405: (SELECT /*+ no_unest */ 'x'
1406: FROM qp_list_lines b
1407: WHERE a.price_formula_id = b.price_by_formula_id
1408: )
1409: AND ROWNUM < 2;
1410: --Bug#5007983 END

Line 1473: FROM qp_list_lines

1469: WHEN NO_DATA_FOUND THEN
1470: BEGIN
1471: SELECT 'Y'
1472: INTO v_is_used
1473: FROM qp_list_lines
1474: WHERE ((break_uom_context = l_context_name
1475: AND break_uom_attribute = l_attribute_name)
1476: OR
1477: (accum_context = l_context_name

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

1517: --Changes made by rnayani Bug # 4960639 START
1518: /**
1519: SELECT 'Y'
1520: INTO v_is_used
1521: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
1522: WHERE a.pricing_attribute_context = l_context_name
1523: AND a.pricing_attribute = l_attribute_name
1524: AND a.price_formula_id = b.price_by_formula_id
1525: 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 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