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',null);
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', null);
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', null);
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',null);
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', null);
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', null);
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines',null);
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , null);
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',null);
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', null);
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', null);
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines',null);
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , null);
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',null);
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',null);
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', null);
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', null);
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines',null);
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , null);
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',null);
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',null);
59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',null);
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', null);
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', null);
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines',null);
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , null);
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',null);
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',null);
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,null);
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',null);
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', null);
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', null);
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines',null);
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , null);
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',null);
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',null);
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,null);
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,null);
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', null);
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', null);
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines',null);
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , null);
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',null);
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',null);
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,null);
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,null);
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,null);
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', null);
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines',null);
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , null);
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',null);
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',null);
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,null);
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,null);
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,null);
70:
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines',null);
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , null);
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',null);
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',null);
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,null);
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,null);
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,null);
70:
71: /* Replace the variables to bind with the function calls so that we don't have to bind those */
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , null);
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',null);
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',null);
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,null);
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,null);
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,null);
70:
71: /* Replace the variables to bind with the function calls so that we don't have to bind those */
72: l_ps_org_where := replace(l_ps_org_where,
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',null);
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',null);
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,null);
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,null);
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,null);
70:
71: /* Replace the variables to bind with the function calls so that we don't have to bind those */
72: l_ps_org_where := replace(l_ps_org_where,
73: ':p_reporting_entity_id','ar_calc_aging.get_reporting_entity_id()');
1855: ELSE
1856: l_sysparam_table := 'ar_system_parameters_all_mrc_v ';
1857: END IF;
1858:
1859: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1860:
1861: l_sysparam_where := XLA_MO_REPORTING_API.Get_Predicate('param',null);
1862:
1863: l_sysparam_where := replace(l_sysparam_where,
1857: END IF;
1858:
1859: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1860:
1861: l_sysparam_where := XLA_MO_REPORTING_API.Get_Predicate('param',null);
1862:
1863: l_sysparam_where := replace(l_sysparam_where,
1864: ':p_reporting_entity_id','ar_calc_aging.get_reporting_entity_id()');
1865: