APPS.ARP_CONSINV dependencies on HZ_CUST_SITE_USES

Line 529: hz_cust_site_uses site_uses,

525: FROM
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)

Line 705: hz_cust_site_uses site_uses,

701: SELECT /*+ ORDERED */
702: P_customer_id customer_id ,
703: P_bill_to_site site_id
704: FROM
705: hz_cust_site_uses site_uses,
706: hz_customer_profiles CP,
707: hz_customer_profiles SP
708: WHERE
709: site_uses.site_use_id = P_bill_to_site

Line 741: hz_cust_site_uses site_uses,

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
745: acct_site.cust_account_id = P_customer_id

Line 781: hz_cust_site_uses site_uses,

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
785: site_uses.cust_acct_site_id = acct_site.cust_acct_site_id