APPS.QP_DATA_COMPARE_PVT dependencies on QP_LIST_LINES

Line 71: FROM qp_list_lines

67: AND a.list_header_id = p_list_header_id;
68:
69: CURSOR csr_get_list_header_id(p_list_line_id NUMBER) IS
70: SELECT list_header_id
71: FROM qp_list_lines
72: WHERE list_line_id = p_list_line_id;
73:
74: BEGIN
75:

Line 269: FROM qp_list_lines

265: ORDER BY qualifier_context,qualifier_attribute;
266:
267: CURSOR csr_get_list_header_id(p_list_line_id NUMBER) IS
268: SELECT list_header_id
269: FROM qp_list_lines
270: WHERE list_line_id = p_list_line_id;
271:
272:
273: CURSOR csr_get_used_in_setup_flag(p_context VARCHAR2, p_attribute VARCHAR2, p_context_type VARCHAR2) IS

Line 493: FROM qp_list_lines

489: product_uom_code,
490: pricing_attribute_count,
491: hash_key,
492: cache_key
493: FROM qp_list_lines
494: WHERE list_line_id = p_list_line_id
495: UNION
496: SELECT list_line_id,
497: list_header_id,

Line 545: FROM qp_list_lines

541: product_uom_code,
542: pricing_attribute_count,
543: hash_key,
544: cache_key
545: FROM qp_list_lines
546: WHERE list_line_id IN (SELECT to_rltd_modifier_id
547: FROM qp_rltd_modifiers
548: WHERE from_rltd_modifier_id = p_list_line_id);
549: BEGIN

Line 1059: FROM qp_list_lines

1055: WHERE list_header_id = p_list_header_id;
1056:
1057: CURSOR csr_get_list_header_id(p_list_line_id NUMBER) IS
1058: SELECT list_header_id
1059: FROM qp_list_lines
1060: WHERE list_line_id = p_list_line_id;
1061:
1062: BEGIN
1063:

Line 1250: FROM qp_list_lines

1246: WHERE pricing_phase_id = p_pricing_phase_id;
1247:
1248: CURSOR csr_get_pricing_phase_id(p_list_line_id NUMBER) IS
1249: SELECT pricing_phase_id
1250: FROM qp_list_lines
1251: WHERE list_line_id = p_list_line_id;
1252:
1253:
1254: BEGIN

Line 1344: FROM qp_list_lines

1340: WHERE list_header_id = p_list_header_id;
1341:
1342: CURSOR csr_get_list_header_id(p_list_line_id NUMBER) IS
1343: SELECT list_header_id
1344: FROM qp_list_lines
1345: WHERE list_line_id = p_list_line_id;
1346:
1347: BEGIN
1348:

Line 1479: FROM qp_list_lines

1475: ORDER BY pattern_id,segment_id;
1476:
1477: CURSOR csr_get_prod_pattern_id(p_list_line_id NUMBER) IS
1478: SELECT pattern_id
1479: FROM qp_list_lines
1480: WHERE list_line_id = p_list_line_id;
1481:
1482: CURSOR csr_get_qual_pattern_id(p_list_line_id NUMBER) IS
1483: SELECT pattern_id,list_line_id,list_header_id

Line 1485: WHERE list_header_id IN (SELECT list_header_id FROM qp_list_lines WHERE list_line_id = p_list_line_id)

1481:
1482: CURSOR csr_get_qual_pattern_id(p_list_line_id NUMBER) IS
1483: SELECT pattern_id,list_line_id,list_header_id
1484: FROM qp_attribute_groups
1485: WHERE list_header_id IN (SELECT list_header_id FROM qp_list_lines WHERE list_line_id = p_list_line_id)
1486: AND list_line_id IN (p_list_line_id , -1);
1487:
1488: BEGIN
1489:

Line 1662: FROM qp_list_lines a , qp_pattern_phases b

1658: AND pattern_id = p_pattern_id;
1659:
1660: CURSOR csr_get_prod_pattern_phases(p_list_line_id NUMBER) IS
1661: SELECT a.list_header_id,a.pattern_id,a.pricing_phase_id
1662: FROM qp_list_lines a , qp_pattern_phases b
1663: WHERE a.list_line_id = p_list_line_id
1664: AND a.pattern_id = b.pattern_id
1665: AND a.pricing_phase_id = b.pricing_phase_id;
1666:

Line 1671: FROM qp_list_lines WHERE list_line_id = p_list_line_id) b ,

1667: CURSOR csr_get_hqual_pattern_phases(p_list_line_id NUMBER) IS
1668: SELECT a.list_header_id,a.pattern_id,c.pricing_phase_id
1669: FROM qp_attribute_groups a ,
1670: (SELECT distinct list_header_id, pricing_phase_id
1671: FROM qp_list_lines WHERE list_line_id = p_list_line_id) b ,
1672: qp_pattern_phases c
1673: WHERE a.list_header_id = b.list_header_id
1674: AND a.pattern_id = c.pattern_id
1675: AND a.list_line_id = -1;