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'
164: AND dflex.descriptive_flex_context_code = lattr.context
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'
205: AND dflex.descriptive_flex_context_code = lattr.context