1. Tables and Views for Procurement
  2. POZ_BI_SUPP_REG_BANK_ACCOUNT_V

POZ_BI_SUPP_REG_BANK_ACCOUNT_V

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: VIEW

Columns

Name

ACCOUNTREQUESTID

SUPPLIERREGID

BANK

BANKNUMBER

BRANCH

BRANCHNUMBER

COUNTRY

COUNTRYCODE

CURRENCY

CURRENCYCODE

BANKID

BRANCHID

NOTE

BANKACCOUNTNUM

IBAN

BANKACCOUNTNAME

BANKACCOUNTNAMEALT

ACCOUNTSUFFIX

CHECKDIGITS

AGENCYLOCATIONCODE

BANKACCOUNTTYPE

DESCRIPTION

CREATEDBY

CREATIONDATE

LASTUPDATEDATE

LASTUPDATEDBY

LASTUPDATELOGIN

OBJECTVERSIONNUMBER

TEMPEXTBANKACCTID

SECONDARYACCOUNTREFERENCE

Query

SQL_Statement

SELECT PozAcntGenReqs.ACCOUNT_REQUEST_ID AS AccountRequestId,

SUPPLIERMAPPINGEO.SUPPLIER_REG_ID AS SupplierRegId,

BankPEO.BANK_NAME AS Bank,

BankPEO.BANK_NUMBER AS BankNumber,

BankBranchPEO.BANK_BRANCH_NAME AS Branch,

BankBranchPEO.BRANCH_NUMBER AS BranchNumber,

TerritoryPEO.TERRITORY_SHORT_NAME AS Country,

TempExternalBankAccountEO.COUNTRY_CODE AS CountryCode,

CurrencyPEO.NAME AS Currency,

CurrencyPEO.CURRENCY_CODE AS CurrencyCode,

TempExternalBankAccountEO.BANK_ID AS BankId,

TempExternalBankAccountEO.BRANCH_ID AS BranchId ,

TempExternalBankAccountEO.NOTE AS Note,

TempExternalBankAccountEO.BANK_ACCOUNT_NUM AS BankAccountNum,

TempExternalBankAccountEO.IBAN AS IBAN,

TempExternalBankAccountEO.BANK_ACCOUNT_NAME AS BankAccountName,

TempExternalBankAccountEO.BANK_ACCOUNT_NAME_ALT AS BankAccountNameAlt,

TempExternalBankAccountEO.ACCOUNT_SUFFIX AS AccountSuffix,

TempExternalBankAccountEO.CHECK_DIGITS AS CheckDigits,

TempExternalBankAccountEO.AGENCY_LOCATION_CODE AS AgencyLocationCode,

TempExternalBankAccountEO.BANK_ACCOUNT_TYPE AS BankAccountType,

TempExternalBankAccountEO.DESCRIPTION AS Description,

TempExternalBankAccountEO.CREATED_BY AS CreatedBy,

TempExternalBankAccountEO.CREATION_DATE AS CreationDate,

TempExternalBankAccountEO.LAST_UPDATE_DATE AS LastUpdateDate,

TempExternalBankAccountEO.LAST_UPDATED_BY AS LastUpdatedBy,

TempExternalBankAccountEO.LAST_UPDATE_LOGIN AS LastUpdateLogin,

TempExternalBankAccountEO.OBJECT_VERSION_NUMBER AS ObjectVersionNumber,

TempExternalBankAccountEO.TEMP_EXT_BANK_ACCT_ID AS Tempextbankacctid,

TempExternalBankAccountEO.SECONDARY_ACCOUNT_REFERENCE as SecondaryAccountReference

FROM

IBY_TEMP_EXT_BANK_ACCTS TempExternalBankAccountEO,

POZ_ACNT_GEN_REQS PozAcntGenReqs,

FND_CURRENCIES_VL CurrencyPEO,

FND_TERRITORIES_VL TerritoryPEO,

CE_BANKS_V BankPEO,

CE_BANK_BRANCHES_V BankBranchPEO,

POZ_SUPPLIER_MAPPINGS SUPPLIERMAPPINGEO

WHERE (((((

TempExternalBankAccountEO.TEMP_EXT_BANK_ACCT_ID =

PozAcntGenReqs.TEMP_EXT_BANK_ACCT_ID)

AND (TempExternalBankAccountEO.CURRENCY_CODE = CurrencyPEO.CURRENCY_CODE(+)))

AND (TempExternalBankAccountEO.COUNTRY_CODE = TerritoryPEO.TERRITORY_CODE(+)))

AND (TempExternalBankAccountEO.BANK_ID = BankPEO.BANK_PARTY_ID(+)))

AND (TempExternalBankAccountEO.BRANCH_ID = BankBranchPEO.BRANCH_PARTY_ID(+)))

AND PozAcntGenReqs.MAPPING_ID = SUPPLIERMAPPINGEO.MAPPING_ID