APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_STRATEGY_WORK_TEMP_XREF

Line 2180: -- add checking on existing iex_strategy_work_temp_xref, at least one wi required

2176: end if;
2177: */
2178:
2179: -- bug 4141678 begin - ctlee
2180: -- add checking on existing iex_strategy_work_temp_xref, at least one wi required
2181: -- bug 4141678 end - ctlee
2182:
2183:
2184: IF l_DefaultStrategyLevel = 10 or l_DefaultStrategyLevel = 20 or l_DefaultStrategyLevel = 30 THEN

Line 2198: and exists (select 1 from IEX_STRATEGY_WORK_TEMP_XREF strx

2194: AND DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',temgp.scoring_engine_id,'-1') =
2195: DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',p_stry_cnt_rec.score_id , '-1') -- for bug 13388975 pnaveenk
2196: and (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(st.valid_from_dt, SYSDATE))
2197: AND TRUNC(NVL(st.valid_to_dt, SYSDATE)))
2198: and exists (select 1 from IEX_STRATEGY_WORK_TEMP_XREF strx
2199: where strx.strategy_temp_id = st.strategy_temp_id)
2200: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
2201: and ST.STRATEGY_RANK <= p_stry_cnt_rec.SCORE_VALUE
2202: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records

Line 2225: and exists (select 1 from IEX_STRATEGY_WORK_TEMP_XREF strx

2221: AND DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',temgp.scoring_engine_id,'-1') =
2222: DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',p_stry_cnt_rec.score_id , '-1')
2223: and (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(st.valid_from_dt, SYSDATE))
2224: AND TRUNC(NVL(st.valid_to_dt, SYSDATE)))
2225: and exists (select 1 from IEX_STRATEGY_WORK_TEMP_XREF strx
2226: where strx.strategy_temp_id = st.strategy_temp_id)
2227: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
2228: and ST.STRATEGY_RANK <= p_stry_cnt_rec.SCORE_VALUE
2229: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records

Line 3660: from iex_strategy_work_temp_xref xref

3656: is
3657: select stry_temp_wkitem.name,
3658: stry_temp_wkitem.work_item_temp_id,
3659: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',(decode(stry_temp_wkitem.pre_execution_wait,0,'OPEN','PRE-WAIT'))) STATUS_MEANING
3660: from iex_strategy_work_temp_xref xref
3661: ,iex_stry_temp_work_items_vl stry_temp_wkitem
3662: where xref.work_item_temp_id = stry_temp_wkitem.work_item_temp_id
3663: and xref.strategy_temp_id = l_sty_template_id
3664: and stry_temp_wkitem.language = userenv('LANG')