Need Oracle DB FlexCube 14.5 Core Banking DB Queries Writer

Looking for a Freelancer who can write following FlexCube 14.5 Core Banking DB Queries

Ultimately these queries need to be working on Database

1. Need Customer information query which returns the following

CIF
Customer Name
Address Line 1
Address Line 2
City
Country
Zip
Mobile
Email
Date Of Birth (To enable For Pin protection of estatement)

2. Need Account information query which returns the following

Account Number
Internal Account number(if any)
CIF
Branch Code
Branch Name
Account Currency
Account Type
Account Class
Account Status(Need Status Code of Active Account)


3. Need Transaction Information Query which returns the following based on input account number, from date, to date
Transaction Post Date
Transaction Value Date
Transaction Code
Transaction Description
Transaction Ref No
Debit Amount
Credit Amount
Running Balance
DR_CR Code

4. Need Opening Balance query for based on input account number, from date
5. Need Closing Balance query for based on input account number, to date
6. Need Clear Balance query for based on input account number, to date

One Sample DB TABLE Query for reference: SELECT * FROM STVW_CUSTOMER