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_STRY_TEMP_WORK_ITEMS_VL

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