eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_CHECKLIST_UTILITY dependencies on IEX_STRATEGY_TEMPLATES_B

Line 215: SELECT COUNT(1) FROM IEX_STRATEGY_TEMPLATES_B istl

211: -- Begin kasreeni 12-16-2005 4887338
212: PROCEDURE checkUpgradeStrategies( x_return_status OUT NOCOPY VARCHAR2) IS
213:
214: CURSOR c_CheckStrategyGroups IS
215: SELECT COUNT(1) FROM IEX_STRATEGY_TEMPLATES_B istl
216: -- WHERE istl.strategy_temp_id > 10000 and NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg -- bug 6067428
217: WHERE istl.strategy_temp_id >= 10000 and NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
218: WHERE istg.STRATEGY_TEMP_ID = ISTL.STRATEGY_TEMP_ID);
219:

Line 279: UPDATE IEX_STRATEGY_TEMPLATES_b istl

275: AND (istl.strategy_temp_group_id is NULL or istl.strategy_temp_group_id = 0)
276: AND NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
277: WHERE istg.STRATEGY_TEMP_ID = ISTL.STRATEGY_TEMP_ID);
278:
279: UPDATE IEX_STRATEGY_TEMPLATES_b istl
280: SET istl.STRATEGY_TEMP_GROUP_ID =
281: (SELECT istg.GROUP_ID FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
282: WHERE istg.strategy_temp_id = istl.strategy_temp_id)
283: WHERE istl.strategy_temp_id >= 10000