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_STRATEGY_WF dependencies on IEX_STRATEGY_USER_ITEMS

Line 798: from iex_strategy_user_items susit

794: susit.work_item_order ORDER_BY
795: ,nvl(swit.status_code,'NOTCREATED') STATUS
796: ,swit.work_item_id WORK_ITEM_ID
797: ,susit.strategy_id STRATEGY_ID
798: from iex_strategy_user_items susit
799: ,iex_strategy_work_items swit
800: where susit.strategy_id =p_strategy_id
801: and swit.work_item_template_id(+) =susit.work_item_temp_id
802: and swit.strategy_id(+) =p_strategy_id

Line 840: and not exists ( select 'x' from iex_strategy_user_items uitems where

836: and wkitem.work_item_order = xref.work_item_order
837: and wkitem.strategy_id =p_strategy_id
838: )
839: ----skip workitems which is status-ed SKIP
840: and not exists ( select 'x' from iex_strategy_user_items uitems where
841: uitems.strategy_id = stry.strategy_id and
842: uitems.work_item_temp_id = xref.work_item_temp_id and
843: uitems.work_item_order = xref.work_item_order and
844: uitems.operation = 'SKIP'

Line 860: , IEX_STRATEGY_user_items uitem

856: , TO_NUMBER(NULL) WORK_ITEM_ID
857: , uitem.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID
858: , uitem.operation STATUS
859: FROM IEX_STRATEGIES stry
860: , IEX_STRATEGY_user_items uitem
861: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
862: WHERE stry.STRATEGY_ID = uitem.STRATEGY_ID
863: and uitem.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
864: and stry.strategy_id =p_strategy_id

Line 1551: from iex_strategy_user_items susit

1547: susit.work_item_order ORDER_BY
1548: ,nvl(swit.status_code,'NOTCREATED') STATUS
1549: ,swit.work_item_id WORK_ITEM_ID
1550: ,susit.strategy_id STRATEGY_ID
1551: from iex_strategy_user_items susit
1552: ,iex_strategy_work_items swit
1553: where susit.strategy_id =p_strategy_id
1554: and swit.work_item_template_id(+) =susit.work_item_temp_id
1555: and swit.strategy_id(+) =p_strategy_id

Line 1593: and not exists ( select 'x' from iex_strategy_user_items uitems where

1589: and wkitem.work_item_order = xref.work_item_order
1590: and wkitem.strategy_id =p_strategy_id
1591: )
1592: ----skip workitems which is status-ed SKIP
1593: and not exists ( select 'x' from iex_strategy_user_items uitems where
1594: uitems.strategy_id = stry.strategy_id and
1595: uitems.work_item_temp_id = xref.work_item_temp_id and
1596: uitems.work_item_order = xref.work_item_order and
1597: uitems.operation = 'SKIP'

Line 1613: , IEX_STRATEGY_user_items uitem

1609: , TO_NUMBER(NULL) WORK_ITEM_ID
1610: , uitem.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID
1611: , uitem.operation STATUS
1612: FROM IEX_STRATEGIES stry
1613: , IEX_STRATEGY_user_items uitem
1614: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
1615: WHERE stry.STRATEGY_ID = uitem.STRATEGY_ID
1616: and uitem.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
1617: and stry.strategy_id =p_strategy_id