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.

APPS.IEX_STRATEGY_WF dependencies on IEX_STRY_TEMP_WORK_ITEMS_VL

Line 29: from iex_stry_temp_work_items_vl a,

25:
26: cursor c_get_itemtype is
27: select a.workflow_item_type itemtype,
28: b.work_item_id
29: from iex_stry_temp_work_items_vl a,
30: iex_strategy_work_items b
31: where a.work_item_temp_id =b.WORK_ITEM_TEMPLATE_ID
32: and b.strategy_id =p_strategy_id
33: and a.workflow_item_type IS NOT NULL;

Line 38: iex_stry_temp_work_items_vl b

34:
35: cursor c_workitems is
36: select a.work_item_id
37: from iex_strategy_work_items a,
38: iex_stry_temp_work_items_vl b
39: where a.strategy_id = p_strategy_id
40: and a.work_item_template_id =b.work_item_temp_id
41: and (b.fulfil_temp_id IS NOT NULL or b.xdo_template_id IS NOT NULL)
42: -- Added for bug 8996459 PNAVEENK 27-OCT-2009

Line 522: from iex_stry_temp_work_items_vl

518: select closure_time_limit, closure_time_uom,
519: schedule_wait, schedule_uom,
520: optional_yn,escalate_yn,
521: option_wait_time, option_wait_time_uom
522: from iex_stry_temp_work_items_vl
523: where work_item_temp_id =p_work_item_temp_id;
524:
525: l_optional_date DATE;
526: l_work_item_id number;

Line 891: iex_stry_temp_work_items_vl stry_temp_wkitem

887: wkitem.NOTIFY_YN NOTIFY_YN,
888: wkitem.resource_id resource_id,
889: wkitem.custom_workflow_type custom_workflow_type
890: from iex_strategy_work_items wkitem,
891: iex_stry_temp_work_items_vl stry_temp_wkitem
892: WHERE
893: wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id
894: and wkitem.strategy_id =p_strategy_id
895: --to be created work items

Line 920: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem

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
924: and stry.strategy_id =p_strategy_id

Line 969: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem

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
973: and stry.strategy_id =p_strategy_id

Line 984: SELECT competence_id from iex_stry_temp_work_items_vl

980: and wkitem.strategy_id =p_strategy_id)
981: order by ORDER_BY;
982:
983: /*cursor c_get_competence_id (p_work_item_temp_id NUMBER) IS
984: SELECT competence_id from iex_stry_temp_work_items_vl
985: where work_item_temp_id =p_work_item_temp_id;
986: */
987:
988: -- Start Bug 6717880/7170165 by Ehuh

Line 1006: from iex_stry_temp_work_items_vl

1002: cursor c_get_callback_dt (p_work_item_temp_id NUMBER) IS
1003: SELECT callback_wait, callback_uom,optional_yn,option_wait_time,
1004: option_wait_time_uom,escalate_yn, notify_yn,workflow_item_type,work_type,
1005: category_type,fulfil_temp_id
1006: from iex_stry_temp_work_items_vl
1007: where work_item_temp_id =p_work_item_temp_id;
1008:
1009: l_strategy_work_item_rec IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;
1010: l_return_status VARCHAR2(1) ;

Line 1350: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

