Need a Query to Link the Bank Statements (CE) to AP, AR and GL Modules.

Hello Gurus,

    For the Bank Statements that load into Cash Managament Statement Base Tables. After Reconciled or Accounting done. Need to track the Balance in which Module the Amounts are .

So need a Query which lists the joins and Balances for Bank Statement Balance (CE), Receipts Applied to that Bank Statements (AR), Payments/Deposits in Transit (AP),

GL Adjustments Balance (GL), Total Adjustment Bank Balance ,GL Account Balance (GL),Unbooked Payments,Unbooked Deposits

from AR,AP,CE and GL Modules .