Oracle APPS Customer Tables

SELECT * FROM HZ_PARTIES

WHERE PARTY_NAME = '';





---For Customer Accounts:


SELECT * FROM HZ_CUST_ACCOUNTS hca

WHERE hca.ACCOUNT_NAME = '' ;




--Account Number:

--Account Id:

--Customer Accounts Sites:



SELECT * FROM HZ_CUST_ACCT_SITES_ALL hcsa

WHERE hcsa.CUST_ACCOUNT_ID = '' ;




--Customer Account Site Id: 10554 - TESTCUSTS_1_2

--10558 - TESTCUSTS_1_1



SELECT * FROM HZ_CUST_SITE_USES_ALL ;

SELECT * FROM HZ_PARTY_SITES

WHERE PARTY_ID = '' -- Check Party Site Name




--There are two Id need to get, one is subject id and other is object id

--1.Subject Id is related to Organization that is customer Party id here the party id is



SELECT * FROM HZ_PARTIES

WHERE PARTY_NAME LIKE 'TESTCUST_1'



　

　
SELECT * FROM HZ_RELATIONSHIPS hr

WHERE hr.SUBJECT_ID = 'Person Party id'

and hr.OBJECT_ID = 'Org Party_id'



　

　

SELECT * FROM HZ_ORG_CONTACTS hoc

WHERE hoc.PARTY_RELATIONSHIP_ID = '' -- Relatioship Id




  SELECT * FROM HZ_CONTACT_POINTS hp --HZ_CUST_CONTACT_POINTS hcp

WHERE hp.OWNER_TABLE_ID = '' ; --Party Site Id of the Contact



　

SELECT * FROM HZ_CUST_ACCOUNT_ROLES hcr

WHERE hcr.CUST_ACCT_SITE_ID ='' ;