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'
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'
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'
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'