DBA Data[Home] [Help]

APPS.QP_MULTI_CURRENCY_PVT dependencies on FND_FLEX_VALUE_SETS

Line 83: FROM fnd_flex_value_sets VSET,

79: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
80: AND
81: EXISTS(
82: SELECT format_type
83: FROM fnd_flex_value_sets VSET,
84: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
85: WHERE vset.flex_value_set_id = segments.user_valueset_id
86: AND segments.application_id = 661
87: AND pcontexts.prc_context_type <> 'QUALIFIER'

Line 120: FROM fnd_flex_value_sets VSET,

116: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
117: AND
118: NOT EXISTS(
119: SELECT format_type
120: FROM fnd_flex_value_sets VSET,
121: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
122: WHERE vset.flex_value_set_id = segments.user_valueset_id
123: AND segments.application_id = 661
124: AND pcontexts.prc_context_type <> 'QUALIFIER'

Line 159: FROM fnd_flex_value_sets vset

155: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
156: AND
157: EXISTS(
158: SELECT format_type
159: FROM fnd_flex_value_sets vset
160: ,fnd_descr_flex_column_usages dflex
161: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
162: AND dflex.application_id = 661
163: AND dflex.descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING'

Line 200: FROM fnd_flex_value_sets vset

196: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
197: AND
198: NOT EXISTS(
199: SELECT format_type
200: FROM fnd_flex_value_sets vset
201: ,fnd_descr_flex_column_usages dflex
202: WHERE vset.flex_value_set_id = dflex.flex_value_set_id
203: AND dflex.application_id = 661
204: AND dflex.descriptive_flexfield_name = 'QP_ATTR_DEFNS_PRICING'