1346:
1347: if x_work_item_id is not null then
1348: begin
1349: select a.name,b.status_code into l_workitem_name , l_wkitem_status ----bug#5874874 gnramasa
1350: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
1351: where b.work_item_template_id = a.work_item_temp_id
1352: and b.work_item_id = x_work_item_id;
1353:
1354: wf_engine.SetItemAttrText(itemtype =>itemtype,

Line 1731: iex_stry_temp_work_items_vl stry_temp_wkitem

1727: wkitem.work_item_id WORK_ITEM_ID,
1728: wkitem.work_item_template_id WORK_ITEM_TEMPLATE_ID,
1729: wkitem.status_code STATUS
1730: from iex_strategy_work_items wkitem,
1731: iex_stry_temp_work_items_vl stry_temp_wkitem
1732: WHERE
1733: wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id
1734: and wkitem.strategy_id =p_strategy_id
1735: --to be created work items

Line 1745: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem

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
1749: --not in workitems table

Line 1778: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem

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
1782: AND not exists

Line 2686: from iex_stry_temp_work_items_vl

2682: iex_debug_pub.logmessage('l_work_item_temp_id '|| l_work_item_temp_id);
2683:
2684: select decode(workflow_item_type,null,'N','Y'),
2685: workflow_item_type INTO l_result,l_custom_itemtype
2686: from iex_stry_temp_work_items_vl
2687: where work_item_temp_id =l_work_item_temp_id;
2688:
2689: iex_debug_pub.logmessage('l_result '||l_result);
2690: iex_debug_pub.logmessage('l_custom_itemtype '|| l_custom_itemtype);

Line 2826: from iex_stry_temp_work_items_vl

2822:
2823: if (l_curr_dmethod = 'FFM') then
2824: select decode(fulfil_temp_id,null,'N',wf_yes),fulfil_temp_id,work_type
2825: INTO l_result,l_fulfil_temp_id,l_work_type
2826: from iex_stry_temp_work_items_vl
2827: where work_item_temp_id =l_work_item_temp_id;
2828: else
2829: select decode(xdo_template_id,null,'N',wf_yes),xdo_template_id,work_type
2830: INTO l_result,l_fulfil_temp_id,l_work_type

Line 2831: from iex_stry_temp_work_items_vl

2827: where work_item_temp_id =l_work_item_temp_id;
2828: else
2829: select decode(xdo_template_id,null,'N',wf_yes),xdo_template_id,work_type
2830: INTO l_result,l_fulfil_temp_id,l_work_type
2831: from iex_stry_temp_work_items_vl
2832: where work_item_temp_id =l_work_item_temp_id;
2833: end if;
2834:
2835:

Line 2921: l_post_execution_wait IEX_STRY_TEMP_WORK_ITEMS_VL.post_execution_wait%type := 0.0;

2917: l_return_status VARCHAR2(1) ;
2918: l_msg_count NUMBER;
2919: l_msg_data VARCHAR2(32767);
2920: l_execution_time date;
2921: l_post_execution_wait IEX_STRY_TEMP_WORK_ITEMS_VL.post_execution_wait%type := 0.0;
2922: l_execution_time_uom IEX_STRY_TEMP_WORK_ITEMS_VL.execution_time_uom%type;
2923: l_conversion mtl_uom_conversions.conversion_rate%type := 0.0;
2924: l_return VARCHAR2(1);
2925: l_strategy_status varchar2(100);

Line 2922: l_execution_time_uom IEX_STRY_TEMP_WORK_ITEMS_VL.execution_time_uom%type;

2918: l_msg_count NUMBER;
2919: l_msg_data VARCHAR2(32767);
2920: l_execution_time date;
2921: l_post_execution_wait IEX_STRY_TEMP_WORK_ITEMS_VL.post_execution_wait%type := 0.0;
2922: l_execution_time_uom IEX_STRY_TEMP_WORK_ITEMS_VL.execution_time_uom%type;
2923: l_conversion mtl_uom_conversions.conversion_rate%type := 0.0;
2924: l_return VARCHAR2(1);
2925: l_strategy_status varchar2(100);
2926: l_curr_dmethod varchar2(10);

Line 2984: from iex_stry_temp_work_items_vl

2980: l_curr_dmethod := iex_send_xml_pvt.getCurrDeliveryMethod();
2981: if (l_curr_dmethod = 'FFM') then
2982: select decode(fulfil_temp_id,null,'N',wf_yes),fulfil_temp_id
2983: INTO l_result,l_fulfil_temp_id
2984: from iex_stry_temp_work_items_vl
2985: where work_item_temp_id =l_work_item_temp_id;
2986: else
2987: select decode(xdo_template_id,null,'N',wf_yes),xdo_template_id
2988: INTO l_result,l_fulfil_temp_id

Line 2989: from iex_stry_temp_work_items_vl

2985: where work_item_temp_id =l_work_item_temp_id;
2986: else
2987: select decode(xdo_template_id,null,'N',wf_yes),xdo_template_id
2988: INTO l_result,l_fulfil_temp_id
2989: from iex_stry_temp_work_items_vl
2990: where work_item_temp_id =l_work_item_temp_id;
2991: end if;
2992: exception
2993: when others then

Line 3022: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

3018:
3019: IF l_post_execution_wait IS NULL THEN
3020: select a.post_execution_wait, a.execution_time_uom
3021: into l_post_execution_wait, l_execution_time_uom
3022: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
3023: where b.work_item_template_id = a.work_item_temp_id
3024: and b.work_item_id = l_work_item_id;
3025: END IF;
3026: -- end for bug 10133319

Line 3108: l_pre_execution_wait IEX_STRY_TEMP_WORK_ITEMS_VL.pre_execution_wait%type := 0.0;

3104: l_work_item_temp_id NUMBER;
3105: l_work_item_id NUMBER ;
3106:
3107: l_schedule date;
3108: l_pre_execution_wait IEX_STRY_TEMP_WORK_ITEMS_VL.pre_execution_wait%type := 0.0;
3109: l_schedule_uom IEX_STRY_TEMP_WORK_ITEMS_VL.schedule_uom%type;
3110: l_return VARCHAR2(1);
3111: l_strategy_status varchar2(100);
3112:

Line 3109: l_schedule_uom IEX_STRY_TEMP_WORK_ITEMS_VL.schedule_uom%type;

3105: l_work_item_id NUMBER ;
3106:
3107: l_schedule date;
3108: l_pre_execution_wait IEX_STRY_TEMP_WORK_ITEMS_VL.pre_execution_wait%type := 0.0;
3109: l_schedule_uom IEX_STRY_TEMP_WORK_ITEMS_VL.schedule_uom%type;
3110: l_return VARCHAR2(1);
3111: l_strategy_status varchar2(100);
3112:
3113: CURSOR c_witem_details(p_work_item_id number) IS

Line 3159: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

3155:
3156: IF l_pre_execution_wait IS NULL then
3157: select a.pre_execution_wait, a.schedule_uom
3158: into l_pre_execution_wait, l_schedule_uom
3159: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
3160: where b.work_item_template_id = a.work_item_temp_id
3161: and b.work_item_id = l_work_item_id;
3162: END IF;
3163: -- end bug 10133319

Line 3373: from iex_stry_temp_work_items_vl

3369: itemkey => itemkey,
3370: aname => 'WORKITEM_TEMPLATE_ID');
3371:
3372: select nvl(optional_yn,'N') INTO l_result
3373: from iex_stry_temp_work_items_vl
3374: where work_item_temp_id =l_work_item_temp_id;
3375:
3376: l_work_item_id := wf_engine.GetItemAttrNumber(
3377: itemtype => itemtype,

Line 3452: from iex_stry_temp_work_items_vl

3448: itemkey => itemkey,
3449: aname => 'WORKITEM_TEMPLATE_ID');
3450:
3451: select nvl(escalate_yn,'N') INTO l_result
3452: from iex_stry_temp_work_items_vl
3453: where work_item_temp_id =l_work_item_temp_id;
3454:
3455: l_work_item_id := wf_engine.GetItemAttrNumber(
3456: itemtype => itemtype,

Line 3530: from iex_stry_temp_work_items_vl

3526: itemkey => itemkey,
3527: aname => 'WORKITEM_TEMPLATE_ID');
3528:
3529: select nvl(notify_yn,'N') INTO l_result
3530: from iex_stry_temp_work_items_vl
3531: where work_item_temp_id =l_work_item_temp_id;
3532:
3533: l_work_item_id := wf_engine.GetItemAttrNumber(
3534: itemtype => itemtype,