Customer Interface

All you need about Customer interface in Oracle apps 11i.
-------------------------------------------------------------------------------------------------------------

Interface Tables:    

1.       RA_CUSTOMERS_INTERFACE

2.      RA_CUSTOMER_PROFILES_INTERFACE

3.      RA_CONTACT_PHONES_INTERFACE

4.      RA_CUST_PAY_METHOD_INTERFACE

5.      RA_CUSTOMER_BANKS_INTERFACE

Customer (TCA) APIs:

1.      hz_party_v2pub. CREATE_PERSON

2.      hz_party_v2pub.UPDATE_PERSON

3.      hz_party_v2pub.CREATE_ORGANIZATION

4.      hz_party_v2pub.UPDATE_ORGANIZATION

5.      hz_customer_profile_v2pub.CREATE_CUSTOMER_PROFILE

6.      hz_customer_profile_v2pub.UPDATE_CUSTOMER_PROFILE

7.      hz_cust_account_v2pub.CREATE_CUST_ACCOUNT

8.      hz_cust_account_v2pub.CREATE_CUST_ACCT_RELATE

9.      hz_party_site_v2pub.CREATE_PARTY_SITE

10.   hz_party_site_v2pub.UPDATE_PARTY_SITE

11.   hz_cust_account_site_v2pub.CREATE_CUST_ACCT_SITE

12.   hz_party_contact_v2pub.CREATE_ORG_CONTACT

Base Tables:

1.      RA_CUSTOMERS (view)

a.      HZ_PARTIES

b.      HZ_CUST_ACCOUNTS

2.      RA_ADDRESSES (view)

a.      HZ_PARTY_SITES

b.      HZ_LOCATIONS

c.       HZ_CUST_ACCT_SITES_ALL

3.      RA_SITE_USES(view)

a.      HZ_CUST_SITE_USES_ALL

4.      RA_CUSTOMER_RELATIONSHIPS(view)

a.      RA_CUSTOMER_RELATIONSHIPS_ALL(view)

                                                                                                  i.      HZ_CUST_ACCT_RELATE_ALL

5.      AR_CUSTOMER_PROFILES(view)

a.      HZ_CUSTOMER_PROFILES

6.      AR_CUSTOMER_PROFILE_AMOUNTS(view)

a.      HZ_CUST_PROFILE_AMTS

7.      RA_CONTACTS(view)

a.      HZ_CUST_ACCOUNT_ROLES

b.      HZ_ORG_CONTACTS

c.       HZ_RELATIONSHIPS

d.      HZ_PARTIES

8.      RA_PHONES(view)

a.      HZ_CONTACT_POINTS

9.      RA_CUST_RECEIPT_METHODS