APPS.IEX_STRATEGY_WF dependencies on IEX_STRATEGY_WORK_TEMP_XREF

Line 786: from iex_strategy_work_temp_xref sxref

782: sxref.work_item_order ORDER_BY
783: ,nvl(swit.status_code,'NOTCREATED') STATUS
784: ,swit.work_item_id WORK_ITEM_ID
785: ,swit.strategy_id STRATEGY_ID
786: from iex_strategy_work_temp_xref sxref
787: ,iex_strategy_work_items swit
788: where sxref.strategy_temp_id =p_template_id
789: and swit.work_item_template_id(+) =sxref.work_item_temp_id
790: and swit.strategy_id(+) =p_strategy_id

Line 827: , IEX_STRATEGY_WORK_TEMP_XREF xref

823: , TO_NUMBER(NULL) WORK_ITEM_ID
824: , xref.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID
825: , 'NOTCREATED' STATUS
826: FROM IEX_STRATEGIES stry
827: , IEX_STRATEGY_WORK_TEMP_XREF xref
828: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
829: WHERE stry.STRATEGY_TEMPLATE_ID = xref.STRATEGY_TEMP_ID
830: and xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
831: and stry.strategy_id =p_strategy_id

Line 1539: from iex_strategy_work_temp_xref sxref

1535: sxref.work_item_order ORDER_BY
1536: ,nvl(swit.status_code,'NOTCREATED') STATUS
1537: ,swit.work_item_id WORK_ITEM_ID
1538: ,swit.strategy_id STRATEGY_ID
1539: from iex_strategy_work_temp_xref sxref
1540: ,iex_strategy_work_items swit
1541: where sxref.strategy_temp_id =p_template_id
1542: and swit.work_item_template_id(+) =sxref.work_item_temp_id
1543: and swit.strategy_id(+) =p_strategy_id

Line 1580: , IEX_STRATEGY_WORK_TEMP_XREF xref

1576: , TO_NUMBER(NULL) WORK_ITEM_ID
1577: , xref.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID
1578: , 'NOTCREATED' STATUS
1579: FROM IEX_STRATEGIES stry
1580: , IEX_STRATEGY_WORK_TEMP_XREF xref
1581: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
1582: WHERE stry.STRATEGY_TEMPLATE_ID = xref.STRATEGY_TEMP_ID
1583: and xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
1584: and stry.strategy_id =p_strategy_id