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 88: 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

84: -- begin bug 4930376 ctlee - performance 01/09/2006 -- sql id 14771818
85: SELECT
86: wkitem.resource_id ASSIGNED_TO
87: from
88: 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
89: , wf_item_types_tl item, jtf_rs_resource_extns res
90: WHERE
91: wkitem.work_item_template_id = stry_temp_wkitem_b.work_item_temp_id
92: and stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id

Line 435: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b

431: -- ctlee - 7/15 fulfillment fax method available
432: begin
433: select upper(b.category_type)
434: into l_dunning_method
435: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b
436: where a.work_item_template_id = b.work_item_temp_id
437: and a.work_item_id = l_workitem_id
438: and b.work_type = 'AUTOMATIC';
439: l_dunning_rec.dunning_method := l_dunning_method; -- default

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

762:
763: cursor c_get_party(p_work_item_id number) is
764: select a.party_id, a.party_type, a.party_name,
765: a.person_first_name, a.person_last_name, s.cust_account_id, s.customer_site_use_id
766: from hz_parties a, iex_strategy_work_items w, iex_strategies s
767: where a.party_id = s.party_id and s.strategy_id = w.strategy_id and w.work_item_id = p_work_item_id;
768:
769: -- bug 4930376 ctlee sql id 14771930, use _all performance
770: cursor c_get_payment(p_delinquency_id number) is

Line 778: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

774: and b.delinquency_id = p_delinquency_id;
775:
776: cursor c_get_witem_temp(p_work_item_id NUMBER) is
777: select a.post_execution_wait, a.execution_time_uom, a.schedule_wait, a.schedule_uom
778: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
779: where b.work_item_template_id = a.work_item_temp_id
780: and b.work_item_id = p_work_item_id;
781:
782: l_fulfillment_wait date;

Line 804: from iex_strategies a, iex_strategy_work_items b

800: END IF;
801: begin
802: select a.strategy_level,b.resource_id,a.strategy_id --Added strategy_id for bug#5502077 schekuri 02-May-2007
803: into l_strategy_level,l_resource_id,l_strategy_id
804: from iex_strategies a, iex_strategy_work_items b
805: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
806: if l_strategy_level is null then
807: l_strategy_level := 40;
808: end if;

Line 1620: from iex_strategies a, iex_strategy_work_items b

1616: and b.delinquency_id = p_delinquency_id;
1617:
1618: cursor c_get_witem_temp(p_work_item_id NUMBER) is
1619: select delinquency_id, a.strategy_id
1620: from iex_strategies a, iex_strategy_work_items b
1621: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1622:
1623: -- ctlee using xdo template id
1624: cursor c_get_xdo_template(p_work_item_id NUMBER) is

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

1621: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1622:
1623: -- ctlee using xdo template id
1624: cursor c_get_xdo_template(p_work_item_id NUMBER) is
1625: select a.xdo_template_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b
1626: where a.work_item_temp_id = b.work_item_template_id and work_item_id = p_work_item_id;
1627:
1628: cursor c_get_fulfillment_template(p_work_item_id NUMBER) is
1629: select fulfil_temp_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b

Line 1629: select fulfil_temp_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b

1625: select a.xdo_template_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b
1626: where a.work_item_temp_id = b.work_item_template_id and work_item_id = p_work_item_id;
1627:
1628: cursor c_get_fulfillment_template(p_work_item_id NUMBER) is
1629: select fulfil_temp_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b
1630: where a.work_item_temp_id = b.work_item_template_id and work_item_id = p_work_item_id;
1631:
1632: cursor c_get_party(p_work_item_id number) is
1633: select a.party_id, a.party_type, a.party_name,

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

1631:
1632: cursor c_get_party(p_work_item_id number) is
1633: select a.party_id, a.party_type, a.party_name,
1634: a.person_first_name, a.person_last_name, s.cust_account_id, s.customer_site_use_id
1635: from hz_parties a, iex_strategy_work_items w, iex_strategies s
1636: where a.party_id = s.party_id and s.strategy_id = w.strategy_id and w.work_item_id = p_work_item_id;
1637:
1638: l_strategy_level number ;
1639: l_DefaultStrategyLevel varchar2(20);

Line 1649: 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

1645: -- begin bug 4930376 ctlee - performance 01/09/2006 -- sql id 14772213
1646: SELECT
1647: wkitem.resource_id ASSIGNED_TO
1648: from
1649: 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
1650: , wf_item_types_tl item, jtf_rs_resource_extns res
1651: WHERE
1652: wkitem.work_item_template_id = stry_temp_wkitem_b.work_item_temp_id
1653: and stry_temp_wkitem_b.work_item_temp_id =stry_temp_wkitem_tl.work_item_temp_id

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

1696: l_template_id := l_fulfil_temp_id;
1697: exit;
1698: END LOOP;
1699: begin
1700: select a.strategy_level into l_strategy_level from iex_strategies a, iex_strategy_work_items b
1701: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1702: if l_strategy_level is null then
1703: l_strategy_level := 40;
1704: end if;

Line 1961: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b

1957: -- ctlee - 7/15 fulfillment fax method available
1958: begin
1959: select upper(b.category_type)
1960: into l_dunning_method
1961: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b
1962: where a.work_item_template_id = b.work_item_temp_id
1963: and a.work_item_id = l_workitem_id
1964: and b.work_type = 'AUTOMATIC';
1965: l_dunning_rec.dunning_method := l_dunning_method; -- default