APPS.QP_DATA_COMPARE_PVT dependencies on QP_ATTRIBUTE_GROUPS

Line 1339: FROM qp_attribute_groups

1335: pricing_phase_id,
1336: modifier_level_code,
1337: hash_key,
1338: cache_key
1339: FROM qp_attribute_groups
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

Line 1484: FROM qp_attribute_groups

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

Line 1669: FROM qp_attribute_groups a ,

1665: AND a.pricing_phase_id = b.pricing_phase_id;
1666:
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

Line 1679: FROM qp_attribute_groups a, qp_pattern_phases b

1675: AND a.list_line_id = -1;
1676:
1677: CURSOR csr_get_lqual_pattern_phases(p_list_line_id NUMBER) IS
1678: SELECT a.list_header_id,a.pattern_id,a.pricing_phase_id
1679: FROM qp_attribute_groups a, qp_pattern_phases b
1680: WHERE a.list_line_id = p_list_line_id
1681: AND a.pattern_id = b.pattern_id
1682: AND a.pricing_phase_id = b.pricing_phase_id;
1683: