DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on HZ_CUSTOMER_PROFILES

Line 3794: hz_customer_profiles cp1,

3790: FROM ra_terms t_su,
3791: ra_terms t_cp1,
3792: ra_terms t_cp2,
3793: ra_terms tl, /*Bug 3984916*/
3794: hz_customer_profiles cp1,
3795: hz_customer_profiles cp2,
3796: hz_cust_site_uses su
3797: WHERE gt.bill_to_customer_id = cp1.cust_account_id(+)
3798: AND su.site_use_id = gt.bill_to_site_use_id

Line 3795: hz_customer_profiles cp2,

3791: ra_terms t_cp1,
3792: ra_terms t_cp2,
3793: ra_terms tl, /*Bug 3984916*/
3794: hz_customer_profiles cp1,
3795: hz_customer_profiles cp2,
3796: hz_cust_site_uses su
3797: WHERE gt.bill_to_customer_id = cp1.cust_account_id(+)
3798: AND su.site_use_id = gt.bill_to_site_use_id
3799: AND cp2.cust_account_id = gt.bill_to_customer_id