VIEW: APPS.AR_SITES_ASSIGNED_V

Source

View Text - Preformatted

SELECT Rel.subject_id AS party_id, Role.cust_account_id, Role.cust_acct_site_id FROM hz_cust_account_roles Role, hz_role_responsibility Resp, hz_relationships Rel, hz_cust_acct_sites Sites WHERE Role.status = 'A' AND Role.role_type = 'CONTACT' AND Role.cust_acct_site_id IS NOT 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.end_date is null OR Rel.end_date > sysdate) AND Rel.status = 'A' AND Rel.subject_type = 'PERSON' AND Rel.subject_table_name = 'HZ_PARTIES' AND Sites.cust_acct_site_id = Role.cust_acct_site_id

View Text - HTML Formatted

SELECT REL.SUBJECT_ID AS PARTY_ID
, ROLE.CUST_ACCOUNT_ID
, ROLE.CUST_ACCT_SITE_ID
FROM HZ_CUST_ACCOUNT_ROLES ROLE
, HZ_ROLE_RESPONSIBILITY RESP
, HZ_RELATIONSHIPS REL
, HZ_CUST_ACCT_SITES SITES
WHERE ROLE.STATUS = 'A'
AND ROLE.ROLE_TYPE = 'CONTACT'
AND ROLE.CUST_ACCT_SITE_ID IS NOT 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.END_DATE IS NULL OR REL.END_DATE > SYSDATE)
AND REL.STATUS = 'A'
AND REL.SUBJECT_TYPE = 'PERSON'
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND SITES.CUST_ACCT_SITE_ID = ROLE.CUST_ACCT_SITE_ID