DBA Data[Home] [Help]

APPS.IEX_AGING_BUCKETS_PKG dependencies on HZ_CUST_SITE_USES

Line 1240: hz_cust_site_uses hzsu,

1236: -app.acctd_amount_applied_from,
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

Line 1439: hz_cust_site_uses_all site_uses,

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
1443: /* bug no : 1274152. Aging form did not consider the receipts done