FND Design Data [Home] [Help]

View: AR_CBA_BANK_BRANCH_CONTACTS_V

Product: AR - Receivables
Description: (Release 11.6 Only)
Implementation/DBA Data: ViewAPPS.AR_CBA_BANK_BRANCH_CONTACTS_V
View Text

SELECT PERSONPARTY.PERSON_LAST_NAME AS LAST_NAME
, PERSONPARTY.PERSON_FIRST_NAME AS FIRST_NAME
, PERSONPARTY.PERSON_MIDDLE_NAME AS MIDDLE_NAME
, PERSONPARTY.PERSON_TITLE AS TITLE
, PERSONPARTY.PERSON_PRE_NAME_ADJUNCT AS PREFIX
, PHONE.PHONE_COUNTRY_CODE AS PHONE_COUNTRY_CODE
, PHONE.PHONE_AREA_CODE AS PHONE_AREA_CODE
, PHONE.PHONE_NUMBER AS PHONE_NUMBER
, PHONE.RAW_PHONE_NUMBER AS RAW_PHONE_NUMBER
, FAX.PHONE_COUNTRY_CODE AS FAX_COUNTRY_CODE
, FAX.PHONE_AREA_CODE AS FAX_AREA_CODE
, FAX.PHONE_NUMBER AS FAX_NUMBER
, FAX.RAW_PHONE_NUMBER AS RAW_FAX_NUMBER
, EMAIL.EMAIL_ADDRESS AS EMAIL_ADDRESS
, WEB.URL AS URL
, NVL(CCA.BRANCH_PARTY_ID
, CCA.BANK_PARTY_ID) AS BANK_OR_BRANCH_ID
FROM HZ_PARTIES PERSONPARTY
, HZ_PARTIES RELPARTY
, HZ_CONTACT_POINTS PHONE
, HZ_CONTACT_POINTS FAX
, HZ_CONTACT_POINTS EMAIL
, HZ_CONTACT_POINTS WEB
, HZ_RELATIONSHIPS BCREL
, CE_CONTACT_ASSIGNMENTS CCA
WHERE BCREL.RELATIONSHIP_ID = CCA.RELATIONSHIP_ID
AND CCA.BANK_ACCOUNT_ID IS NULL
AND BCREL.SUBJECT_ID = PERSONPARTY.PARTY_ID
AND BCREL.SUBJECT_TYPE = 'PERSON'
AND BCREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND BCREL.STATUS = 'A'
AND RELPARTY.PARTY_ID = BCREL.PARTY_ID
AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND PHONE.OWNER_TABLE_ID(+) = RELPARTY.PARTY_ID
AND PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
AND PHONE.PHONE_LINE_TYPE(+) = 'GEN'
AND PHONE.STATUS(+) = 'A'
AND FAX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND FAX.OWNER_TABLE_ID(+) = RELPARTY.PARTY_ID
AND FAX.CONTACT_POINT_TYPE(+) = 'PHONE'
AND FAX.PHONE_LINE_TYPE(+) = 'FAX'
AND FAX.STATUS(+) = 'A'
AND EMAIL.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND EMAIL.OWNER_TABLE_ID(+) = RELPARTY.PARTY_ID
AND EMAIL.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND EMAIL.STATUS(+) = 'A'
AND WEB.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND WEB.OWNER_TABLE_ID(+) = RELPARTY.PARTY_ID
AND WEB.CONTACT_POINT_TYPE(+) = 'WEB'
AND WEB.STATUS(+) = 'A'

Columns

Name
LAST_NAME
FIRST_NAME
MIDDLE_NAME
TITLE
PREFIX
PHONE_COUNTRY_CODE
PHONE_AREA_CODE
PHONE_NUMBER
RAW_PHONE_NUMBER
FAX_COUNTRY_CODE
FAX_AREA_CODE
FAX_NUMBER
RAW_FAX_NUMBER
EMAIL_ADDRESS
URL
BANK_OR_BRANCH_ID