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_CNT_PUB dependencies on IEX_PROMISE_DETAILS

Line 1127: from iex_promise_details pd,

1123: AND ps.payment_schedule_id = del.payment_schedule_id
1124: AND ps.status = 'OP'
1125: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1126: and not exists(select 1
1127: from iex_promise_details pd,
1128: gl_sets_of_books gl,
1129: ar_system_parameters_all sys
1130: where pd.delinquency_id=del.delinquency_id
1131: and pd.status='COLLECTABLE'

Line 1159: from iex_promise_details pd,

1155: AND ps.payment_schedule_id = del.payment_schedule_id
1156: AND ps.status = 'OP'
1157: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1158: and not exists(select 1
1159: from iex_promise_details pd,
1160: gl_sets_of_books gl,
1161: ar_system_parameters_all sys
1162: where pd.delinquency_id=del.delinquency_id
1163: and pd.status='COLLECTABLE'

Line 1191: from iex_promise_details pd,

1187: AND ps.payment_schedule_id = del.payment_schedule_id
1188: AND ps.status = 'OP'
1189: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1190: and not exists(select 1
1191: from iex_promise_details pd,
1192: gl_sets_of_books gl,
1193: ar_system_parameters_all sys
1194: where pd.delinquency_id=del.delinquency_id
1195: and pd.status='COLLECTABLE'

Line 1223: from iex_promise_details pd,

1219: AND ps.payment_schedule_id = del.payment_schedule_id
1220: AND ps.status = 'OP'
1221: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1222: and not exists(select 1
1223: from iex_promise_details pd,
1224: gl_sets_of_books gl,
1225: ar_system_parameters_all sys
1226: where pd.delinquency_id=del.delinquency_id
1227: and pd.status='COLLECTABLE'

Line 1745: not exists (select 1 from iex_promise_details p

1741: where s.strategy_level = 10 and
1742: s.status_code = 'ONHOLD' and
1743: d.status in ('DELINQUENT','PREDELINQUENT') and
1744: d.party_cust_id = s.party_id and
1745: not exists (select 1 from iex_promise_details p
1746: where p.status='COLLECTABLE'
1747: AND d.delinquency_id=p.delinquency_id)
1748: and nvl(s.org_id,-99) = decode(l_org_enabled,'Y',l_org_id,nvl(s.org_id,-99))
1749: --and exists ( l_custom_select = s.party_id)

Line 1762: not exists (select 1 from iex_promise_details p

1758: where s.strategy_level = 20 and
1759: s.status_code = 'ONHOLD' and
1760: d.status in ('DELINQUENT','PREDELINQUENT') and
1761: d.CUST_ACCOUNT_id = s.CUST_ACCOUNT_id and
1762: not exists (select 1 from iex_promise_details p
1763: where p.status='COLLECTABLE'
1764: AND d.delinquency_id=p.delinquency_id)
1765: and nvl(s.org_id,-99) = decode(l_org_enabled,'Y',l_org_id,nvl(s.org_id,-99))
1766: --and exists ( l_custom_select = s.cust_Account_id)

Line 1779: not exists (select 1 from iex_promise_details p

1775: where s.strategy_level = 30 and
1776: s.status_code = 'ONHOLD' and
1777: d.status in ('DELINQUENT','PREDELINQUENT') and
1778: d.customer_site_use_id = s.customer_site_use_id and
1779: not exists (select 1 from iex_promise_details p
1780: where p.status='COLLECTABLE'
1781: AND d.delinquency_id=p.delinquency_id)
1782: and nvl(s.org_id,-99) = decode(l_org_enabled,'Y',l_org_id,nvl(s.org_id,-99))
1783: --and exists ( l_custom_select = s.customer_site_use_id)

Line 1823: ' not exists (select 1 from iex_promise_details p '||

1819: ' s.status_code = ''ONHOLD'' and '||
1820: ' nvl(s.release_date,sysdate) <= SYSDATE and ' || -- Bug 14804876 bibeura
1821: ' d.status in (''DELINQUENT'',''PREDELINQUENT'') and '||
1822: ' d.party_cust_id = s.party_id and '||
1823: ' not exists (select 1 from iex_promise_details p '||
1824: ' where p.status=''COLLECTABLE'' '||
1825: ' and p.state=''PROMISE'' '|| -- bug 9738518 PNAVEENK
1826: ' AND d.delinquency_id=p.delinquency_id) ';
1827: --Start adding for bug 8756947 gnramasa 3rd Aug 09

Line 1892: ' not exists (select 1 from iex_promise_details p '||

1888: ' s.status_code = ''ONHOLD'' and '||
1889: ' nvl(s.release_date,sysdate) <= SYSDATE and ' || -- Bug 14804876 bibeura
1890: ' d.status in (''DELINQUENT'',''PREDELINQUENT'') and '||
1891: ' d.CUST_ACCOUNT_id = s.CUST_ACCOUNT_id and '||
1892: ' not exists (select 1 from iex_promise_details p '||
1893: ' where p.status=''COLLECTABLE'' '||
1894: ' and p.state=''PROMISE'' '|| -- bug 9738518 PNAVEENK
1895: ' AND d.delinquency_id=p.delinquency_id) ';
1896: if l_org_enabled = 'Y' then

Line 1961: ' not exists (select 1 from iex_promise_details p '||

1957: ' s.status_code = ''ONHOLD'' and '||
1958: ' nvl(s.release_date,sysdate) <= SYSDATE and ' || -- Bug 14804876 bibeura
1959: ' d.status in (''DELINQUENT'',''PREDELINQUENT'') and '||
1960: ' d.customer_site_use_id = s.customer_site_use_id and '||
1961: ' not exists (select 1 from iex_promise_details p '||
1962: ' where p.status=''COLLECTABLE'' '||
1963: ' and p.state=''PROMISE'' '|| -- bug 9738518 PNAVEENK
1964: ' AND d.delinquency_id=p.delinquency_id) ';
1965: if l_org_enabled = 'Y' then

Line 2029: ' not exists (select 1 from iex_promise_details p '||

2025: ' s.status_code = ''ONHOLD'' and '||
2026: ' nvl(s.release_date,sysdate) <= SYSDATE and ' || -- Bug 14804876 bibeura
2027: ' d.status in (''DELINQUENT'',''PREDELINQUENT'') and '||
2028: ' d.delinquency_id = s.delinquency_id and '||
2029: ' not exists (select 1 from iex_promise_details p '||
2030: ' where p.status=''COLLECTABLE'' '||
2031: ' and p.state=''PROMISE'' '|| -- bug 9738518 PNAVEENK
2032: ' AND d.delinquency_id=p.delinquency_id) ';
2033: if l_org_enabled = 'Y' then