CREATE OR REPLACE FORCE VIEW "TAD_E53"."PD_BANK_LIST" ("C_BANKACCOUNT_ID", "AD_CLIENT_ID", "AD_ORG_ID", "CREATED", "CREATEDBY", "UPDATED", "UPDATEDBY", "NAME", "BANCO", "CODEBANK", "CODEBRANCH", "BANKDC", "ACCOUNTDC", "CODEACCOUNT") AS 
  SELECT 
    C_BANKACCOUNT_ID, 
    C_BANKACCOUNT.AD_CLIENT_ID, 
    C_BANKACCOUNT.AD_ORG_ID, 
    C_BANKACCOUNT.CREATED, 
    C_BANKACCOUNT.CREATEDBY, 
    C_BANKACCOUNT.UPDATED, 
    C_BANKACCOUNT.UPDATEDBY, 
    C_BANKACCOUNT.NAME, 
    C_BANK.NAME AS BANCO, 
    C_BANK.CODEBANK, 
    C_BANK.CODEBRANCH, 
    C_BANK.DIGITCONTROL AS BANKDC, 
    C_BANKACCOUNT.DIGITCONTROL AS ACCOUNTDC, 
    C_BANKACCOUNT.CODEACCOUNT 
FROM 
    C_BANKACCOUNT LEFT OUTER JOIN C_BANK ON C_BANKACCOUNT.C_BANK_ID = C_BANK.C_BANK_ID 
WHERE 
    C_BANKACCOUNT.AD_CLIENT_ID = '1000001';