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_UWQ_VIEW_PKG dependencies on HZ_CUST_ACCOUNTS

Line 54: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt, hz_cust_accounts acc ' ||

50: --BEGIN-FIX Bug#4408860-06/06/2005-jypark-exclude CLOSE status
51: -- ' AND status <> ''CURRENT'' ';
52: ' AND status NOT IN (''CURRENT'', ''CLOSE'') ';
53: --END-FIX Bug#4408860-06/06/2005-jypark-exclude CLOSE status
54: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt, hz_cust_accounts acc ' ||
55: ' WHERE bnkrpt.party_id = acc.party_id AND acc.cust_account_id = :cust_account_id';
56: l_object_id := p_cust_account_id;
57: ELSIF p_site_use_id > 0 THEN
58: l_del_clause := 'SELECT COUNT(1) FROM iex_delinquencies WHERE customer_site_use_id = :site_use_id ' ||

Line 63: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt,hz_cust_site_uses site_use, hz_cust_acct_sites acct_site, hz_cust_accounts acc ' ||

59: --BEGIN-FIX Bug#4408860-06/06/2005-jypark-exclude CLOSE status
60: -- ' AND status <> ''CURRENT'' ';
61: ' AND status NOT IN (''CURRENT'', ''CLOSE'') ';
62: --END-FIX Bug#4408860-06/06/2005-jypark-exclude CLOSE status
63: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt,hz_cust_site_uses site_use, hz_cust_acct_sites acct_site, hz_cust_accounts acc ' ||
64: ' WHERE bnkrpt.party_id = acc.party_id ' ||
65: ' AND acct_site.cust_account_id = acc.cust_account_id ' ||
66: ' AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id ' ||
67: ' AND site_use.site_use_id = :site_use_id';

Line 133: ' FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies_all del ' ||

129: IF p_party_id > 0 THEN
130: l_pro_clause := 'SELECT COUNT(1) ' ||
131: 'FROM (' ||
132: ' SELECT pro.promise_detail_id, pro.uwq_status, pro.uwq_active_date, pro.uwq_complete_date' ||
133: ' FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies_all del ' ||
134: ' WHERE ca.cust_account_id = pro.cust_account_id ' ||
135: ' AND pro.state = ''BROKEN_PROMISE'' ' ||
136: ' AND pro.status IN (''COLLECTABLE'', ''PENDING'') ' ||
137: ' AND pro.amount_due_remaining > 0 ' || -- added by jypark 01/02/2003

Line 151: ' FROM iex_promise_details pro, hz_cust_accounts ca ' ||

147: ' AND ca.party_id = :party_id ' ||
148: ' AND del.org_id = :org_id ' ||
149: ' UNION ALL ' ||
150: ' SELECT pro.promise_detail_id, pro.uwq_status, pro.uwq_active_date, pro.uwq_complete_date' ||
151: ' FROM iex_promise_details pro, hz_cust_accounts ca ' ||
152: ' WHERE ca.cust_account_id = pro.cust_account_id ' ||
153: ' AND pro.state = ''BROKEN_PROMISE'' ' ||
154: ' AND pro.status IN (''COLLECTABLE'', ''PENDING'') ' ||
155: ' AND pro.amount_due_remaining > 0 ' || -- added by jypark 01/02/2003

Line 196: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt, hz_cust_accounts acc ' ||

192: --END-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
193: ' AND pro.cust_account_id = :cust_account_id ' ||
194: ' AND pro.delinquency_id is null ' ||
195: ')';
196: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt, hz_cust_accounts acc ' ||
197: ' WHERE bnkrpt.party_id = acc.party_id AND acc.cust_account_id = :cust_account_id';
198: l_bnkrpt_clause := l_bnkrpt_clause || ' and NVL(bnkrpt.DISPOSITION_CODE,''GRANTED'') in (''GRANTED'',''NEGOTIATION'') ';
199: l_object_id := p_cust_account_id;
200: ELSIF p_site_use_id > 0 THEN

Line 230: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt,hz_cust_site_uses site_use, hz_cust_acct_sites acct_site, hz_cust_accounts acc ' ||

226: ' AND pro.contract_id = okch.id ' ||
227: ' AND okch.bill_to_site_use_id = :site_use_id ' ||
228: --END-FIX Bug#4349915-06/06/2005-jypark-include leasing promise
229: ')';
230: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt,hz_cust_site_uses site_use, hz_cust_acct_sites acct_site, hz_cust_accounts acc ' ||
231: ' WHERE bnkrpt.party_id = acc.party_id ' ||
232: ' AND acct_site.cust_account_id = acc.cust_account_id ' ||
233: ' AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id ' ||
234: ' AND site_use.site_use_id = :site_use_id';

Line 339: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt, hz_cust_accounts acc ' ||

