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 138: ' from iex_delinquencies d where (d.status = ''DELINQUENT'' ' ||

134: ' d.transaction_id, d.payment_schedule_id, ' ||
135: ' d.delinquency_id object_id, ''DELINQUENT'' object_type , ' ||
136: ' d.score_value ' ||
137: ' , 40 strategy_level, d.delinquency_id jtf_object_id, ''IEX_DELINQUENCY'' jtf_object_type ' ||
138: ' from iex_delinquencies d where (d.status = ''DELINQUENT'' ' ||
139: ' or d.status = ''PREDELINQUENT'') ' ||
140: ' and d.delinquency_id = :pObjectID ';
141:
142: c_Bankruptcy :=

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

144: ' d.transaction_id, d.payment_schedule_id, ' ||
145: ' bankruptcy_id object_id, ''BANKRUPTCY'' object_type, ' ||
146: ' d.score_value ' ||
147: ' , NULL strategy_level, bankruptcy_id jtf_object_id, ''IEX_BANKRUPTCY'' jtf_object_type ' ||
148: ' from iex_delinquencies d, iex_bankruptcies b where (d.status = ''DELINQUENT'' ' ||
149: ' or d.status = ''PREDELINQUENT'') ' ||
150: ' and d.delinquency_id = b.delinquency_id ' ||
151: ' and d.delinquency_id = :p_DelinquencyID ' ||
152: ' and b.bankruptcy_id = :p_ObjectID ';

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

156: ' d.transaction_id, d.payment_schedule_id, ' ||
157: ' writeoff_id object_id, ''WRITEOFF'' object_type, ' ||
158: ' d.score_value ' ||
159: ' , NULL strategy_level, writeoff_id jtf_object_id, ''IEX_WRITEOFF'' jtf_object_type ' ||
160: ' from iex_delinquencies d, iex_writeoffs b where (d.status = ''DELINQUENT'' ' ||
161: ' or d.status = ''PREDELINQUENT'') ' ||
162: ' and d.delinquency_id = b.delinquency_id ' ||
163: ' and d.delinquency_id = :p_DelinquencyID ' ||
164: ' and b.writeoff_id = :p_ObjectID ';

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

168: ' d.transaction_id, d.payment_schedule_id, ' ||
169: ' repossession_id object_id, ''REPOSSESSION'' object_type, ' ||
170: ' d.score_value ' ||
171: ' , NULL strategy_level, repossession_id jtf_object_id, ''IEX_REPOSSESSION'' jtf_object_type ' ||
172: ' from iex_delinquencies d, iex_repossessions b where (d.status = ''DELINQUENT'' ' ||
173: ' or d.status = ''PREDELINQUENT'') ' ||
174: ' and d.delinquency_id = b.delinquency_id ' ||
175: ' and d.delinquency_id = :p_DelinquencyID ' ||
176: ' and b.repossession_id = :p_ObjectID ';

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

180: ' d.transaction_id, d.payment_schedule_id, ' ||
181: 'litigation_id object_id, ''LITIGATION'' object_type, ' ||
182: ' d.score_value ' ||
183: ' , NULL strategy_level, litigation_id jtf_object_id, ''IEX_LITIGATION'' jtf_object_type ' ||
184: ' from iex_delinquencies d, iex_litigations 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.litigation_id = :p_ObjectID ';

Line 194: ' from iex_delinquencies d' ||

190: C_Party :=
191: 'select d.party_cust_id, null, null, null, null, null, ' ||
192: ' d.PARTY_CUST_ID object_id, ''PARTY'' object_type, null' ||
193: ' , 10 strategy_level, d.PARTY_CUST_ID jtf_object_id, ''PARTY'' jtf_object_type' ||
194: ' from iex_delinquencies d' ||
195: ' where (d.status = ''DELINQUENT'' ' ||
196: ' or d.status = ''PREDELINQUENT'') ' ||
197: ' and d.party_cust_id = :pObjectID ' ||
198: ' group by d.party_cust_id ';

Line 204: ' from iex_delinquencies d ' ||

200: C_IEX_Account :=
201: ' select d.party_cust_id, d.cust_account_id, null, null, null, null, ' ||
202: ' d.cust_account_id object_id, ''ACCOUNT'' object_type, null, ' ||
203: ' 20 strategy_level, d.cust_account_id jtf_object_id, ''IEX_ACCOUNT'' jtf_object_type ' ||
204: ' from iex_delinquencies d ' ||
205: ' where (d.status = ''DELINQUENT'' ' ||
206: ' or d.status = ''PREDELINQUENT'') ' ||
207: ' and d.cust_account_id = :pObjectID ' ||
208: ' group by d.party_cust_id, d.cust_account_id ';

Line 214: ' from iex_delinquencies d ' ||

210: C_IEX_BILLTO :=
211: ' select d.party_cust_id, d.cust_account_id, d.customer_site_use_id , null, null, null, ' ||
212: ' d.customer_site_use_id object_id, ''BILL_TO'' object_type, null, ' ||
213: ' 30 strategy_level, d.customer_site_use_id jtf_object_id, ''IEX_BILLTO'' jtf_object_type ' ||
214: ' from iex_delinquencies d ' ||
215: ' where (d.status = ''DELINQUENT'' ' ||
216: ' or d.status = ''PREDELINQUENT'') ' ||
217: ' and d.customer_site_use_id = :pObjectID ' ||
218: ' group by d.party_cust_id, d.cust_account_id, d.customer_site_use_id ';

Line 625: from iex_delinquencies

621: -- but if a customer scores the delinquency we should use the delinquency score to set the strategy
622: begin
623: select payment_schedule_id
624: into l_payment_schedule_id
625: from iex_delinquencies
626: where delinquency_id = l_stry_cnt_rec.delinquency_id;
627: exception
628: WHEN OTHERS THEN
629: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1216: select status from iex_delinquencies

1212: --End bug#2369298 schekuri 24-Feb-2006
1213:
1214:
1215: Cursor c_delinquency_status(p_delinquency_id number) is
1216: select status from iex_delinquencies
1217: where delinquency_id = p_delinquency_id;
1218:
1219: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
1220: