DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 7572: hz_cust_accounts cust,

7568: INTO l_address_id,
7569: l_contributor_class,
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)

Line 7890: hz_cust_accounts cust,

7886: INTO l_address_id,
7887: l_class_code,
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)