View: AR_CUSTOMERS_ASSIGNED_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_CUSTOMERS_ASSIGNED_V

View Text

SELECT DISTINCT PARTY.PARTY_ID
, ACCTS.CUST_ACCOUNT_ID
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS ACCTS
WHERE PARTY.PARTY_ID = ACCTS.PARTY_ID
AND ACCTS.STATUS = 'A'
AND PARTY.PARTY_TYPE = 'PERSON'
AND PARTY.STATUS = 'A' UNION SELECT DISTINCT REL.SUBJECT_ID AS PARTY_ID
, ROLE.CUST_ACCOUNT_ID
FROM HZ_CUST_ACCOUNT_ROLES ROLE
, HZ_ROLE_RESPONSIBILITY RESP
, HZ_RELATIONSHIPS REL
WHERE ROLE.CURRENT_ROLE_STATE = 'A'
AND ROLE.ROLE_TYPE = 'CONTACT'
AND ROLE.CUST_ACCT_SITE_ID IS NULL
AND (ROLE.END_DATE IS NULL OR ROLE.END_DATE > SYSDATE)
AND RESP.CUST_ACCOUNT_ROLE_ID = ROLE.CUST_ACCOUNT_ROLE_ID
AND RESP.RESPONSIBILITY_TYPE = 'SELF_SERVICE_USER'
AND REL.PARTY_ID = ROLE.PARTY_ID
AND REL.SUBJECT_TYPE = 'PERSON'
AND (REL.END_DATE IS NULL OR REL.END_DATE > SYSDATE)
AND REL.STATUS = 'A'
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Columns