APPS.QP_ATTR_MAPPING_PUB dependencies on QP_LIST_LINES

Line 751: FROM QP_LIST_LINES B

747: WHERE A.PRICING_ATTRIBUTE_CONTEXT = l_context_name
748: AND A.PRICING_ATTRIBUTE = l_attribute_name
749: AND EXISTS
750: (SELECT /*+ no_unest */ 'x'
751: FROM QP_LIST_LINES B
752: WHERE A.PRICE_FORMULA_ID = B.PRICE_BY_FORMULA_ID)
753: AND ROWNUM < 2;
754:
755: EXCEPTION

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

1335: WHERE a.pricing_attribute_context = l_context_name
1336: AND a.pricing_attribute = l_attribute_name
1337: AND EXISTS
1338: (SELECT /*+ no_unest */ 'x'
1339: FROM qp_list_lines b
1340: WHERE a.price_formula_id = b.price_by_formula_id
1341: )
1342: AND ROWNUM < 2;
1343: --Bug#5007983 END

Line 1406: FROM qp_list_lines

1402: WHEN NO_DATA_FOUND THEN
1403: BEGIN
1404: SELECT 'Y'
1405: INTO v_is_used
1406: FROM qp_list_lines
1407: WHERE ((break_uom_context = l_context_name
1408: AND break_uom_attribute = l_attribute_name)
1409: OR
1410: (accum_context = l_context_name

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 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