APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_PTE_SEGMENTS

Line 138: update qp_pte_segments set used_in_setup='Y'

134: WHERE list_header_id = p_list_header_id;
135:
136: IF p_active_flag = 'Y'
137: THEN
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

Line 149: update qp_pte_segments set used_in_setup='Y'

145: and a.prc_context_id = b.prc_context_id
146: and b.prc_context_type = 'QUALIFIER'
147: and b.prc_context_code = c.qualifier_context);
148:
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

Line 160: update qp_pte_segments set used_in_setup='Y'

156: and a.prc_context_id = b.prc_context_id
157: and b.prc_context_type = 'PRICING_ATTRIBUTE'
158: and b.prc_context_code = c.pricing_attribute_context);
159:
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

Line 262: UPDATE qp_pte_segments set used_in_setup='Y'

258: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
259: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
260: IF(p_context_code IS NOT NULL) AND
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

Line 1034: qp_segments_b e, qp_pte_segments f

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
1038: AND e.segment_id = f.segment_id

Line 1047: qp_segments_b e1, qp_pte_segments f1

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
1051: AND e1.segment_id = f1.segment_id