APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_BASE_GL_ACCT_BALANCES

Line 266: 'UPDATE ar_base_gl_acct_balances bal

262:
263: -- update null trx number, type, date, currency for invoices and CMS.
264:
265: l_update_stmt :=
266: 'UPDATE ar_base_gl_acct_balances bal
267: SET (trx_number, trx_type, trx_date, currency) =
268: (
269: SELECT receipt_number, rm.name, receipt_date, currency_code
270: FROM ' || g_ar_cash_receipts_all || ', '

Line 310: 'UPDATE ar_base_gl_acct_balances bal

306:
307: -- update null trx number, type, date, currency for invoices and CMS.
308:
309: l_update_stmt :=
310: 'UPDATE ar_base_gl_acct_balances bal
311: SET (trx_number, trx_type, trx_date, currency) =
312: (
313: SELECT trx_number, ctt.name, trx_date, invoice_currency_code
314: FROM ' || g_ra_customer_trx_all || ', '

Line 855: INSERT INTO ar_base_gl_acct_balances

851:
852: IF p_period_status = 'CLOSED' THEN
853:
854: FORALL i IN 1..code_combination_id_tab.count
855: INSERT INTO ar_base_gl_acct_balances
856: (
857: component,
858: gl_account,
859: natural_account,

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

1199:
1200: debug('ar_cumulative_balance_report.refresh_verdict(+)');
1201:
1202: l_sql_stmt := 'SELECT count(*), max(trx_date), max(activity_gl_date)
1203: FROM ar_base_gl_acct_balances bal WHERE 1=1 ' ;
1204:
1205: l_sql_stmt := l_sql_stmt || g_balances_where;
1206:
1207: debug('sql statement');

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

1368:
1369: debug('start date: ' || l_min_start_date);
1370: debug('end date: ' || l_max_end_date);
1371:
1372: l_delete_stmt := 'DELETE FROM ar_base_gl_acct_balances bal WHERE 1=1 ';
1373: l_delete_stmt := l_delete_stmt || g_balances_where;
1374:
1375: debug('Delete Statement: ' || l_delete_stmt);
1376: EXECUTE IMMEDIATE l_delete_stmt;

Line 1389: l_delete_stmt := 'DELETE FROM ar_base_gl_acct_balances bal

1385: p_period_status => 'CLOSED');
1386:
1387: debug('base: deleting all lines whose cr and dr cancel each other');
1388:
1389: l_delete_stmt := 'DELETE FROM ar_base_gl_acct_balances bal
1390: WHERE nvl(acctd_amount_dr,0) = nvl(acctd_amount_cr,0) ';
1391: l_delete_stmt := l_delete_stmt || g_balances_where;
1392:
1393: debug('Delete Statement: ' || l_delete_stmt);

Line 1837: FROM ar_base_gl_acct_balances bal,

1833: amount_dr,
1834: decode(sign(sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0))), -1, 0,
1835: sum(nvl(amount_cr,0))-sum(nvl(amount_dr,0)))
1836: amount_cr
1837: FROM ar_base_gl_acct_balances bal,
1838: gl_code_combinations gcc
1839: WHERE bal.code_combination_id = gcc.code_combination_id ';
1840:
1841: l_recent_query :=