APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_BASE_GL_ACCT_BALANCES

Line 292: 'UPDATE ar_base_gl_acct_balances bal

288:
289: -- update null trx number, type, date, currency for invoices and CMS.
290:
291: l_update_stmt :=
292: 'UPDATE ar_base_gl_acct_balances bal
293: SET (trx_number, trx_type, trx_date, currency) =
294: (
295: SELECT receipt_number, rm.name, receipt_date, currency_code
296: FROM ' || g_ar_cash_receipts_all || ', '

Line 336: 'UPDATE ar_base_gl_acct_balances bal

332:
333: -- update null trx number, type, date, currency for invoices and CMS.
334:
335: l_update_stmt :=
336: 'UPDATE ar_base_gl_acct_balances bal
337: SET (trx_number, trx_type, trx_date, currency) =
338: (
339: SELECT trx_number, ctt.name, trx_date, invoice_currency_code
340: FROM ' || g_ra_customer_trx_all || ', '

Line 881: INSERT INTO ar_base_gl_acct_balances

877:
878: IF p_period_status = 'CLOSED' THEN
879:
880: FORALL i IN 1..code_combination_id_tab.count
881: INSERT INTO ar_base_gl_acct_balances
882: (
883: component,
884: gl_account,
885: natural_account,

Line 1232: FROM ar_base_gl_acct_balances bal WHERE 1=1 ' ;

1228:
1229: debug('ar_cumulative_balance_report.refresh_verdict(+)');
1230:
1231: l_sql_stmt := 'SELECT count(*), max(trx_date), max(activity_gl_date)
1232: FROM ar_base_gl_acct_balances bal WHERE 1=1 ' ;
1233:
1234: l_sql_stmt := l_sql_stmt || g_balances_where;
1235:
1236: debug('sql statement');

Line 1401: l_delete_stmt := 'DELETE FROM ar_base_gl_acct_balances bal WHERE 1=1 ';

1397:
1398: debug('start date: ' || l_min_start_date);
1399: debug('end date: ' || l_max_end_date);
1400:
1401: l_delete_stmt := 'DELETE FROM ar_base_gl_acct_balances bal WHERE 1=1 ';
1402: l_delete_stmt := l_delete_stmt || g_balances_where;
1403:
1404: debug('Delete Statement: ' || l_delete_stmt);
1405: EXECUTE IMMEDIATE l_delete_stmt;

Line 1418: l_delete_stmt := 'DELETE FROM ar_base_gl_acct_balances bal

1414: p_period_status => 'CLOSED');
1415:
1416: debug('base: deleting all lines whose cr and dr cancel each other');
1417:
1418: l_delete_stmt := 'DELETE FROM ar_base_gl_acct_balances bal
1419: WHERE nvl(acctd_amount_dr,0) = nvl(acctd_amount_cr,0) ';
1420: l_delete_stmt := l_delete_stmt || g_balances_where;
1421:
1422: debug('Delete Statement: ' || l_delete_stmt);

Line 1866: FROM ar_base_gl_acct_balances bal,

1862: amount_dr,
1863: decode(sign(sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0))), -1, 0,
1864: sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0)))
1865: amount_cr
1866: FROM ar_base_gl_acct_balances bal,
1867: gl_code_combinations gcc
1868: WHERE bal.code_combination_id = gcc.code_combination_id ';
1869:
1870: l_recent_query :=