APPS.ARP_RECON_REP dependencies on AR_GL_RECON_GT

Line 3926: insert into ar_gl_recon_gt(code_combination_id,

3922: 'SELECT',
3923: 'GL_BALANCING');
3924:
3925: l_temp_stmt := '
3926: insert into ar_gl_recon_gt(code_combination_id,
3927: receivables_dr,receivables_cr,
3928: account_type, account_type_code,account,company)
3929: (select dat.code_combination_id,
3930: sum(nvl(acctd_amount_dr,0)) receivables_debit,

Line 4680: update ar_gl_recon_gt argt

4676: l_gl_date_from, l_gl_date_to,
4677: l_gl_date_from, l_gl_date_to, p_reporting_entity_id ;*/
4678:
4679:
4680: update ar_gl_recon_gt argt
4681: set (opening_balance_dr,
4682: opening_balance_cr,
4683: period_activity_dr,
4684: period_activity_cr) = (select nvl(glb.begin_balance_dr,0),

Line 4695: update ar_gl_recon_gt argt

4691: and glb.actual_flag = 'A'
4692: and glb.ledger_id = get_set_of_books_id()
4693: and glb.currency_code = get_functional_currency());
4694:
4695: update ar_gl_recon_gt argt
4696: set (subledger_not_ar_dr ,
4697: subledger_not_ar_cr ,
4698: subledger_manual_dr ,
4699: subledger_manual_cr ,

Line 4736: update ar_gl_recon_gt argt

4732: and gjh.actual_flag = 'A'
4733: and gjh.currency_code <> 'STAT'
4734: group by gjl.code_combination_id);
4735:
4736: update ar_gl_recon_gt argt
4737: set (gl_interface_dr, gl_interface_cr) =
4738: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,
4739: sum(nvl(gif.accounted_cr,0)) gl_interface_cr
4740: from gl_interface gif,

Line 4750: 'ar_gl_recon_gt' is 240, but the return value's length can up to 2000, so cut the

4746: and gif.actual_flag = 'A'
4747: group by gif.code_combination_id);
4748:
4749: /* Commented for bug 10177944, the length of the column 'account_desc' in the table
4750: 'ar_gl_recon_gt' is 240, but the return value's length can up to 2000, so cut the
4751: description of it's more than 240./*
4752: /*update ar_gl_recon_gt
4753: set account_desc = ar_calc_aging.get_description (101,'GL#',
4754: arp_recon_rep.get_chart_of_accounts_id(),'GL_ACCOUNT',code_combination_id);*/

Line 4752: /*update ar_gl_recon_gt

4748:
4749: /* Commented for bug 10177944, the length of the column 'account_desc' in the table
4750: 'ar_gl_recon_gt' is 240, but the return value's length can up to 2000, so cut the
4751: description of it's more than 240./*
4752: /*update ar_gl_recon_gt
4753: set account_desc = ar_calc_aging.get_description (101,'GL#',
4754: arp_recon_rep.get_chart_of_accounts_id(),'GL_ACCOUNT',code_combination_id);*/
4755:
4756:

Line 4759: update ar_gl_recon_gt

4755:
4756:
4757: -- Fix for bug 16357135 .. pass "code_combination_id" in place of
4758: -- "account" for the get_decription function
4759: update ar_gl_recon_gt
4760: set account_desc = substr(get_description(101,'GL#',
4761: arp_recon_rep.get_chart_of_accounts_id(),'GL_ACCOUNT',code_combination_id),1,235);
4762:
4763: l_xml_query := '

Line 4786: from ar_gl_recon_gt

4782: nvl(gl_interface_dr,0) gl_interface_debit,
4783: nvl(gl_interface_cr,0) gl_interface_credit,
4784: nvl(receivables_dr,0) receivables_debit,
4785: nvl(receivables_cr,0) receivables_credit
4786: from ar_gl_recon_gt
4787: where ''N'' = arp_recon_rep.get_out_of_balance_only()
4788: or nvl(receivables_dr,0)- nvl(subledger_rec_dr,0) <> 0
4789: or nvl(receivables_cr,0)- nvl(subledger_rec_cr,0) <> 0
4790: order by account_type_code,