APPS.ARP_CONSINV dependencies on HZ_CUST_ACCT_SITES

Line 530: hz_cust_acct_sites acct_site

526: hz_cust_accounts cust_acct,
527: hz_customer_profiles CP,
528: hz_customer_profiles SP,
529: hz_cust_site_uses site_uses,
530: hz_cust_acct_sites acct_site
531: WHERE
532: site_uses.site_use_code = 'BILL_TO'
533: AND site_uses.site_use_id = nvl(C_site_use_id, site_uses.site_use_id)
534: AND SP.site_use_id(+) = site_uses.site_use_id

Line 740: hz_cust_acct_sites acct_site,

736: SELECT /*+ ORDERED */
737: P_customer_id customer_id ,
738: site_uses.site_use_id site_id
739: FROM
740: hz_cust_acct_sites acct_site,
741: hz_cust_site_uses site_uses,
742: hz_customer_profiles CP,
743: hz_customer_profiles SP
744: WHERE

Line 780: hz_cust_acct_sites acct_site,

776: SELECT
777: acct_site.cust_account_id customer_id ,
778: site_uses.site_use_id site_id
779: FROM
780: hz_cust_acct_sites acct_site,
781: hz_cust_site_uses site_uses,
782: hz_customer_profiles CP,
783: hz_customer_profiles SP
784: WHERE