335: 'AND str.status_code in (''OPEN'', ''ONHOLD'') ' ||
336: 'AND wtm.status_code in (''OPEN'', ''ONHOLD'') ' ||
337: 'AND str.jtf_object_type = ''IEX_ACCOUNT'' ' ||
338: 'AND str.jtf_object_id = :cust_account_id ';
339: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt, hz_cust_accounts acc ' ||
340: ' WHERE bnkrpt.party_id = acc.party_id AND acc.cust_account_id = :cust_account_id';
341: l_object_id := p_cust_account_id;
342: ELSIF p_site_use_id > 0 THEN
343: l_str_clause := 'SELECT COUNT(1) FROM iex_strategy_work_items wtm, iex_strategies str ' ||

Line 350: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt,hz_cust_site_uses site_use, hz_cust_acct_sites acct_site, hz_cust_accounts acc ' ||

346: 'AND str.status_code in (''OPEN'', ''ONHOLD'') ' ||
347: 'AND wtm.status_code in (''OPEN'', ''ONHOLD'') ' ||
348: 'AND str.jtf_object_type = ''IEX_BILLTO'' ' ||
349: 'AND str.jtf_object_id = :site_use_id ';
350: l_bnkrpt_clause := 'SELECT COUNT(1) FROM iex_bankruptcies bnkrpt,hz_cust_site_uses site_use, hz_cust_acct_sites acct_site, hz_cust_accounts acc ' ||
351: ' WHERE bnkrpt.party_id = acc.party_id ' ||
352: ' AND acct_site.cust_account_id = acc.cust_account_id ' ||
353: ' AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id ' ||
354: ' AND site_use.site_use_id = :site_use_id';

Line 444: ' FROM ar_trx_bal_summary o_summ, hz_cust_accounts acc' ||

440: BEGIN
441: IF p_party_id > 0 THEN
442:
443: l_amt_clause := ' SELECT o_summ.last_payment_amount, o_summ.currency ' ||
444: ' FROM ar_trx_bal_summary o_summ, hz_cust_accounts acc' ||
445: ' WHERE o_summ.cust_account_id = acc.cust_account_id' ||
446: ' AND acc.party_id = :party_id ' ||
447: ' AND last_payment_date = ' || ' (SELECT MAX(last_payment_date) ' ||
448: ' FROM ar_trx_bal_summary ' ||

Line 496: ' FROM ar_trx_bal_summary o_summ, hz_cust_accounts acc' ||

492: BEGIN
493: IF p_party_id > 0 THEN
494:
495: l_no_clause := ' SELECT o_summ.last_payment_number ' ||
496: ' FROM ar_trx_bal_summary o_summ, hz_cust_accounts acc' ||
497: ' WHERE o_summ.cust_account_id = acc.cust_account_id' ||
498: ' AND acc.party_id = :party_id ' ||
499: ' AND last_payment_date = ' || ' (SELECT MAX(last_payment_date) ' ||
500: ' FROM ar_trx_bal_summary ' ||

Line 571: -- FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies del

567: IS
568: CURSOR c_party_amt IS
569: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
570: -- SELECT SUM(amount_due_remaining)
571: -- FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies del
572: -- WHERE pro.cust_account_id = ca.cust_account_id
573: -- AND ca.party_id = p_party_id
574: -- AND pro.status in ('COLLECTABLE', 'PENDING')
575: -- AND pro.state = 'BROKEN_PROMISE'

Line 593: FROM iex_promise_details pro, okc_k_headers_b okch, hz_cust_accounts ca

589: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 barathsr 06-Jan-2009
590: AND del.org_id = p_org_id
591: UNION ALL
592: SELECT amount_due_remaining
593: FROM iex_promise_details pro, okc_k_headers_b okch, hz_cust_accounts ca
594: WHERE ca.cust_account_id = pro.cust_account_id
595: AND ca.party_id = p_party_id
596: AND pro.status in ('COLLECTABLE', 'PENDING')
597: AND pro.state = 'BROKEN_PROMISE'

Line 680: -- FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies del

676: IS
677: CURSOR c_party_amt IS
678: --BEGIN-FIX Bug#4349915-06/06/2005-jypark-include leasing promise and remove current resource dependency
679: -- SELECT SUM(promise_amount)
680: -- FROM iex_promise_details pro, hz_cust_accounts ca, iex_delinquencies del
681: -- WHERE pro.cust_account_id = ca.cust_account_id
682: -- AND ca.party_id = p_party_id
683: -- AND pro.status in ('COLLECTABLE', 'PENDING')
684: -- AND pro.state = 'BROKEN_PROMISE'

Line 704: FROM iex_promise_details pro, okc_k_headers_b okch, hz_cust_accounts ca

700: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 barathsr 06-Jan-2009
701: AND del.org_id = p_org_id
702: UNION ALL
703: SELECT promise_amount
704: FROM iex_promise_details pro, okc_k_headers_b okch, hz_cust_accounts ca
705: WHERE ca.party_id = p_party_id
706: AND pro.cust_account_id = ca.cust_account_id
707: AND pro.status in ('COLLECTABLE', 'PENDING')
708: AND pro.state = 'BROKEN_PROMISE'