APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_PTE_SEGMENTS

Line 146: update qp_pte_segments set used_in_setup='Y'

142: WHERE list_header_id = p_list_header_id;
143:
144: IF p_active_flag = 'Y'
145: THEN
146: update qp_pte_segments set used_in_setup='Y'
147: where nvl(used_in_setup,'N')='N'
148: and segment_id in
149: (select a.segment_id
150: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c

Line 157: update qp_pte_segments set used_in_setup='Y'

153: and a.prc_context_id = b.prc_context_id
154: and b.prc_context_type = 'QUALIFIER'
155: and b.prc_context_code = c.qualifier_context);
156:
157: update qp_pte_segments set used_in_setup='Y'
158: where nvl(used_in_setup,'N')='N'
159: and segment_id in
160: (select a.segment_id
161: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c

Line 168: update qp_pte_segments set used_in_setup='Y'

164: and a.prc_context_id = b.prc_context_id
165: and b.prc_context_type = 'PRICING_ATTRIBUTE'
166: and b.prc_context_code = c.pricing_attribute_context);
167:
168: update qp_pte_segments set used_in_setup='Y'
169: where nvl(used_in_setup,'N')='N'
170: and segment_id in
171: (select a.segment_id
172: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c

Line 270: UPDATE qp_pte_segments set used_in_setup='Y'

266: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
267: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
268: IF(p_context_code IS NOT NULL) AND
269: (p_segment_mapping_column IS NOT NULL) THEN
270: UPDATE qp_pte_segments set used_in_setup='Y'
271: WHERE nvl(used_in_setup,'N')='N'
272: AND segment_id IN
273: (SELECT a.segment_id FROM qp_segments_b a, qp_prc_contexts_b b
274: WHERE a.segment_mapping_column=p_segment_mapping_column

Line 1042: qp_segments_b e, qp_pte_segments f

1038: FROM qp_qualifiers a
1039: WHERE a.qualifier_rule_id = a_qualifier_rule_id
1040: AND EXISTS (SELECT 'x'
1041: FROM qp_qualifiers b, qp_prc_contexts_b d,
1042: qp_segments_b e, qp_pte_segments f
1043: WHERE b.qualifier_context = d.prc_context_code
1044: AND b.qualifier_attribute = e.segment_mapping_column
1045: AND d.prc_context_id = e.prc_context_id
1046: AND e.segment_id = f.segment_id

Line 1055: qp_segments_b e1, qp_pte_segments f1

1051: b.qualifier_grouping_no = -1))
1052:
1053: AND EXISTS (SELECT 'x'
1054: FROM qp_qualifiers c, qp_prc_contexts_b d1,
1055: qp_segments_b e1, qp_pte_segments f1
1056: WHERE c.qualifier_context = d1.prc_context_code
1057: AND c.qualifier_attribute = e1.segment_mapping_column
1058: AND d1.prc_context_id = e1.prc_context_id
1059: AND e1.segment_id = f1.segment_id