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 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 471: from ce_bank_branches_v

467: -- get bank branch name
468: if p_branch_party_id is not null then
469: select BANK_BRANCH_NAME
470: into l_Bank_Branch_Name
471: from ce_bank_branches_v
472: where BRANCH_PARTY_ID = p_branch_party_id;
473: end if;
474:
475: -- get bank account name

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 1040: from ce_bank_branches_v

1036:
1037: if p_branch_party_id is not null then
1038: select BANK_BRANCH_NAME, BANK_NAME
1039: into l_Bank_Branch_Name, l_Bank_Name
1040: from ce_bank_branches_v
1041: where BRANCH_PARTY_ID = p_branch_party_id;
1042: end if;
1043:
1044: if p_bank_acct_id is not 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 1221: from ce_bank_branches_v

1217:
1218: if p_branch_party_id is not null then
1219: select BANK_BRANCH_NAME, BANK_NAME
1220: into l_Bank_Branch_Name, l_Bank_Name
1221: from ce_bank_branches_v
1222: where BRANCH_PARTY_ID = p_branch_party_id;
1223: end if;
1224:
1225: if p_bank_acct_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)