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.

[Home] [Help]

APPS.IEX_STRATEGY_WF dependencies on IEX_WORK_ITEM_BALI_V

Line 847: and (xref.work_item_order > (select max(wkitem_order) from iex_work_item_bali_v

843: uitems.work_item_order = xref.work_item_order and
844: uitems.operation = 'SKIP'
845: and uitems.strategy_id =p_strategy_id
846: )
847: and (xref.work_item_order > (select max(wkitem_order) from iex_work_item_bali_v
848: where strategy_id = p_strategy_id and start_time is not null)
849: or (select count(*) from iex_work_item_bali_v where strategy_id = p_strategy_id ) = 0
850: ) -- later on assignment of prior work items, and case of initial creation of wkitem
851: -- get all user items

Line 849: or (select count(*) from iex_work_item_bali_v where strategy_id = p_strategy_id ) = 0

845: and uitems.strategy_id =p_strategy_id
846: )
847: and (xref.work_item_order > (select max(wkitem_order) from iex_work_item_bali_v
848: where strategy_id = p_strategy_id and start_time is not null)
849: or (select count(*) from iex_work_item_bali_v where strategy_id = p_strategy_id ) = 0
850: ) -- later on assignment of prior work items, and case of initial creation of wkitem
851: -- get all user items
852: union all
853: SELECT stry.STRATEGY_ID STRATEGY_ID

Line 1600: and (xref.work_item_order > (select max(wkitem_order) from iex_work_item_bali_v

1596: uitems.work_item_order = xref.work_item_order and
1597: uitems.operation = 'SKIP'
1598: and uitems.strategy_id =p_strategy_id
1599: )
1600: and (xref.work_item_order > (select max(wkitem_order) from iex_work_item_bali_v
1601: where strategy_id = p_strategy_id and start_time is not null)
1602: or (select count(*) from iex_work_item_bali_v where strategy_id = p_strategy_id ) = 0
1603: ) -- later on assignment of prior work items, and case of initial creation of wkitem
1604: -- get all user items

Line 1602: or (select count(*) from iex_work_item_bali_v where strategy_id = p_strategy_id ) = 0

1598: and uitems.strategy_id =p_strategy_id
1599: )
1600: and (xref.work_item_order > (select max(wkitem_order) from iex_work_item_bali_v
1601: where strategy_id = p_strategy_id and start_time is not null)
1602: or (select count(*) from iex_work_item_bali_v where strategy_id = p_strategy_id ) = 0
1603: ) -- later on assignment of prior work items, and case of initial creation of wkitem
1604: -- get all user items
1605: union all
1606: SELECT stry.STRATEGY_ID STRATEGY_ID