VIEW: APPS.AR_CONTACTS_ACTIVE_V

Source

View Text - Preformatted

SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID CONTACT_ID , PARTY.PARTY_NAME CONTACT_NAME , ORG_CONT.JOB_TITLE JOB_TITLE , ACCT_ROLE.CUST_ACCOUNT_ID CUSTOMER_ID , ACCT_ROLE.CUST_ACCT_SITE_ID ADDRESS_ID FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL, HZ_ORG_CONTACTS ORG_CONT WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.DIRECTIONAL_FLAG = 'F' AND ACCT_ROLE.ROLE_TYPE = 'CONTACT' AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID AND REL.SUBJECT_ID = PARTY.PARTY_ID AND ACCT_ROLE.STATUS = 'A'

View Text - HTML Formatted

SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID CONTACT_ID
, PARTY.PARTY_NAME CONTACT_NAME
, ORG_CONT.JOB_TITLE JOB_TITLE
, ACCT_ROLE.CUST_ACCOUNT_ID CUSTOMER_ID
, ACCT_ROLE.CUST_ACCT_SITE_ID ADDRESS_ID
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.DIRECTIONAL_FLAG = 'F'
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND ACCT_ROLE.STATUS = 'A'