VIEW: APPS.OE_CONTACTS_V

Source

View Text - Preformatted

SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID , ACCT_ROLE.CUST_ACCT_SITE_ID ORG_ID , ACCT_ROLE.CUST_ACCOUNT_ID , PARTY.PERSON_LAST_NAME || DECODE(PARTY.PERSON_FIRST_NAME, NULL, NULL, ', '|| PARTY.PERSON_FIRST_NAME) || DECODE(ARL.MEANING, NULL, NULL, ' '||ARL.MEANING) NAME , ORG_CONT.JOB_TITLE , ACCT_ROLE.STATUS , REL_PARTY.EMAIL_ADDRESS FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS ACCT, HZ_RELATIONSHIPS REL, HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY , AR_LOOKUPS ARL WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID AND ACCT_ROLE.ROLE_TYPE = 'CONTACT' AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.SUBJECT_ID = PARTY.PARTY_ID AND REL.PARTY_ID = REL_PARTY.PARTY_ID AND ARL.lookup_type(+) = 'CONTACT_TITLE' AND ARL.lookup_code(+) = PARTY.person_pre_name_adjunct AND REL.OBJECT_ID = ACCT.PARTY_ID AND ACCT.CUST_ACCOUNT_ID = ACCT_ROLE.CUST_ACCOUNT_ID

View Text - HTML Formatted

SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
, ACCT_ROLE.CUST_ACCT_SITE_ID ORG_ID
, ACCT_ROLE.CUST_ACCOUNT_ID
, PARTY.PERSON_LAST_NAME || DECODE(PARTY.PERSON_FIRST_NAME
, NULL
, NULL
, '
, '|| PARTY.PERSON_FIRST_NAME) || DECODE(ARL.MEANING
, NULL
, NULL
, ' '||ARL.MEANING) NAME
, ORG_CONT.JOB_TITLE
, ACCT_ROLE.STATUS
, REL_PARTY.EMAIL_ADDRESS
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS ACCT
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_PARTIES REL_PARTY
, AR_LOOKUPS ARL
WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND REL.PARTY_ID = REL_PARTY.PARTY_ID
AND ARL.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND ARL.LOOKUP_CODE(+) = PARTY.PERSON_PRE_NAME_ADJUNCT
AND REL.OBJECT_ID = ACCT.PARTY_ID
AND ACCT.CUST_ACCOUNT_ID = ACCT_ROLE.CUST_ACCOUNT_ID