eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_BANK_ACCT_BALANCE_REPORT dependencies on CE_PROJECTED_BALANCES

Line 1339: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb

1335: bb.AVERAGE_CLOSE_LEDGER_YTD,
1336: bb.AVERAGE_CLOSE_AVAILABLE_MTD,
1337: bb.AVERAGE_CLOSE_AVAILABLE_YTD,
1338: pb.PROJECTED_BALANCE
1339: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb
1340: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
1341: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
1342: and bb.BALANCE_DATE between nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE) and nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE)
1343: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 1373: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb

1369: bb.AVERAGE_CLOSE_LEDGER_YTD,
1370: bb.AVERAGE_CLOSE_AVAILABLE_MTD,
1371: bb.AVERAGE_CLOSE_AVAILABLE_YTD,
1372: pb.PROJECTED_BALANCE
1373: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb
1374: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
1375: and ba.BANK_ACCOUNT_ID = pb.BANK_ACCOUNT_ID
1376: and pb.BALANCE_DATE between nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE) and nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE)
1377: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)