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_BRANCHES_V

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

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

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

423: counterflag number; -- Bug 8620223
424:
425: cursor cursor_bank_currency_code is
426: select distinct ba.CURRENCY_CODE
427: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
428: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
429: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
430: -- Bug 8620223 and bb.BALANCE_DATE = l_date
431: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 439: --from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

435:
436: -- Bug 8620223
437: cursor cursor_bank_account_id (currency varchar2) is
438: select distinct ba.bank_account_id
439: --from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
440: from CE_BANK_ACCTS_GT_V ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
441: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
442: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
443: --and bb.BALANCE_DATE = l_date

Line 440: from CE_BANK_ACCTS_GT_V ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

436: -- Bug 8620223
437: cursor cursor_bank_account_id (currency varchar2) is
438: select distinct ba.bank_account_id
439: --from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
440: from CE_BANK_ACCTS_GT_V ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
441: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
442: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
443: --and bb.BALANCE_DATE = l_date
444: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 485: from ce_bank_branches_v

481: -- get bank branch name
482: if p_branch_party_id is not null then
483: select BANK_BRANCH_NAME
484: into l_Bank_Branch_Name
485: from ce_bank_branches_v
486: where BRANCH_PARTY_ID = p_branch_party_id;
487: end if;
488:
489: -- get bank account name

Line 915: from ce_bank_accounts ba, ce_bank_branches_v bh -- , ce_bank_acct_balances bb

911: 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)),
912: xmlelement("AvgAvailableYTDRC", CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableYTDRC, p_reporting_currency))
913: )
914: into v_xml_seg1
915: from ce_bank_accounts ba, ce_bank_branches_v bh -- , ce_bank_acct_balances bb
916: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
917: --and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
918: -- and bb.BALANCE_DATE = l_date
919: and ba.BANK_ACCOUNT_ID = v_bank_account_id;

Line 1071: from ce_bank_branches_v

1067:
1068: if p_branch_party_id is not null then
1069: select BANK_BRANCH_NAME, BANK_NAME
1070: into l_Bank_Branch_Name, l_Bank_Name
1071: from ce_bank_branches_v
1072: where BRANCH_PARTY_ID = p_branch_party_id;
1073: end if;
1074:
1075: if p_bank_acct_id is not null then

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

1142: CE_BANKACCT_BA_REPORT_UTIL.get_balance(bb.AVERAGE_CLOSE_AVAILABLE_YTD, ba.CURRENCY_CODE) as "AvgCloseAvailableYTDAC",
1143: 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"
1144: ))ORDER BY bb.BALANCE_DATE)) -- Bug 6632931
1145: into l_xml
1146: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
1147: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
1148: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
1149: 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)
1150: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 1252: from ce_bank_branches_v

1248:
1249: if p_branch_party_id is not null then
1250: select BANK_BRANCH_NAME, BANK_NAME
1251: into l_Bank_Branch_Name, l_Bank_Name
1252: from ce_bank_branches_v
1253: where BRANCH_PARTY_ID = p_branch_party_id;
1254: end if;
1255:
1256: if p_bank_acct_id is not null then

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)