APPS.IEX_STRATEGY_WF dependencies on IEX_STRATEGY_WORK_TEMP_XREF

Line 848: from iex_strategy_work_temp_xref sxref

844: sxref.work_item_order ORDER_BY
845: ,nvl(swit.status_code,'NOTCREATED') STATUS
846: ,swit.work_item_id WORK_ITEM_ID
847: ,swit.strategy_id STRATEGY_ID
848: from iex_strategy_work_temp_xref sxref
849: ,iex_strategy_work_items swit
850: where sxref.strategy_temp_id =p_template_id
851: and swit.work_item_template_id(+) =sxref.work_item_temp_id
852: and swit.strategy_id(+) =p_strategy_id

Line 919: , IEX_STRATEGY_WORK_TEMP_XREF xref

915: ,stry_temp_wkitem.notify_yn NOTIFY_YN
916: ,NULL resource_id
917: ,workflow_item_type custom_workflow_type
918: FROM IEX_STRATEGIES stry
919: , IEX_STRATEGY_WORK_TEMP_XREF xref
920: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
921: WHERE stry.STRATEGY_TEMPLATE_ID = xref.STRATEGY_TEMP_ID
922: and xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
923: AND stry_temp_wkitem.enabled_flag ='Y' -- added for bug 7299555 pnaveenk

Line 1703: from iex_strategy_work_temp_xref sxref

1699: sxref.work_item_order ORDER_BY
1700: ,nvl(swit.status_code,'NOTCREATED') STATUS
1701: ,swit.work_item_id WORK_ITEM_ID
1702: ,swit.strategy_id STRATEGY_ID
1703: from iex_strategy_work_temp_xref sxref
1704: ,iex_strategy_work_items swit
1705: where sxref.strategy_temp_id =p_template_id
1706: and swit.work_item_template_id(+) =sxref.work_item_temp_id
1707: and swit.strategy_id(+) =p_strategy_id

Line 1744: , IEX_STRATEGY_WORK_TEMP_XREF xref

1740: , TO_NUMBER(NULL) WORK_ITEM_ID
1741: , xref.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID
1742: , 'NOTCREATED' STATUS
1743: FROM IEX_STRATEGIES stry
1744: , IEX_STRATEGY_WORK_TEMP_XREF xref
1745: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
1746: WHERE stry.STRATEGY_TEMPLATE_ID = xref.STRATEGY_TEMP_ID
1747: and xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
1748: and stry.strategy_id =p_strategy_id