APPS.QP_MULTI_CURRENCY_PVT dependencies on FND_FLEX_VALUE_SETS

Line 38: FROM fnd_flex_value_sets VSET,

34: WHERE attribute_type IN ('PRICING', 'PRODUCT')
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'

Line 61: FROM fnd_flex_value_sets vset

57: WHERE attribute_type IN ('PRICING', 'PRODUCT')
58: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
59: AND EXISTS(
60: SELECT format_type
61: FROM fnd_flex_value_sets vset
62: ,fnd_descr_flex_column_usages dflex
63: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
64: AND dflex.application_id = 661
65: AND dflex.descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING'

Line 184: FROM fnd_flex_value_sets VSET,

180: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
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'

Line 223: FROM fnd_flex_value_sets VSET,

219: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
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'

Line 296: FROM fnd_flex_value_sets vset

292: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
293: AND
294: EXISTS(
295: SELECT format_type
296: FROM fnd_flex_value_sets vset
297: ,fnd_descr_flex_column_usages dflex
298: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
299: AND dflex.application_id = 661
300: AND dflex.descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING'

Line 338: FROM fnd_flex_value_sets vset

334: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
335: AND
336: NOT EXISTS(
337: SELECT format_type
338: FROM fnd_flex_value_sets vset
339: ,fnd_descr_flex_column_usages dflex
340: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
341: AND dflex.application_id = 661
342: AND dflex.descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING'