DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 7573: hz_cust_acct_sites_all add1,

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)
7577: AND cust.cust_account_id = add1.cust_account_id

Line 7891: hz_cust_acct_sites_all add1,

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)
7895: AND cust.cust_account_id = add1.cust_account_id