APPS.IEX_STRATEGY_WF dependencies on IEX_STRATEGY_USER_ITEMS

Line 860: from iex_strategy_user_items susit

856: susit.work_item_order ORDER_BY
857: ,nvl(swit.status_code,'NOTCREATED') STATUS
858: ,swit.work_item_id WORK_ITEM_ID
859: ,susit.strategy_id STRATEGY_ID
860: from iex_strategy_user_items susit
861: ,iex_strategy_work_items swit
862: where susit.strategy_id =p_strategy_id
863: and swit.work_item_template_id(+) =susit.work_item_temp_id
864: and swit.strategy_id(+) =p_strategy_id

Line 867: -- bug 10133319 get pre wait,post wait,notify,resource name, escalate,optional from iex_strategy_user_items if exists else from template

863: and swit.work_item_template_id(+) =susit.work_item_temp_id
864: and swit.strategy_id(+) =p_strategy_id
865: order by order_by;
866: */
867: -- bug 10133319 get pre wait,post wait,notify,resource name, escalate,optional from iex_strategy_user_items if exists else from template
868: --created work items
869: SELECT wkitem.strategy_id STRATEGY_ID,
870: wkitem.strategy_temp_id TEMPLATE_ID,
871: wkitem.work_item_order ORDER_BY,

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

929: and wkitem.work_item_order = xref.work_item_order
930: and wkitem.strategy_id =p_strategy_id
931: )
932: ----skip workitems which is status-ed SKIP
933: and not exists ( select 'x' from iex_strategy_user_items uitems where
934: uitems.strategy_id = stry.strategy_id and
935: uitems.work_item_temp_id = xref.work_item_temp_id and
936: uitems.work_item_order = xref.work_item_order and
937: uitems.operation in ('SKIP','NOTCREATED')

Line 968: , IEX_STRATEGY_user_items uitem

964: , uitem.NOTIFY_YN NOTIFY_YN
965: , uitem.resourcE_id resource_id
966: , uitem.custom_workflow_type custom_workflow_type
967: FROM IEX_STRATEGIES stry
968: , IEX_STRATEGY_user_items uitem
969: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
970: WHERE stry.STRATEGY_ID = uitem.STRATEGY_ID
971: and uitem.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
972: AND stry_temp_wkitem.enabled_flag = 'Y' -- added for bug 7299555

Line 1715: from iex_strategy_user_items susit

1711: susit.work_item_order ORDER_BY
1712: ,nvl(swit.status_code,'NOTCREATED') STATUS
1713: ,swit.work_item_id WORK_ITEM_ID
1714: ,susit.strategy_id STRATEGY_ID
1715: from iex_strategy_user_items susit
1716: ,iex_strategy_work_items swit
1717: where susit.strategy_id =p_strategy_id
1718: and swit.work_item_template_id(+) =susit.work_item_temp_id
1719: and swit.strategy_id(+) =p_strategy_id

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

1753: and wkitem.work_item_order = xref.work_item_order
1754: and wkitem.strategy_id =p_strategy_id
1755: )
1756: ----skip workitems which is status-ed SKIP
1757: and not exists ( select 'x' from iex_strategy_user_items uitems where
1758: uitems.strategy_id = stry.strategy_id and
1759: uitems.work_item_temp_id = xref.work_item_temp_id and
1760: uitems.work_item_order = xref.work_item_order and
1761: uitems.operation = 'SKIP'

Line 1777: , IEX_STRATEGY_user_items uitem

1773: , TO_NUMBER(NULL) WORK_ITEM_ID
1774: , uitem.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID
1775: , uitem.operation STATUS
1776: FROM IEX_STRATEGIES stry
1777: , IEX_STRATEGY_user_items uitem
1778: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
1779: WHERE stry.STRATEGY_ID = uitem.STRATEGY_ID
1780: and uitem.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
1781: and stry.strategy_id =p_strategy_id

Line 2622: FROM iex_strategy_user_items a,

2618: l_work_item_id NUMBER(25);
2619:
2620: CURSOR c_user_item_workflow(p_work_item_id NUMBER) IS
2621: SELECT a.custom_workflow_type
2622: FROM iex_strategy_user_items a,
2623: iex_strategy_work_items b
2624: WHERE a.strategy_id = b.strategy_id
2625: AND a.work_item_order = b.work_item_order
2626: AND b.work_item_id = p_work_item_id;