[Home] [Help]
138: update qp_pte_segments set used_in_setup='Y'
139: where nvl(used_in_setup,'N')='N'
140: and segment_id in
141: (select a.segment_id
142: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c
143: where c.list_header_id = p_list_header_id
144: and a.segment_mapping_column = c.qualifier_attribute
145: and a.prc_context_id = b.prc_context_id
146: and b.prc_context_type = 'QUALIFIER'
149: update qp_pte_segments set used_in_setup='Y'
150: where nvl(used_in_setup,'N')='N'
151: and segment_id in
152: (select a.segment_id
153: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c
154: where c.list_header_id = p_list_header_id
155: and a.segment_mapping_column = c.pricing_attribute
156: and a.prc_context_id = b.prc_context_id
157: and b.prc_context_type = 'PRICING_ATTRIBUTE'
160: update qp_pte_segments set used_in_setup='Y'
161: where nvl(used_in_setup,'N')='N'
162: and segment_id in
163: (select a.segment_id
164: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c
165: where c.list_header_id = p_list_header_id
166: and a.segment_mapping_column = c.product_attribute
167: and a.prc_context_id = b.prc_context_id
168: and b.prc_context_type = 'PRODUCT'
261: (p_segment_mapping_column IS NOT NULL) THEN
262: UPDATE qp_pte_segments set used_in_setup='Y'
263: WHERE nvl(used_in_setup,'N')='N'
264: AND segment_id IN
265: (SELECT a.segment_id FROM qp_segments_b a, qp_prc_contexts_b b
266: WHERE a.segment_mapping_column=p_segment_mapping_column
267: AND a.prc_context_id=b.prc_context_id
268: AND b.prc_context_type = p_context_type
269: AND b.prc_context_code=p_context_code);
1029: SELECT a.qualifier_grouping_no
1030: FROM qp_qualifiers a
1031: WHERE a.qualifier_rule_id = a_qualifier_rule_id
1032: AND EXISTS (SELECT 'x'
1033: FROM qp_qualifiers b, qp_prc_contexts_b d,
1034: qp_segments_b e, qp_pte_segments f
1035: WHERE b.qualifier_context = d.prc_context_code
1036: AND b.qualifier_attribute = e.segment_mapping_column
1037: AND d.prc_context_id = e.prc_context_id
1042: AND (b.qualifier_grouping_no = a.qualifier_grouping_no or
1043: b.qualifier_grouping_no = -1))
1044:
1045: AND EXISTS (SELECT 'x'
1046: FROM qp_qualifiers c, qp_prc_contexts_b d1,
1047: qp_segments_b e1, qp_pte_segments f1
1048: WHERE c.qualifier_context = d1.prc_context_code
1049: AND c.qualifier_attribute = e1.segment_mapping_column
1050: AND d1.prc_context_id = e1.prc_context_id