DBA Data[Home] [Help]

APPS.FII_AR_COLLECTORS_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 223: hz_cust_acct_sites_all sites,

219: FII_USER_ID,
220: FII_LOGIN_ID
221: FROM hz_customer_profiles prof,
222: hz_cust_accounts acct,
223: hz_cust_acct_sites_all sites,
224: hz_cust_site_uses_all uses
225: WHERE prof.site_use_id IS NULL
226: AND acct.cust_account_id = prof.cust_account_id
227: AND acct.cust_account_id = sites.cust_account_id

Line 507: hz_cust_acct_sites_all sites,

503: '||FII_LOGIN_ID||' last_update_login
504:
505: FROM hz_customer_profiles prof,
506: hz_cust_accounts acct,
507: hz_cust_acct_sites_all sites,
508: hz_cust_site_uses_all uses
509:
510: WHERE prof.site_use_id IS NULL
511: AND acct.cust_account_id = prof.cust_account_id