DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 8048: hz_cust_site_uses_all site

8044: l_use_site_prof
8045: FROM ra_customer_trx_all trx,
8046: hz_cust_accounts cust,
8047: hz_cust_acct_sites_all add1,
8048: hz_cust_site_uses_all site
8049: WHERE trx.customer_trx_id = p_trx_id_tbl(i)
8050: AND cust.cust_account_id = nvl(trx.ship_to_customer_id,trx.bill_to_customer_id)
8051: AND cust.cust_account_id = add1.cust_account_id
8052: AND site.cust_acct_site_id = add1.cust_acct_site_id

Line 8368: hz_cust_site_uses_all site

8364: l_use_site_prof
8365: FROM ra_customer_trx_all trx,
8366: hz_cust_accounts cust,
8367: hz_cust_acct_sites_all add1,
8368: hz_cust_site_uses_all site
8369: WHERE trx.customer_trx_id = p_trx_id_tbl(i)
8370: AND cust.cust_account_id = NVL(trx.ship_to_customer_id,trx.bill_to_customer_id)
8371: AND cust.cust_account_id = add1.cust_account_id
8372: AND site.cust_acct_site_id = add1.cust_acct_site_id