DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 8047: hz_cust_acct_sites_all add1,

8043: l_contributor_class,
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

Line 8367: hz_cust_acct_sites_all add1,

8363: l_class_code,
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