Product: | IBY - Payments |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBY_F_LENDER_CONTACTS_V |
SELECT BEP.BEPID
, HPE.CREATED_BY
, HPE.CREATION_DATE
, HPE.LAST_UPDATED_BY
, HPE.LAST_UPDATE_DATE
, HPE.LAST_UPDATE_LOGIN
, HPE1.PARTY_ID LENDER_PARTY_ID
, HPE1.PARTY_NAME LENDER_PARTY_NAME
, HPE.PARTY_ID
, HPE.PARTY_NAME CONTACT_NAME
, HPE.PERSON_FIRST_NAME
, HPE.PERSON_LAST_NAME
, -1 PERSON_PARTY_OVN
, HCPE.CONTACT_POINT_ID EMAIL_CONTACT_POINT_ID
, HCPE.EMAIL_FORMAT
, HCPE.EMAIL_ADDRESS
, -1 EMAIL_ADDR_OVN
, HCPP.CONTACT_POINT_ID PHONE_CONTACT_POINT_ID
, HCPP.PHONE_COUNTRY_CODE
, HCPP.PHONE_AREA_CODE
, HCPP.PHONE_NUMBER
, HCPP.PHONE_EXTENSION
, HCPP.PHONE_LINE_TYPE
, -1 PHONE_OVN
, HOT.JOB_TITLE
, HOT.DEPARTMENT
, HLC.LOCATION_ID
, HLC.ADDRESS1
, HLC.ADDRESS2 || DECODE(HLC.ADDRESS2
, ''
, ''
, DECODE(HLC.ADDRESS3
, ''
, ''
, '
, '))|| HLC.ADDRESS3 || DECODE(HLC.ADDRESS3
, ''
, ''
, DECODE(HLC.ADDRESS4
, ''
, ''
, '
, '))|| HLC.ADDRESS4 ADDRESS2
, HLC.CITY
, HLC.POSTAL_CODE
, HLC.STATE
, HLC.PROVINCE
, HLC.COUNTRY
, -1 LOCATION_OVN
FROM IBY_BEPINFO BEP
, HZ_PARTIES HPE1
, HZ_PARTIES HPE
, HZ_ORG_CONTACTS HOT
, AR_LOOKUPS ALP
, HZ_CONTACT_POINTS HCPE
, HZ_CONTACT_POINTS HCPP
, HZ_PARTY_SITES HPS
, HZ_PARTY_SITE_USES HPSU
, HZ_LOCATIONS HLC