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 |