DBA Data[Home] [Help]

APPS.AR_AI_INTEG_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 127: hz_customer_profiles cp1,

123: FROM ra_terms t_su,
124: ra_terms t_cp1,
125: ra_terms t_cp2,
126: ra_terms tl,
127: hz_customer_profiles cp1,
128: hz_customer_profiles cp2,
129: hz_cust_site_uses_all su
130: WHERE p_bill_to_customer_account_id = cp1.cust_account_id(+)
131: AND cp2.cust_account_id = p_bill_to_customer_account_id

Line 128: hz_customer_profiles cp2,

124: ra_terms t_cp1,
125: ra_terms t_cp2,
126: ra_terms tl,
127: hz_customer_profiles cp1,
128: hz_customer_profiles cp2,
129: hz_cust_site_uses_all su
130: WHERE p_bill_to_customer_account_id = cp1.cust_account_id(+)
131: AND cp2.cust_account_id = p_bill_to_customer_account_id
132: AND su.site_use_id = cp1.site_use_id(+)