VIEW: APPS.XNB_SHIP_TO_CONTACT_INFO_V

Source

View Text - Preformatted

SELECT A.CUST_ACCOUNT_ROLE_ID CUST_ACCOUNT_ROLE_ID, D.CONTACT_POINT_TYPE CONTACT_POINT_TYPE, D.EMAIL_ADDRESS EMAIL_ADDRESS, D.PHONE_LINE_TYPE PHONE_LINE_TYPE, D.PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE, D.PHONE_AREA_CODE PHONE_AREA_CODE, D.PHONE_NUMBER PHONE_NUMBER, D.PHONE_EXTENSION PHONE_EXTENSION, D.URL URL FROM HZ_CUST_ACCOUNT_ROLES A, HZ_RELATIONSHIPS B, HZ_CONTACT_POINTS D WHERE A.PARTY_ID = B.PARTY_ID AND B.DIRECTIONAL_FLAG = 'F' AND B.PARTY_ID = D.OWNER_TABLE_ID(+) AND D.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND D.PRIMARY_FLAG = 'Y' AND A.STATUS(+) = 'A' AND B.STATUS(+) = 'A' AND D.STATUS(+) = 'A'

View Text - HTML Formatted

SELECT A.CUST_ACCOUNT_ROLE_ID CUST_ACCOUNT_ROLE_ID
, D.CONTACT_POINT_TYPE CONTACT_POINT_TYPE
, D.EMAIL_ADDRESS EMAIL_ADDRESS
, D.PHONE_LINE_TYPE PHONE_LINE_TYPE
, D.PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, D.PHONE_AREA_CODE PHONE_AREA_CODE
, D.PHONE_NUMBER PHONE_NUMBER
, D.PHONE_EXTENSION PHONE_EXTENSION
, D.URL URL
FROM HZ_CUST_ACCOUNT_ROLES A
, HZ_RELATIONSHIPS B
, HZ_CONTACT_POINTS D
WHERE A.PARTY_ID = B.PARTY_ID
AND B.DIRECTIONAL_FLAG = 'F'
AND B.PARTY_ID = D.OWNER_TABLE_ID(+)
AND D.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND D.PRIMARY_FLAG = 'Y'
AND A.STATUS(+) = 'A'
AND B.STATUS(+) = 'A'
AND D.STATUS(+) = 'A'