View: IBY_F_LENDERS_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_F_LENDERS_V

View Text

SELECT BEP.BEPID
, BEP.OBJECT_VERSION_NUMBER BEPINFO_OVN
, BEP.CREATED_BY
, BEP.CREATION_DATE
, BEP.LAST_UPDATED_BY
, BEP.LAST_UPDATE_DATE
, BEP.LAST_UPDATE_LOGIN
, BEP.NAME
, BEP.BASEURL
, BEP.SUFFIX
, BEP.BEPUSERNAME
, BEP.BEPPASSWORD
, BEP.SUPPORTEDOP
, BEP.ADMINURL
, BEP.LOGINURL
, BEP.ACTIVESTATUS
, BEP.BEP_TYPE
, DECODE(NVL(IDP.BEPID
, -1)
, -1
, 'N'
, 'Y') DEFAULT_BEP_FLAG
, IBG.BEPLANG
, IBG.PREFERRED
, BEP.PARTY_ID
, HPE.PARTY_NAME LENDER_NAME
, 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
, BEP.SECURITY_GROUP_ID
, -1 PARTY_OVN
FROM IBY_BEPINFO BEP
, IBY_BEPLANGS IBG
, IBY_DEFAULT_BEP IDP
, HZ_PARTIES HPE
, HZ_PARTY_SITES HPS
, HZ_PARTY_SITE_USES HPSU
, HZ_LOCATIONS HLC
WHERE BEP.BEPID = IBG.BEPID (+)
AND IDP.BEPID (+) = BEP.BEPID
AND BEP.PARTY_ID = HPE.PARTY_ID (+)
AND BEP.BEP_TYPE = 'LENDER'
AND HPE.PARTY_ID = HPS.PARTY_ID (+)
AND HPS.LOCATION_ID = HLC.LOCATION_ID
AND HPS.PARTY_SITE_ID = HPSU.PARTY_SITE_ID (+)
AND HPS.IDENTIFYING_ADDRESS_FLAG = 'Y'
AND HPSU.SITE_USE_TYPE = 'BILL_TO'
AND HPSU.PRIMARY_PER_TYPE = 'Y'

Columns