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_BANK_ACCOUNTS

Line 20: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

16: return number
17: is
18: cursor cursor_bank_currency_code is
19: select distinct ba.CURRENCY_CODE
20: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
21: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
22: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
23: and bb.BALANCE_DATE = l_date
24: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 415: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

411: v_AvgAvailableYTDTotal number;
412:
413: cursor cursor_bank_currency_code is
414: select distinct ba.CURRENCY_CODE
415: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
416: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
417: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
418: and bb.BALANCE_DATE = l_date
419: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 426: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

422: and ba.ACCOUNT_OWNER_ORG_ID = nvl(p_legal_entity_id, ba.ACCOUNT_OWNER_ORG_ID);
423:
424: cursor cursor_bank_account_id (currency varchar2) is
425: select ba.bank_account_id
426: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
427: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
428: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
429: and bb.BALANCE_DATE = l_date
430: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 479: from ce_bank_accounts

475: -- get bank account name
476: if p_bank_acct_id is not null then
477: select BANK_ACCOUNT_NAME
478: into l_Bank_ACCT_NAME
479: from ce_bank_accounts
480: where BANK_ACCOUNT_ID = p_bank_acct_id;
481: end if;
482:
483:

Line 885: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

881: xmlelement("AvgAvailableYTDAC", xmlattributes(v_AvgAvailableYTD_Date as "BalanceDate", decode(v_AvgAvailableYTD_Date - l_date, 0, '', '*') as "Flag"), CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableYTDAC, ba.CURRENCY_CODE)),
882: xmlelement("AvgAvailableYTDRC", CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableYTDRC, p_reporting_currency))
883: )
884: into v_xml_seg1
885: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
886: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
887: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
888: and bb.BALANCE_DATE = l_date
889: and ba.BANK_ACCOUNT_ID = v_bank_account_id;

Line 1047: from ce_bank_accounts

1043:
1044: if p_bank_acct_id is not null then
1045: select BANK_ACCOUNT_NAME
1046: into l_Bank_ACCT_NAME
1047: from ce_bank_accounts
1048: where BANK_ACCOUNT_ID = p_bank_acct_id;
1049: end if;
1050:
1051: if p_reporting_currency is null then

Line 1115: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

1111: CE_BANKACCT_BA_REPORT_UTIL.get_balance(bb.AVERAGE_CLOSE_AVAILABLE_YTD, ba.CURRENCY_CODE) as "AvgCloseAvailableYTDAC",
1112: CE_BANKACCT_BA_REPORT_UTIL.get_reporting_balance(bb.AVERAGE_CLOSE_AVAILABLE_YTD, ba.CURRENCY_CODE, p_reporting_currency, p_exchange_rate_date,p_exchange_rate_type) as "AvgCloseAvailableYTDRC"
1113: ))))
1114: into l_xml
1115: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
1116: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
1117: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
1118: 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)
1119: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 1228: from ce_bank_accounts

1224:
1225: if p_bank_acct_id is not null then
1226: select BANK_ACCOUNT_NAME
1227: into l_Bank_ACCT_NAME
1228: from ce_bank_accounts
1229: where BANK_ACCOUNT_ID = p_bank_acct_id;
1230: end if;
1231:
1232: if p_legal_entity_id is not null then

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

1281: l_balance_type_meaning as "ActualBalanceType",
1282: CE_BANKACCT_BA_REPORT_UTIL.get_balance(pb.PROJECTED_BALANCE,ba.CURRENCY_CODE) as "ProjectedBalance"
1283: ))))
1284: into l_xml
1285: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb
1286: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
1287: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
1288: 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)
1289: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)