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

Line 18: FROM HZ_CUST_ACCOUNTS

14: -- Cursor to select all cust_account_ids in case user passes party_id
15: CURSOR AR_AGING_PARTY_CUR(p_party Number)
16: IS
17: SELECT cust_account_id
18: FROM HZ_CUST_ACCOUNTS
19: WHERE party_id = p_party ;
20:
21: -- Cursor to select all cust_account_ids in case user passes party_id for paying relationship
22: CURSOR AR_AGING_PAYING_PARTY_CUR(p_party Number)

Line 25: FROM HZ_CUST_ACCOUNTS

21: -- Cursor to select all cust_account_ids in case user passes party_id for paying relationship
22: CURSOR AR_AGING_PAYING_PARTY_CUR(p_party Number)
23: IS
24: SELECT cust_account_id
25: FROM HZ_CUST_ACCOUNTS
26: WHERE party_id IN
27: (SELECT p_party FROM dual
28: UNION
29: SELECT ar.related_party_id

Line 894: hz_cust_accounts hzca

890: ps.acctd_amount_due_remaining,
891: ps.amount_due_remaining)), 0)
892: FROM ar_payment_schedules ps,
893: ra_cust_trx_line_gl_dist gld,
894: hz_cust_accounts hzca
895: WHERE ps.customer_id = hzca.cust_account_id
896: AND hzca.party_id = p_filter_id
897: AND decode(p_customer_site_use_id,
898: NULL, ps.customer_site_use_id,

Line 916: hz_cust_accounts hzca

912: ps.acctd_amount_due_remaining,
913: ps.amount_due_remaining)), 0)
914: FROM ar_payment_schedules ps,
915: ra_cust_trx_line_gl_dist gld,
916: hz_cust_accounts hzca
917: WHERE ps.customer_id = hzca.cust_account_id
918: AND hzca.party_id IN
919: (SELECT p_filter_id FROM dual
920: UNION

Line 1067: hz_cust_accounts hzca

1063: -app.acctd_amount_applied_from,
1064: -app.amount_applied),0), 0) ), 0)
1065: FROM ar_receivable_applications app,
1066: ar_payment_schedules ps,
1067: hz_cust_accounts hzca
1068: WHERE ps.customer_id = hzca.cust_account_id
1069: AND hzca.party_id = p_filter_id
1070: AND decode(p_customer_site_use_id,
1071: NULL, nvl(ps.customer_site_use_id,-10),

Line 1103: hz_cust_accounts hzca

1099: -app.acctd_amount_applied_from,
1100: -app.amount_applied),0), 0) ), 0)
1101: FROM ar_receivable_applications app,
1102: ar_payment_schedules ps,
1103: hz_cust_accounts hzca
1104: WHERE ps.customer_id = hzca.cust_account_id
1105: AND hzca.party_id IN
1106: (SELECT p_filter_id FROM dual
1107: UNION

Line 1347: hz_cust_accounts hzca

1343: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1344: crh.amount)), 0)
1345: FROM ar_cash_receipts cr,
1346: ar_cash_receipt_history crh,
1347: hz_cust_accounts hzca
1348: WHERE cr.pay_from_customer = hzca.cust_account_id
1349: AND hzca.party_id = p_filter_id
1350: /* bug no : 1274152. Aging form did not consider the receipts done
1351: without customer location for the calculation of receipt at risk.

Line 1378: hz_cust_accounts hzca

1374: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1375: crh.amount)), 0)
1376: FROM ar_cash_receipts cr,
1377: ar_cash_receipt_history crh,
1378: hz_cust_accounts hzca
1379: WHERE cr.pay_from_customer = hzca.cust_account_id
1380: AND hzca.party_id IN
1381: (SELECT p_filter_id FROM dual
1382: UNION

Line 1420: hz_cust_accounts_all cust_acct

1416: ar_cash_receipt_history crh,
1417: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1418: hz_cust_acct_sites_all acct_site,
1419: hz_cust_site_uses_all site_uses,
1420: hz_cust_accounts_all cust_acct
1421: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1422: WHERE cr.customer_site_use_id = p_filter_id
1423: /* bug no : 1274152. Aging form did not consider the receipts done
1424: without customer location for the calculation of receipt at risk.

Line 1593: hz_cust_accounts hzca

1589: SELECT NVL(SUM(decode(p_currency_code, NULL,
1590: ROUND(ps.amount_in_dispute * nvl(ps.exchange_rate,1),l_round_decimal),
1591: ps.amount_in_dispute)),0)
1592: FROM ar_payment_schedules ps,
1593: hz_cust_accounts hzca
1594: WHERE ps.customer_id = hzca.cust_Account_id
1595: AND hzca.party_id = p_filter_id
1596: AND decode(p_customer_site_use_id,
1597: NULL, ps.customer_site_use_id,

Line 1613: hz_cust_accounts hzca

1609: SELECT NVL(SUM(decode(p_currency_code, NULL,
1610: ROUND(ps.amount_in_dispute * nvl(ps.exchange_rate,1),l_round_decimal),
1611: ps.amount_in_dispute)),0)
1612: FROM ar_payment_schedules ps,
1613: hz_cust_accounts hzca
1614: WHERE ps.customer_id = hzca.cust_Account_id
1615: AND hzca.party_id IN
1616: (SELECT p_filter_id FROM dual
1617: UNION

Line 1767: hz_cust_accounts hzca

1763: NVL(ps.exchange_rate, 1)),0), l_round_decimal),
1764: ROUND(NVL(SUM(ps.amount_adjusted_pending *
1765: NVL(ps.exchange_rate, 1)),0), l_round_decimal)
1766: FROM ar_payment_schedules ps,
1767: hz_cust_accounts hzca
1768: WHERE ps.customer_id = hzca.cust_account_id
1769: AND hzca.party_id = p_filter_id
1770: AND decode(p_customer_site_use_id,
1771: NULL, ps.customer_site_use_id,

Line 1790: hz_cust_accounts hzca

1786: NVL(ps.exchange_rate, 1)),0), l_round_decimal),
1787: ROUND(NVL(SUM(ps.amount_adjusted_pending *
1788: NVL(ps.exchange_rate, 1)),0), l_round_decimal)
1789: FROM ar_payment_schedules ps,
1790: hz_cust_accounts hzca
1791: WHERE ps.customer_id = hzca.cust_account_id
1792: AND hzca.party_id IN
1793: (SELECT p_filter_id FROM dual
1794: UNION

Line 1860: hz_cust_accounts hzca

1856: SELECT
1857: ROUND(NVL(SUM( ps.receivables_charges_charged
1858: * NVL(ps.exchange_rate,1)),0),l_round_decimal)
1859: FROM ar_payment_schedules ps,
1860: hz_cust_accounts hzca
1861: WHERE ps.customer_id = hzca.cust_account_id
1862: --- Begin - Andre Araujo - 11/09/2004 - Performance fix
1863: AND ps.status = 'OP'
1864: --- End - Andre Araujo - 11/09/2004 - Performance fix

Line 1880: hz_cust_accounts hzca

1876: SELECT
1877: ROUND(NVL(SUM( ps.receivables_charges_charged
1878: * NVL(ps.exchange_rate,1)),0),l_round_decimal)
1879: FROM ar_payment_schedules ps,
1880: hz_cust_accounts hzca
1881: WHERE ps.customer_id = hzca.cust_account_id
1882: AND hzca.party_id IN
1883: (SELECT p_filter_id FROM dual
1884: UNION

Line 2936: hz_cust_accounts hzca

2932: l_collectible_bkt_amt_tbl
2933: from ar_aging_bucket_lines aabl,
2934: ar_payment_schedules aps,
2935: iex_delinquencies id,
2936: hz_cust_accounts hzca
2937: where id.payment_schedule_id = aps.payment_schedule_id
2938: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
2939: -- and id.status IN ('DELINQUENT', 'PRE-DELINQUENT')
2940: and id.status IN ('DELINQUENT', 'PREDELINQUENT')

Line 2972: hz_cust_accounts hzca

2968: (SELECT DISTINCT id.transaction_id
2969: FROM ar_aging_bucket_lines aabl,
2970: ar_payment_schedules aps,
2971: iex_delinquencies id,
2972: hz_cust_accounts hzca
2973: WHERE id.payment_schedule_id = aps.payment_schedule_id
2974: AND id.status IN('DELINQUENT', 'PREDELINQUENT')
2975: AND TRUNC(sysdate) -aps.due_date >= aabl.days_start
2976: AND TRUNC(sysdate) -aps.due_date <= aabl.days_to

Line 3005: hz_cust_accounts hzca

3001: l_collectible_bkt_amt_tbl
3002: from ar_aging_bucket_lines aabl,
3003: ar_payment_schedules aps,
3004: iex_delinquencies id,
3005: hz_cust_accounts hzca
3006: where id.payment_schedule_id = aps.payment_schedule_id
3007: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
3008: -- and id.status IN ('DELINQUENT', 'PRE-DELINQUENT')
3009: and id.status IN ('DELINQUENT', 'PREDELINQUENT')

Line 3033: hz_cust_accounts hzca

3029: (SELECT DISTINCT id.transaction_id
3030: FROM ar_aging_bucket_lines aabl,
3031: ar_payment_schedules aps,
3032: iex_delinquencies id,
3033: hz_cust_accounts hzca
3034: WHERE id.payment_schedule_id = aps.payment_schedule_id
3035: AND id.status IN('DELINQUENT', 'PREDELINQUENT')
3036: AND TRUNC(sysdate) -aps.due_date >= aabl.days_start
3037: AND TRUNC(sysdate) -aps.due_date <= aabl.days_to

Line 3379: hz_cust_accounts hzca

3375: v_paying_party_tran_sql :=
3376: 'SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0)
3377: FROM ar_payment_schedules arp,
3378: ar_aging_bucket_lines aabl,
3379: hz_cust_accounts hzca
3380: WHERE trunc(sysdate)-trunc(arp.due_date) >= aabl.days_start
3381: and trunc(sysdate)-trunc(arp.due_date) <= aabl.days_to
3382: and arp.class = :class
3383: and arp.status = ''OP''

Line 3401: -- hz_cust_accounts hzca

3397: v_party_tran_sql :=
3398: -- 'SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0)
3399: -- FROM ar_payment_schedules arp,
3400: -- ar_aging_bucket_lines aabl,
3401: -- hz_cust_accounts hzca
3402: -- WHERE sysdate-arp.due_date >= aabl.days_start
3403: -- and sysdate-arp.due_date <= aabl.days_to
3404: -- and arp.class = :class
3405: -- and arp.status = ''OP''

Line 3412: WHERE (arp.customer_id in (select cust_account_id from hz_cust_accounts where party_id = :party_id)

3408: -- and hzca.party_id = :party_id ' ;
3409: --Bug5170294. Fix by LKKUMAR. Use Trunc on Dates. Start.
3410: 'SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0)
3411: FROM ar_payment_schedules arp
3412: WHERE (arp.customer_id in (select cust_account_id from hz_cust_accounts where party_id = :party_id)
3413: and arp.status = ''OP'')
3414: and
3415: (
3416: trunc(sysdate)-trunc(arp.due_date) >= :days_start

Line 3429: -- hz_cust_accounts hzca

3425: v_party_billto_tran_sql :=
3426: -- 'SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0)
3427: -- FROM ar_payment_schedules arp,
3428: -- ar_aging_bucket_lines aabl,
3429: -- hz_cust_accounts hzca
3430: -- WHERE sysdate-arp.due_date >= aabl.days_start
3431: -- and sysdate-arp.due_date <= aabl.days_to
3432: -- and arp.class = :class
3433: -- and arp.status = ''OP''

Line 3581: HZ_CUST_ACCOUNTS hzca

3577: ra_customer_trx rct,
3578: okl_cnsld_ar_strms_b ocasb,
3579: OKL_CNSLD_AR_LINES_B ocalb,
3580: OKL_CNSLD_AR_HDRS_B ocahb,
3581: HZ_CUST_ACCOUNTS hzca
3582: WHERE (:l_date - arp.due_date) >= aabl.days_start
3583: and (:l_date - arp.due_date) <= aabl.days_to
3584: and arp.class = :l_class
3585: and rct.customer_trx_id = arp.customer_trx_id

Line 3613: HZ_CUST_ACCOUNTS hzca

3609: ra_customer_trx rct,
3610: okl_cnsld_ar_strms_b ocasb,
3611: OKL_CNSLD_AR_LINES_B ocalb,
3612: OKL_CNSLD_AR_HDRS_B ocahb,
3613: HZ_CUST_ACCOUNTS hzca
3614: WHERE (:l_date - arp.due_date) >= aabl.days_start
3615: and (:l_date - arp.due_date) <= aabl.days_to
3616: and arp.class = :l_class
3617: and rct.customer_trx_id = arp.customer_trx_id

Line 3645: HZ_CUST_ACCOUNTS hzca

3641: ra_customer_trx rct,
3642: okl_cnsld_ar_strms_b ocasb,
3643: OKL_CNSLD_AR_LINES_B ocalb,
3644: OKL_CNSLD_AR_HDRS_B ocahb,
3645: HZ_CUST_ACCOUNTS hzca
3646: WHERE (:l_date - arp.due_date) >= aabl.days_start
3647: and (:l_date - arp.due_date) <= aabl.days_to
3648: and arp.class = :l_class
3649: and rct.customer_trx_id = arp.customer_trx_id