VIEW: APPS.IBY_F_LENDER_CONTACTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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