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_STRATEGIES

Line 802: select status_code from iex_strategies where party_id = l_strategy_rec.party_id and

798: IF l_ObjectType not in ('LITIGATION', 'REPOSSESSION', 'BANKRUPTCY', 'WRITEOFF') THEN
799: IF l_DefaultStrategyLevel = 10 THEN
800: OPEN c_strategy_exists
801: FOR
802: select status_code from iex_strategies where party_id = l_strategy_rec.party_id and
803: jtf_object_id = l_strategy_rec.jtf_object_id and jtf_object_type = l_strategy_rec.jtf_object_type
804: and (checklist_yn IS null or checklist_yn = 'N') ;
805: elsif l_DefaultStrategyLevel = 20 THEN
806: OPEN c_strategy_exists

Line 808: select status_code from iex_strategies where CUST_ACCOUNT_ID = l_strategy_rec.CUST_ACCOUNT_ID and

804: and (checklist_yn IS null or checklist_yn = 'N') ;
805: elsif l_DefaultStrategyLevel = 20 THEN
806: OPEN c_strategy_exists
807: FOR
808: select status_code from iex_strategies where CUST_ACCOUNT_ID = l_strategy_rec.CUST_ACCOUNT_ID and
809: jtf_object_id = l_strategy_rec.jtf_object_id and jtf_object_type = l_strategy_rec.jtf_object_type
810: and (checklist_yn IS null or checklist_yn = 'N') ;
811: elsif l_DefaultStrategyLevel = 30 THEN
812: OPEN c_strategy_exists

Line 814: select status_code from iex_strategies where customer_site_use_ID = l_strategy_rec.customer_site_use_ID and

810: and (checklist_yn IS null or checklist_yn = 'N') ;
811: elsif l_DefaultStrategyLevel = 30 THEN
812: OPEN c_strategy_exists
813: FOR
814: select status_code from iex_strategies where customer_site_use_ID = l_strategy_rec.customer_site_use_ID and
815: jtf_object_id = l_strategy_rec.jtf_object_id and jtf_object_type = l_strategy_rec.jtf_object_type
816: and (checklist_yn IS null or checklist_yn = 'N') ;
817: ELSE
818: OPEN c_strategy_exists

Line 820: select status_code from iex_strategies where

816: and (checklist_yn IS null or checklist_yn = 'N') ;
817: ELSE
818: OPEN c_strategy_exists
819: FOR
820: select status_code from iex_strategies where
821: delinquency_id = l_strategy_rec.delinquency_id and
822: jtf_object_id = l_strategy_rec.jtf_object_id and jtf_object_type = l_strategy_rec.jtf_object_type
823: and (checklist_yn IS null or checklist_yn = 'N') ;
824: END IF;

