DBA Data[Home] [Help]

APPS.IEX_CHECKLIST_UTILITY dependencies on IEX_OBJECT_FILTERS

Line 271: (select max(object_filter_id) from iex_object_filters where object_filter_type = 'IEXSTRAT'

267: ISTL.CHECK_LIST_YN,
268: ISTL.CHECK_LIST_TEMP_ID ,
269: ISTL.VALID_FROM_DT,
270: ISTL.VALID_TO_DT,
271: (select max(object_filter_id) from iex_object_filters where object_filter_type = 'IEXSTRAT'
272: and object_id = istl.strategy_temp_id), --ISTL.OBJECT_FILTER_ID,
273: ISTL.STRATEGY_LEVEL,
274: ISTL.SCORE_TOLERANCE,
275: ISTL.STRATEGY_TEMP_ID

Line 343: from iex_object_filters obj, iex_strategy_template_groups stg

339:
340: -- Bug 8479638 by ehuh 5/6/2009
341: Cursor c_object_filter Is
342: select obj.object_id,obj.object_filter_id,obj.last_updated_by,obj.last_update_login
343: from iex_object_filters obj, iex_strategy_template_groups stg
344: where stg.group_id = obj.object_id
345: and obj.object_filter_type = 'IEXSTRAT'
346: and obj.object_id > 10000
347: and (stg.object_filter_id is null or stg.object_filter_id = 0);