APPS.ARP_CONSINV dependencies on HZ_CUSTOMER_PROFILES

Line 527: hz_customer_profiles CP,

523: nvl(SP.cons_inv_type,
524: nvl(CP.cons_inv_type,'SUMMARY')) cons_inv_type
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

Line 528: hz_customer_profiles SP,

524: nvl(CP.cons_inv_type,'SUMMARY')) cons_inv_type
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'

Line 604: C_detail_option hz_customer_profiles.cons_inv_type%TYPE;

600: L_sites L_sites_type ;
601:
602: -- bug2892106 Removed cons_inv_type column from select stmt because
603: -- it must be same value with P_detal_option.
604: C_detail_option hz_customer_profiles.cons_inv_type%TYPE;
605:
606: -- bug3039537
607: -- Calculate all tax amount and inclusive tax amount
608: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;

Line 706: hz_customer_profiles CP,

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
710: AND CP.cust_account_id = P_customer_id

Line 707: hz_customer_profiles SP

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
710: AND CP.cust_account_id = P_customer_id
711: AND CP.site_use_id IS NULL

Line 742: hz_customer_profiles CP,

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

Line 743: hz_customer_profiles SP

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
746: AND site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
747: AND site_uses.site_use_code = 'BILL_TO'

Line 782: hz_customer_profiles CP,

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
786: AND site_uses.site_use_code = 'BILL_TO'

Line 783: hz_customer_profiles SP

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
786: AND site_uses.site_use_code = 'BILL_TO'
787: AND CP.cust_account_id = acct_site.cust_account_id