APPS.IEX_AGING_BUCKETS_PKG dependencies on HZ_CUST_ACCT_SITES

Line 1241: hz_cust_acct_sites hzas

1237: -app.amount_applied),0), 0) ), 0)
1238: FROM ar_receivable_applications app,
1239: ar_payment_schedules ps,
1240: hz_cust_site_uses hzsu,
1241: hz_cust_acct_sites hzas
1242: WHERE ps.customer_id = hzas.cust_account_id
1243: and hzsu.cust_acct_site_id = hzas.cust_acct_site_id
1244: AND hzsu.site_use_id = ps.customer_site_use_id
1245: AND ps.cash_receipt_id = app.cash_receipt_id

Line 1438: hz_cust_acct_sites_all acct_site,

1434: crh.amount)), 0)
1435: FROM ar_cash_receipts cr,
1436: ar_cash_receipt_history crh,
1437: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1438: hz_cust_acct_sites_all acct_site,
1439: hz_cust_site_uses_all site_uses,
1440: hz_cust_accounts_all cust_acct
1441: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1442: WHERE cr.customer_site_use_id = p_filter_id