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

Line 1286: select work_item_id from iex_strategy_work_items where strategy_id=fStrategyID and status_code in ('OPEN');

1282: where delinquency_id = p_delinquency_id;
1283:
1284: -- Added for bug#7416344 by PNAVEENK on 16-3-2009
1285: Cursor C_Strategy_Status(fStrategyID number) is
1286: select work_item_id from iex_strategy_work_items where strategy_id=fStrategyID and status_code in ('OPEN');
1287: -- End for bug#7416344
1288:
1289: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
1290:

Line 1589: iex_strategy_work_items w,

1585:
1586: Cursor c_strategy(p_delinquency_id number, p_object_id number, p_object_type varchar2) is
1587: select s.strategy_id, st.strategy_name, s.next_work_item_id, t.name from iex_strategies s,
1588: iex_strategy_templates_vl st,
1589: iex_strategy_work_items w,
1590: iex_stry_temp_work_items_vl t
1591: where ((s.delinquency_id = p_delinquency_id and
1592: s.object_id = p_object_id and s.object_type = p_object_type)) and
1593: (s.checklist_yn IS NULL or s.checkList_YN = 'N')

Line 1603: iex_strategy_work_items w,

1599: --Start bug 6723540 gnramasa 02 Jan 08
1600: Cursor c_cont_strategy(p_object_id number, p_object_type varchar2) is
1601: select s.strategy_id, st.strategy_name, s.next_work_item_id, t.name from iex_strategies s,
1602: iex_strategy_templates_vl st,
1603: iex_strategy_work_items w,
1604: iex_stry_temp_work_items_vl t
1605: where (s.object_id = p_object_id and s.object_type = p_object_type) and
1606: (s.checklist_yn IS NULL or s.checkList_YN = 'N')
1607: and s.strategy_template_id = st.strategy_temp_id(+)