54: l_trx_table := 'ra_customer_trx_all_mrc_v ';
55: l_cr_table := 'ar_cash_receipts_all_mrc_v ';
56: END IF;
57:
58: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
56: END IF;
57:
58: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
57:
58: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
58: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');
70: /* Replace the variables to bind with the function calls so that we don't have to bind those */
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');
70: /* Replace the variables to bind with the function calls so that we don't have to bind those */
71: l_ps_org_where := replace(l_ps_org_where,
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');
70: /* Replace the variables to bind with the function calls so that we don't have to bind those */
71: l_ps_org_where := replace(l_ps_org_where,
72: ':p_reporting_entity_id','ar_calc_aging.get_reporting_entity_id()');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');
70: /* Replace the variables to bind with the function calls so that we don't have to bind those */
71: l_ps_org_where := replace(l_ps_org_where,
72: ':p_reporting_entity_id','ar_calc_aging.get_reporting_entity_id()');
73: l_gl_dist_org_where:= replace(l_gl_dist_org_where,
1872: ELSE
1873: l_sysparam_table := 'ar_system_parameters_all_mrc_v ';
1874: END IF;
1875:
1876: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1877:
1878: l_sysparam_where := XLA_MO_REPORTING_API.Get_Predicate('param',null);
1879:
1880: l_sysparam_where := replace(l_sysparam_where,
1874: END IF;
1875:
1876: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1877:
1878: l_sysparam_where := XLA_MO_REPORTING_API.Get_Predicate('param',null);
1879:
1880: l_sysparam_where := replace(l_sysparam_where,
1881: ':p_reporting_entity_id','ar_calc_aging.get_reporting_entity_id()');
1882: