VIEW: APPS.XNB_SHIP_TO_CONTACT_NAME_V

Source

View Text - Preformatted

SELECT A.CUST_ACCOUNT_ROLE_ID CUST_ACCOUNT_ROLE_ID, C.PERSON_IDENTIFIER PERSON_IDENTIFIER, C.PERSON_TITLE PERSON_TITLE, C.PERSON_PRE_NAME_ADJUNCT PERSON_PRE_NAME_ADJUNCT, C.PERSON_FIRST_NAME PERSON_FIRST_NAME, C.PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME, C.PERSON_LAST_NAME PERSON_LAST_NAME, C.PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX, C.SALUTATION SALUTATION FROM HZ_CUST_ACCOUNT_ROLES A, HZ_RELATIONSHIPS B, HZ_PARTIES C WHERE A.PARTY_ID = B.PARTY_ID AND B.DIRECTIONAL_FLAG = 'F' AND B.SUBJECT_ID = C.PARTY_ID AND A.STATUS = 'A' AND B.STATUS = 'A' AND C.STATUS = 'A'

View Text - HTML Formatted

SELECT A.CUST_ACCOUNT_ROLE_ID CUST_ACCOUNT_ROLE_ID
, C.PERSON_IDENTIFIER PERSON_IDENTIFIER
, C.PERSON_TITLE PERSON_TITLE
, C.PERSON_PRE_NAME_ADJUNCT PERSON_PRE_NAME_ADJUNCT
, C.PERSON_FIRST_NAME PERSON_FIRST_NAME
, C.PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME
, C.PERSON_LAST_NAME PERSON_LAST_NAME
, C.PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX
, C.SALUTATION SALUTATION
FROM HZ_CUST_ACCOUNT_ROLES A
, HZ_RELATIONSHIPS B
, HZ_PARTIES C
WHERE A.PARTY_ID = B.PARTY_ID
AND B.DIRECTIONAL_FLAG = 'F'
AND B.SUBJECT_ID = C.PARTY_ID
AND A.STATUS = 'A'
AND B.STATUS = 'A'
AND C.STATUS = 'A'