APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_SEGMENTS_B

Line 150: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c

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
151: where c.list_header_id = p_list_header_id
152: and a.segment_mapping_column = c.qualifier_attribute
153: and a.prc_context_id = b.prc_context_id
154: and b.prc_context_type = 'QUALIFIER'

Line 161: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c

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
162: where c.list_header_id = p_list_header_id
163: and a.segment_mapping_column = c.pricing_attribute
164: and a.prc_context_id = b.prc_context_id
165: and b.prc_context_type = 'PRICING_ATTRIBUTE'

Line 172: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c

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
173: where c.list_header_id = p_list_header_id
174: and a.segment_mapping_column = c.product_attribute
175: and a.prc_context_id = b.prc_context_id
176: and b.prc_context_type = 'PRODUCT'

Line 273: (SELECT a.segment_id FROM qp_segments_b a, qp_prc_contexts_b b

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
275: AND a.prc_context_id=b.prc_context_id
276: AND b.prc_context_type = p_context_type
277: AND b.prc_context_code=p_context_code);

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