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_CUST_OVERVIEW_PVT dependencies on IEX_UTILITIES

Line 112: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning

108: l_delinquency_status VARCHAR(80);
109:
110: CURSOR c_rule IS
111: SELECT rl.delinquency_status, rl.priority,
112: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning
113: FROM iex_cu_sts_rl_lines rl, iex_cust_status_rules r
114: WHERE rl.status_rule_id = l_status_rule_id
115: AND r.status_rule_id = rl.status_rule_id
116: AND trunc(sysdate) BETWEEN trunc(nvl(r.start_date,sysdate)) AND trunc(nvl(r.end_date,sysdate))

Line 248: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

244: ' SELECT litigation_id ' ||
245: ' FROM iex_litigations ' ||
246: ' WHERE party_id= :party_id ' ||
247: ' AND contract_number IS NOT NULL ' ||
248: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
249: ' AND disposition_code IS NULL )';
250: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
251: l_sql_stmt_lsd := ' select count(1) from (' ||
252: ' SELECT repossession_id' ||

Line 263: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

259: ' SELECT repossession_id ' ||
260: ' FROM iex_repossessions ' ||
261: ' WHERE party_id= :party_id ' ||
262: ' AND contract_number IS NOT NULL ' ||
263: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
264: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
265: --' AND disposition_code IS NULL )';
266: ELSIF l_delinquency_status = 'WRITEOFF' THEN
267: l_sql_stmt_lsd := ' select count(1) from (' ||

Line 280: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

276: ' SELECT writeoff_id ' ||
277: ' FROM iex_writeoffs ' ||
278: ' WHERE party_id= :party_id ' ||
279: ' AND contract_number IS NOT NULL ' ||
280: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
281: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
282: --' AND disposition_code IS NULL )';
283: */
284: ELSIF l_delinquency_status = 'LITIGATION' THEN

Line 374: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

370: ' SELECT litigation_id ' ||
371: ' FROM iex_litigations ' ||
372: ' WHERE party_id= :party_id ' ||
373: ' AND contract_number IS NOT NULL ' ||
374: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
375: ' AND disposition_code IS NULL )';
376: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
377: l_sql_stmt_lsd := ' select count(1) from (' ||
378: ' SELECT repossession_id' ||

Line 390: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

386: ' SELECT repossession_id ' ||
387: ' FROM iex_repossessions ' ||
388: ' WHERE party_id= :party_id ' ||
389: ' AND contract_number IS NOT NULL ' ||
390: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
391: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
392: --' AND disposition_code IS NULL )';
393: ELSIF l_delinquency_status = 'WRITEOFF' THEN
394: l_sql_stmt_lsd := ' select count(1) from (' ||

Line 407: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

403: ' SELECT writeoff_id ' ||
404: ' FROM iex_writeoffs ' ||
405: ' WHERE party_id= :party_id ' ||
406: ' AND contract_number IS NOT NULL ' ||
407: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
408: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
409: --' AND disposition_code IS NULL )';
410: */
411: ELSIF l_delinquency_status = 'LITIGATION' THEN

Line 468: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'BANKRUPTCY');

464: WHERE party_id = x_customer_info_rec.party_id
465: AND close_date IS NULL
466: AND NVL(DISPOSITION_CODE, ' ') NOT IN ('DISMISSED','WITHDRAWN' );
467: IF l_bkr_count > 0 then
468: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'BANKRUPTCY');
469: ELSE
470: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');
471: END IF;
472: END IF;

Line 470: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');

466: AND NVL(DISPOSITION_CODE, ' ') NOT IN ('DISMISSED','WITHDRAWN' );
467: IF l_bkr_count > 0 then
468: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'BANKRUPTCY');
469: ELSE
470: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');
471: END IF;
472: END IF;
473:
474: -- End for bug#7830847

Line 2068: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning

