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_WORK_PUB dependencies on IEX_STRATEGY_WORK_ITEMS

Line 89: iex_strategy_work_items wkitem, iex_stry_temp_work_items_b stry_temp_wkitem_b, iex_stry_temp_work_items_tl stry_temp_wkitem_tl

85: -- begin bug 4930376 ctlee - performance 01/09/2006 -- sql id 14771818
86: SELECT
87: wkitem.resource_id ASSIGNED_TO
88: from
89: iex_strategy_work_items wkitem, iex_stry_temp_work_items_b stry_temp_wkitem_b, iex_stry_temp_work_items_tl stry_temp_wkitem_tl
90: , wf_item_types_tl item, jtf_rs_resource_extns res
91: WHERE
92: wkitem.work_item_template_id = stry_temp_wkitem_b.work_item_temp_id
93: and stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id

Line 591: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b

587: select upper(b.category_type),
588: nvl(include_disputed_items,'N') -- bug 14772139
589: into l_dunning_method,
590: l_include_disputed_items -- bug 14772139
591: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b
592: where a.work_item_template_id = b.work_item_temp_id
593: and a.work_item_id = l_workitem_id
594: --and b.work_type = 'AUTOMATIC';-- bug 14772139
595: and b.work_type in ('AUTOMATIC','WORKFLOW'); -- bug 14772139

Line 993: from hz_parties a, iex_strategy_work_items w, iex_strategies s

989:
990: cursor c_get_party(p_work_item_id number) is
991: select a.party_id, a.party_type, a.party_name,
992: a.person_first_name, a.person_last_name, s.cust_account_id, s.customer_site_use_id
993: from hz_parties a, iex_strategy_work_items w, iex_strategies s
994: where a.party_id = s.party_id and s.strategy_id = w.strategy_id and w.work_item_id = p_work_item_id;
995:
996: -- bug 4930376 ctlee sql id 14771930, use _all performance
997: cursor c_get_payment(p_delinquency_id number) is

Line 1005: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

1001: and b.delinquency_id = p_delinquency_id;
1002:
1003: cursor c_get_witem_temp(p_work_item_id NUMBER) is
1004: select a.post_execution_wait, a.execution_time_uom, a.schedule_wait, a.schedule_uom
1005: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
1006: where b.work_item_template_id = a.work_item_temp_id
1007: and b.work_item_id = p_work_item_id;
1008:
1009: l_fulfillment_wait date;

Line 1031: from iex_strategies a, iex_strategy_work_items b

1027: END IF;
1028: begin
1029: select a.strategy_level,b.resource_id,a.strategy_id --Added strategy_id for bug#5502077 schekuri 02-May-2007
1030: into l_strategy_level,l_resource_id,l_strategy_id
1031: from iex_strategies a, iex_strategy_work_items b
1032: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1033: if l_strategy_level is null then
1034: l_strategy_level := 40;
1035: end if;

Line 1868: from iex_strategies a, iex_strategy_work_items b

1864: and b.delinquency_id = p_delinquency_id;
1865:
1866: cursor c_get_witem_temp(p_work_item_id NUMBER) is
1867: select delinquency_id, a.strategy_id
1868: from iex_strategies a, iex_strategy_work_items b
1869: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1870:
1871: -- ctlee using xdo template id
1872: cursor c_get_xdo_template(p_work_item_id NUMBER) is

Line 1873: select a.xdo_template_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b

1869: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1870:
1871: -- ctlee using xdo template id
1872: cursor c_get_xdo_template(p_work_item_id NUMBER) is
1873: select a.xdo_template_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b
1874: where a.work_item_temp_id = b.work_item_template_id and work_item_id = p_work_item_id;
1875:
1876: cursor c_get_fulfillment_template(p_work_item_id NUMBER) is
1877: select fulfil_temp_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b

Line 1877: select fulfil_temp_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b

1873: select a.xdo_template_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b
1874: where a.work_item_temp_id = b.work_item_template_id and work_item_id = p_work_item_id;
1875:
1876: cursor c_get_fulfillment_template(p_work_item_id NUMBER) is
1877: select fulfil_temp_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b
1878: where a.work_item_temp_id = b.work_item_template_id and work_item_id = p_work_item_id;
1879:
1880: cursor c_get_party(p_work_item_id number) is
1881: select a.party_id, a.party_type, a.party_name,

Line 1883: from hz_parties a, iex_strategy_work_items w, iex_strategies s

1879:
1880: cursor c_get_party(p_work_item_id number) is
1881: select a.party_id, a.party_type, a.party_name,
1882: a.person_first_name, a.person_last_name, s.cust_account_id, s.customer_site_use_id
1883: from hz_parties a, iex_strategy_work_items w, iex_strategies s
1884: where a.party_id = s.party_id and s.strategy_id = w.strategy_id and w.work_item_id = p_work_item_id;
1885:
1886: l_strategy_level number ;
1887: l_DefaultStrategyLevel varchar2(20);

Line 1897: iex_strategy_work_items wkitem, iex_stry_temp_work_items_b stry_temp_wkitem_b, iex_stry_temp_work_items_tl stry_temp_wkitem_tl

1893: -- begin bug 4930376 ctlee - performance 01/09/2006 -- sql id 14772213
1894: SELECT
1895: wkitem.resource_id ASSIGNED_TO
1896: from
1897: iex_strategy_work_items wkitem, iex_stry_temp_work_items_b stry_temp_wkitem_b, iex_stry_temp_work_items_tl stry_temp_wkitem_tl
1898: , wf_item_types_tl item, jtf_rs_resource_extns res
1899: WHERE
1900: wkitem.work_item_template_id = stry_temp_wkitem_b.work_item_temp_id
1901: and stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id

Line 1958: select a.strategy_level into l_strategy_level from iex_strategies a, iex_strategy_work_items b

1954: l_template_id := l_fulfil_temp_id;
1955: exit;
1956: END LOOP;
1957: begin
1958: select a.strategy_level into l_strategy_level from iex_strategies a, iex_strategy_work_items b
1959: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1960: if l_strategy_level is null then
1961: l_strategy_level := 40;
1962: end if;

Line 2308: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b

2304: select upper(b.category_type),
2305: nvl(include_disputed_items,'N') -- bug 14772139
2306: into l_dunning_method,
2307: l_include_disputed_items -- bug 14772139
2308: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b
2309: where a.work_item_template_id = b.work_item_temp_id
2310: and a.work_item_id = l_workitem_id
2311: --and b.work_type = 'AUTOMATIC';-- bug 14772139
2312: and b.work_type in ('AUTOMATIC','WORKFLOW'); -- bug 14772139

Line 2804: iex_strategy_work_items wi

2800: BEGIN
2801: select dun.object_id
2802: into l_work_item_id
2803: from iex_dunnings dun,
2804: iex_strategy_work_items wi
2805: where dun.object_id=wi.work_item_id
2806: and dun.object_type='IEX_STRATEGY'
2807: and wi.status_code in ('OPEN','INERROR_CHECK_NOTIFY')
2808: and dun.xml_request_id=p_xml_request_id;

Line 2868: iex_strategy_work_items wi,

2864: x_error_message out NOCOPY varchar2) IS
2865: cursor c_error_workitems(l_from_date date) is
2866: select wi.work_item_id work_item_id
2867: from iex_dunnings dun,
2868: iex_strategy_work_items wi,
2869: iex_xml_request_histories xrh
2870: where dun.object_id=wi.work_item_id
2871: and xrh.object_type='IEX_STRATEGY'
2872: and xrh.creation_date>=nvl(l_from_date,xrh.creation_date)