SELECT "MBMEMBMONEYTR"."MEMBER_NO", "MBMEMBMONEYTR"."TRTYPE_CODE", "MBMEMBMONEYTR"."MONEYTYPE_CODE", "MBMEMBMONEYTR"."BANK_CODE", "MBMEMBMONEYTR"."BANK_BRANCH", "MBMEMBMONEYTR"."BANK_ACCID", "MBMEMBMONEYTR"."COOP_ID", "MBUCFMONEYTRTYPE"."TRTYPE_DESC", "MBUCFMONEYTRTYPE"."SIGN_FLAG", "CMUCFBANKBRANCH"."BRANCH_NAME" FROM "MBMEMBMONEYTR", "MBUCFMONEYTRTYPE", "CMUCFBANKBRANCH" WHERE ( mbmembmoneytr.bank_code = cmucfbankbranch.bank_code (+)) and ( mbmembmoneytr.bank_branch = cmucfbankbranch.branch_id (+)) and ( "MBMEMBMONEYTR"."TRTYPE_CODE" = "MBUCFMONEYTRTYPE"."TRTYPE_CODE" )