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_DELINQUENCIES

Line 174: ' from iex_delinquencies d where (d.status = ''DELINQUENT'' ' ||

170: ' d.transaction_id, d.payment_schedule_id, ' ||
171: ' d.delinquency_id object_id, ''DELINQUENT'' object_type , ' ||
172: ' d.score_value ' ||
173: ' , 40 strategy_level, d.delinquency_id jtf_object_id, ''IEX_DELINQUENCY'' jtf_object_type ' ||
174: ' from iex_delinquencies d where (d.status = ''DELINQUENT'' ' ||
175: ' or d.status = ''PREDELINQUENT'') ' ||
176: ' and d.delinquency_id = :pObjectID ';
177:
178: c_Bankruptcy :=

Line 184: ' from iex_delinquencies d, iex_bankruptcies b where (d.status = ''DELINQUENT'' ' ||

180: ' d.transaction_id, d.payment_schedule_id, ' ||
181: ' bankruptcy_id object_id, ''BANKRUPTCY'' object_type, ' ||
182: ' d.score_value ' ||
183: ' , NULL strategy_level, bankruptcy_id jtf_object_id, ''IEX_BANKRUPTCY'' jtf_object_type ' ||
184: ' from iex_delinquencies d, iex_bankruptcies b where (d.status = ''DELINQUENT'' ' ||
185: ' or d.status = ''PREDELINQUENT'') ' ||
186: ' and d.delinquency_id = b.delinquency_id ' ||
187: ' and d.delinquency_id = :p_DelinquencyID ' ||
188: ' and b.bankruptcy_id = :p_ObjectID ';

Line 196: ' from iex_delinquencies d, iex_writeoffs b where (d.status = ''DELINQUENT'' ' ||

192: ' d.transaction_id, d.payment_schedule_id, ' ||
193: ' writeoff_id object_id, ''WRITEOFF'' object_type, ' ||
194: ' d.score_value ' ||
195: ' , NULL strategy_level, writeoff_id jtf_object_id, ''IEX_WRITEOFF'' jtf_object_type ' ||
196: ' from iex_delinquencies d, iex_writeoffs b where (d.status = ''DELINQUENT'' ' ||
197: ' or d.status = ''PREDELINQUENT'') ' ||
198: ' and d.delinquency_id = b.delinquency_id ' ||
199: ' and d.delinquency_id = :p_DelinquencyID ' ||
200: ' and b.writeoff_id = :p_ObjectID ';

Line 208: ' from iex_delinquencies d, iex_repossessions b where (d.status = ''DELINQUENT'' ' ||

204: ' d.transaction_id, d.payment_schedule_id, ' ||
205: ' repossession_id object_id, ''REPOSSESSION'' object_type, ' ||
206: ' d.score_value ' ||
207: ' , NULL strategy_level, repossession_id jtf_object_id, ''IEX_REPOSSESSION'' jtf_object_type ' ||
208: ' from iex_delinquencies d, iex_repossessions b where (d.status = ''DELINQUENT'' ' ||
209: ' or d.status = ''PREDELINQUENT'') ' ||
210: ' and d.delinquency_id = b.delinquency_id ' ||
211: ' and d.delinquency_id = :p_DelinquencyID ' ||
212: ' and b.repossession_id = :p_ObjectID ';

Line 220: ' from iex_delinquencies d, iex_litigations b where (d.status = ''DELINQUENT'' ' ||

216: ' d.transaction_id, d.payment_schedule_id, ' ||
217: 'litigation_id object_id, ''LITIGATION'' object_type, ' ||
218: ' d.score_value ' ||
219: ' , NULL strategy_level, litigation_id jtf_object_id, ''IEX_LITIGATION'' jtf_object_type ' ||
220: ' from iex_delinquencies d, iex_litigations b where (d.status = ''DELINQUENT'' ' ||
221: ' or d.status = ''PREDELINQUENT'') ' ||
222: ' and d.delinquency_id = b.delinquency_id ' ||
223: ' and d.delinquency_id = :p_DelinquencyID ' ||
224: ' and b.litigation_id = :p_ObjectID ';

Line 230: ' from iex_delinquencies d' ||

226: C_Party :=
227: 'select d.party_cust_id, null, null, null, null, null, ' ||
228: ' d.PARTY_CUST_ID object_id, ''PARTY'' object_type, null' ||
229: ' , 10 strategy_level, d.PARTY_CUST_ID jtf_object_id, ''PARTY'' jtf_object_type' ||
230: ' from iex_delinquencies d' ||
231: ' where (d.status = ''DELINQUENT'' ' ||
232: ' or d.status = ''PREDELINQUENT'') ' ||
233: ' and d.party_cust_id = :pObjectID ' ||
234: ' group by d.party_cust_id ';

Line 240: ' from iex_delinquencies d ' ||

236: C_IEX_Account :=
237: ' select d.party_cust_id, d.cust_account_id, null, null, null, null, ' ||
238: ' d.cust_account_id object_id, ''ACCOUNT'' object_type, null, ' ||
239: ' 20 strategy_level, d.cust_account_id jtf_object_id, ''IEX_ACCOUNT'' jtf_object_type ' ||
240: ' from iex_delinquencies d ' ||
241: ' where (d.status = ''DELINQUENT'' ' ||
242: ' or d.status = ''PREDELINQUENT'') ' ||
243: ' and d.cust_account_id = :pObjectID ' ||
244: ' group by d.party_cust_id, d.cust_account_id ';

Line 250: ' from iex_delinquencies d ' ||

246: C_IEX_BILLTO :=
247: ' select d.party_cust_id, d.cust_account_id, d.customer_site_use_id , null, null, null, ' ||
248: ' d.customer_site_use_id object_id, ''BILL_TO'' object_type, null, ' ||
249: ' 30 strategy_level, d.customer_site_use_id jtf_object_id, ''IEX_BILLTO'' jtf_object_type ' ||
250: ' from iex_delinquencies d ' ||
251: ' where (d.status = ''DELINQUENT'' ' ||
252: ' or d.status = ''PREDELINQUENT'') ' ||
253: ' and d.customer_site_use_id = :pObjectID ' ||
254: ' group by d.party_cust_id, d.cust_account_id, d.customer_site_use_id ';

Line 661: from iex_delinquencies

657: -- but if a customer scores the delinquency we should use the delinquency score to set the strategy
658: begin
659: select payment_schedule_id
660: into l_payment_schedule_id
661: from iex_delinquencies
662: where delinquency_id = l_stry_cnt_rec.delinquency_id;
663: exception
664: WHEN OTHERS THEN
665: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1281: select status from iex_delinquencies

1277: --End bug#2369298 schekuri 24-Feb-2006
1278:
1279:
1280: Cursor c_delinquency_status(p_delinquency_id number) is
1281: select status from iex_delinquencies
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