DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 7574: hz_cust_site_uses_all site

7570: l_use_site_prof
7571: FROM ra_customer_trx_all trx,
7572: hz_cust_accounts cust,
7573: hz_cust_acct_sites_all add1,
7574: hz_cust_site_uses_all site
7575: WHERE trx.customer_trx_id = p_trx_id_tbl(i)
7576: AND cust.cust_account_id = nvl(trx.ship_to_customer_id,trx.bill_to_customer_id)
7577: AND cust.cust_account_id = add1.cust_account_id
7578: AND site.cust_acct_site_id = add1.cust_acct_site_id

Line 7892: hz_cust_site_uses_all site

7888: l_use_site_prof
7889: FROM ra_customer_trx_all trx,
7890: hz_cust_accounts cust,
7891: hz_cust_acct_sites_all add1,
7892: hz_cust_site_uses_all site
7893: WHERE trx.customer_trx_id = p_trx_id_tbl(i)
7894: AND cust.cust_account_id = NVL(trx.ship_to_customer_id,trx.bill_to_customer_id)
7895: AND cust.cust_account_id = add1.cust_account_id
7896: AND site.cust_acct_site_id = add1.cust_acct_site_id