DBA Data[Home] [Help]

APPS.QP_MULTI_CURRENCY_PVT dependencies on QP_SEGMENTS_B

Line 39: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS

35: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
36: AND EXISTS (
37: SELECT format_type
38: FROM fnd_flex_value_sets VSET,
39: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
40: WHERE vset.flex_value_set_id = segments.user_valueset_id
41: AND segments.application_id = 661
42: AND pcontexts.prc_context_type <> 'QUALIFIER'
43: AND pcontexts.prc_context_code = lattr.context

Line 185: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS

181: AND
182: EXISTS(
183: SELECT format_type
184: FROM fnd_flex_value_sets VSET,
185: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
186: WHERE vset.flex_value_set_id = segments.user_valueset_id
187: AND segments.application_id = 661
188: AND pcontexts.prc_context_type <> 'QUALIFIER'
189: AND pcontexts.prc_context_code = lattr.context

Line 224: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS

220: AND
221: NOT EXISTS(
222: SELECT format_type
223: FROM fnd_flex_value_sets VSET,
224: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
225: WHERE vset.flex_value_set_id = segments.user_valueset_id
226: AND segments.application_id = 661
227: AND pcontexts.prc_context_type <> 'QUALIFIER'
228: AND pcontexts.prc_context_code = lattr.context