Line 991: (select 'x' from iex_strategies SS where SS.delinquency_id = pDelinquencyID

987: where ST.category_type = pCategoryType and ST.Check_List_YN = 'N' AND
988: OBF.OBJECT_ID(+) = ST.Strategy_temp_ID and
989: OBF.OBJECT_FILTER_TYPE(+) = 'IEXSTRAT'
990: and not exists
991: (select 'x' from iex_strategies SS where SS.delinquency_id = pDelinquencyID
992: and SS.OBJECT_TYPE = pCategoryType)
993: ORDER BY strategy_rank DESC;
994: */
995: C_DynSql varchar2(1000);

Line 1105: (select 'x' from iex_strategies SS where SS.delinquency_id = p_stry_cnt_rec.delinquency_id

1101: st.strategy_level = l_DefaultStrategyLevel and
1102: OBF.OBJECT_ID(+) = ST.Strategy_temp_ID and
1103: OBF.OBJECT_FILTER_TYPE(+) = 'IEXSTRAT'
1104: and not exists
1105: (select 'x' from iex_strategies SS where SS.delinquency_id = p_stry_cnt_rec.delinquency_id
1106: and SS.OBJECT_TYPE = p_stry_cnt_rec.object_type)
1107: ORDER BY to_number(strategy_rank) DESC;
1108: */
1109: END IF;

Line 1267: select strategy_id, status_code, object_version_number from iex_strategies

1263:
1264: --Begin bug#2369298 schekuri 24-Feb-2006
1265:
1266: /*Cursor c_strategy_exists(p_delinquency_id number, p_object_id number, p_object_type varchar2) is
1267: select strategy_id, status_code, object_version_number from iex_strategies
1268: where ((delinquency_id = p_delinquency_id and
1269: object_id = p_object_id and object_type = p_object_type)) and (checklist_yn IS NULL or checkList_YN = 'N')
1270: and (status_code in ( 'OPEN', 'ONHOLD'));*/
1271: Cursor c_strategy_exists(p_object_id number, p_object_type varchar2) is

Line 1272: select strategy_id, status_code, object_version_number from iex_strategies

1268: where ((delinquency_id = p_delinquency_id and
1269: object_id = p_object_id and object_type = p_object_type)) and (checklist_yn IS NULL or checkList_YN = 'N')
1270: and (status_code in ( 'OPEN', 'ONHOLD'));*/
1271: Cursor c_strategy_exists(p_object_id number, p_object_type varchar2) is
1272: select strategy_id, status_code, object_version_number from iex_strategies
1273: where object_id = p_object_id and
1274: object_type = p_object_type and
1275: (checklist_yn IS NULL or checkList_YN = 'N') and
1276: status_code in ( 'OPEN', 'ONHOLD');

Line 1587: select s.strategy_id, st.strategy_name, s.next_work_item_id, t.name from iex_strategies s,

1583: l_ObjectType VARCHAR2(30);
1584: l_object_version_number number ;
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

Line 1601: select s.strategy_id, st.strategy_name, s.next_work_item_id, t.name from iex_strategies s,

1597: order by s.creation_date desc;
1598:
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

Line 1776: select strategy_id, status_code, object_version_number from iex_strategies where ((delinquency_id = p_delinquency_id and

1772: TYPE c_open_strategiesCurTyp IS REF CURSOR; -- weak
1773: c_open_strategies c_open_strategiesCurTyp; -- declare cursor variable
1774: /*
1775: Cursor c_strategy_exists(p_delinquency_id number, p_object_id number, p_object_type varchar2) is
1776: select strategy_id, status_code, object_version_number from iex_strategies where ((delinquency_id = p_delinquency_id and
1777: object_id = p_object_id and object_type = p_object_type)) and (checklist_yn IS NULL or checkList_YN = 'N');
1778: */
1779: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
1780:

Line 1861: select strategy_id, status_code, object_version_number from iex_strategies

1857:
1858: IF l_DefaultStrategyLevel = 10 THEN
1859: OPEN c_open_strategies
1860: FOR
1861: select strategy_id, status_code, object_version_number from iex_strategies
1862: where (party_id = p_objectid and object_id = p_objectid and object_type = p_objecttype)
1863: and (checklist_yn IS NULL or checkList_YN = 'N') and Status_Code not in ('CLOSED', 'CANCELLED');
1864:
1865: elsif l_DefaultStrategyLevel = 20 THEN

Line 1868: select strategy_id, status_code, object_version_number from iex_strategies

1864:
1865: elsif l_DefaultStrategyLevel = 20 THEN
1866: OPEN c_open_strategies
1867: FOR
1868: select strategy_id, status_code, object_version_number from iex_strategies
1869: where (cust_account_id = p_objectid and object_id = p_objectid and object_type = p_objecttype)
1870: and (checklist_yn IS NULL or checkList_YN = 'N') and Status_Code not in ('CLOSED', 'CANCELLED');
1871: elsif l_DefaultStrategyLevel = 30 THEN
1872: OPEN c_open_strategies

Line 1874: select strategy_id, status_code, object_version_number from iex_strategies

1870: and (checklist_yn IS NULL or checkList_YN = 'N') and Status_Code not in ('CLOSED', 'CANCELLED');
1871: elsif l_DefaultStrategyLevel = 30 THEN
1872: OPEN c_open_strategies
1873: FOR
1874: select strategy_id, status_code, object_version_number from iex_strategies
1875: where (customer_site_use_id = p_objectid and object_id = p_objectid and object_type = p_objecttype)
1876: and (checklist_yn IS NULL or checkList_YN = 'N') and Status_Code not in ('CLOSED', 'CANCELLED');
1877: ELSE
1878: OPEN c_open_strategies

Line 1880: select strategy_id, status_code, object_version_number from iex_strategies

1876: and (checklist_yn IS NULL or checkList_YN = 'N') and Status_Code not in ('CLOSED', 'CANCELLED');
1877: ELSE
1878: OPEN c_open_strategies
1879: FOR
1880: select strategy_id, status_code, object_version_number from iex_strategies
1881: where (delinquency_id = p_delinquencyid and object_id = p_objectid and object_type = p_objecttype)
1882: and (checklist_yn IS NULL or checkList_YN = 'N') and Status_Code not in ('CLOSED', 'CANCELLED');
1883: END IF;
1884: -- Open c_Strategy_Exists(p_delinquencyid, p_objectid, p_objecttype);