DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WF dependencies on IEX_WORK_ITEM_BALI_V

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

936: uitems.work_item_order = xref.work_item_order and
937: uitems.operation in ('SKIP','NOTCREATED')
938: and uitems.strategy_id =p_strategy_id
939: )
940: and (xref.work_item_order > (select max(wkitem_order) from iex_work_item_bali_v
941: where strategy_id = p_strategy_id and start_time is not null)
942: or (select count(*) from iex_work_item_bali_v where strategy_id = p_strategy_id ) = 0
943: ) -- later on assignment of prior work items, and case of initial creation of wkitem
944: -- get all user items

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

938: and uitems.strategy_id =p_strategy_id
939: )
940: and (xref.work_item_order > (select max(wkitem_order) from iex_work_item_bali_v
941: where strategy_id = p_strategy_id and start_time is not null)
942: or (select count(*) from iex_work_item_bali_v where strategy_id = p_strategy_id ) = 0
943: ) -- later on assignment of prior work items, and case of initial creation of wkitem
944: -- get all user items
945: union all
946: SELECT stry.STRATEGY_ID STRATEGY_ID

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

1760: uitems.work_item_order = xref.work_item_order and
1761: uitems.operation = 'SKIP'
1762: and uitems.strategy_id =p_strategy_id
1763: )
1764: and (xref.work_item_order > (select max(wkitem_order) from iex_work_item_bali_v
1765: where strategy_id = p_strategy_id and start_time is not null)
1766: or (select count(*) from iex_work_item_bali_v where strategy_id = p_strategy_id ) = 0
1767: ) -- later on assignment of prior work items, and case of initial creation of wkitem
1768: -- get all user items

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

1762: and uitems.strategy_id =p_strategy_id
1763: )
1764: and (xref.work_item_order > (select max(wkitem_order) from iex_work_item_bali_v
1765: where strategy_id = p_strategy_id and start_time is not null)
1766: or (select count(*) from iex_work_item_bali_v where strategy_id = p_strategy_id ) = 0
1767: ) -- later on assignment of prior work items, and case of initial creation of wkitem
1768: -- get all user items
1769: union all
1770: SELECT stry.STRATEGY_ID STRATEGY_ID