[Home] [Help]
View: OE_PRINT_CUST_CONTACT_V
Product: | ONT - Order Management |
Description: | This view is used to print the Customer Contact information. |
Implementation/DBA Data: |
APPS.OE_PRINT_CUST_CONTACT_V
|
View Text
SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID CONTACT_ID
, ACCT_ROLE.CUST_ACCT_SITE_ID ORG_ID
, ACCT_ROLE.CUST_ACCOUNT_ID CUSTOMER_ID
, PARTY.PERSON_LAST_NAME
, PARTY.PERSON_FIRST_NAME
, ARL.MEANING TITLE
, ORG_CONT.JOB_TITLE
, ACCT_ROLE.STATUS
, REL_PARTY.EMAIL_ADDRESS
, REL_PARTY.PARTY_ID PARTY_ID
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, 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.DIRECTIONAL_FLAG = 'F'
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 ORDER BY PERSON_LAST_NAME
Columns
Name |
CONTACT_ID |
ORG_ID |
CUSTOMER_ID |
PERSON_LAST_NAME |
PERSON_FIRST_NAME |
TITLE |
JOB_TITLE |
STATUS |
EMAIL_ADDRESS |
PARTY_ID |