2064: l_delinquency_status VARCHAR(80);
2065:
2066: CURSOR c_rule IS
2067: SELECT rl.delinquency_status, rl.priority,
2068: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning
2069: FROM iex_cu_sts_rl_lines rl, iex_cust_status_rules r
2070: WHERE rl.status_rule_id = l_status_rule_id
2071: AND r.status_rule_id = rl.status_rule_id
2072: AND trunc(sysdate) BETWEEN trunc(nvl(r.start_date,sysdate)) AND trunc(nvl(r.end_date,sysdate))

Line 2247: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2243: ' SELECT litigation_id ' ||
2244: ' FROM iex_litigations ' ||
2245: ' WHERE party_id= :party_id ' ||
2246: ' AND contract_number IS NOT NULL ' ||
2247: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2248: ' AND disposition_code IS NULL )';
2249: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
2250: l_sql_stmt_lsd := ' select count(1) from (' ||
2251: ' SELECT repossession_id' ||

Line 2263: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2259: ' SELECT repossession_id ' ||
2260: ' FROM iex_repossessions ' ||
2261: ' WHERE party_id= :party_id ' ||
2262: ' AND contract_number IS NOT NULL ' ||
2263: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2264: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W'')) ' ;
2265: -- Bug 766183 ' AND disposition_code IS NULL )';
2266: ELSIF l_delinquency_status = 'WRITEOFF' THEN
2267: l_sql_stmt_lsd := ' select count(1) from (' ||

Line 2280: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2276: ' SELECT writeoff_id ' ||
2277: ' FROM iex_writeoffs ' ||
2278: ' WHERE party_id= :party_id ' ||
2279: ' AND contract_number IS NOT NULL ' ||
2280: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2281: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
2282: -- ' AND disposition_code IS NULL )';
2283: */
2284: ELSIF l_delinquency_status = 'LITIGATION' THEN

Line 2374: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2370: ' SELECT litigation_id ' ||
2371: ' FROM iex_litigations ' ||
2372: ' WHERE party_id= :party_id ' ||
2373: ' AND contract_number IS NOT NULL ' ||
2374: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2375: ' AND disposition_code IS NULL )';
2376: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
2377: l_sql_stmt_lsd := ' select count(1) from (' ||
2378: ' SELECT repossession_id' ||

Line 2390: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2386: ' SELECT repossession_id ' ||
2387: ' FROM iex_repossessions ' ||
2388: ' WHERE party_id= :party_id ' ||
2389: ' AND contract_number IS NOT NULL ' ||
2390: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2391: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W'')) ' ;
2392: -- Bug 766183 ' AND disposition_code IS NULL )';
2393: ELSIF l_delinquency_status = 'WRITEOFF' THEN
2394: l_sql_stmt_lsd := ' select count(1) from (' ||

Line 2407: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||

2403: ' SELECT writeoff_id ' ||
2404: ' FROM iex_writeoffs ' ||
2405: ' WHERE party_id= :party_id ' ||
2406: ' AND contract_number IS NOT NULL ' ||
2407: ' AND ''DELINQUENT'' = IEX_UTILITIES.CheckContractStatus(contract_number) ' ||
2408: ' AND (disposition_code IS NULL or disposition_code = ''A'' or disposition_code = ''W''))' ;
2409: -- ' AND disposition_code IS NULL )';
2410: */
2411: ELSIF l_delinquency_status = 'LITIGATION' THEN

Line 2466: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'BANKRUPTCY');

2462: WHERE party_id = x_customer_info_rec.party_id
2463: AND close_date IS NULL
2464: AND NVL(DISPOSITION_CODE, ' ') NOT IN ('DISMISSED','WITHDRAWN' );
2465: IF l_bkr_count > 0 then
2466: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'BANKRUPTCY');
2467: ELSE
2468: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');
2469: END IF;
2470:

Line 2468: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');

2464: AND NVL(DISPOSITION_CODE, ' ') NOT IN ('DISMISSED','WITHDRAWN' );
2465: IF l_bkr_count > 0 then
2466: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'BANKRUPTCY');
2467: ELSE
2468: x_customer_info_rec.status := iex_utilities.get_lookup_meaning('IEX_CUSTOMER_STATUS_TYPE', 'CURRENT');
2469: END IF;
2470:
2471: END IF;
2472: -- End for bug#7590635