APPS.AR_CALC_AGING dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 43: l_gl_dist_table := 'ra_cust_trx_line_gl_dist_all ';

39: l_ps_table := 'ar_payment_schedules_all ';
40: l_ra_table := 'ar_receivable_applications_all ';
41: l_adj_table := 'ar_adjustments_all ';
42: l_ard_table := 'ar_distributions_all ';
43: l_gl_dist_table := 'ra_cust_trx_line_gl_dist_all ';
44: l_line_table := 'ra_customer_trx_lines_all ';
45: l_trx_table := 'ra_customer_trx_all ';
46: l_cr_table := 'ar_cash_receipts_all ';
47: ELSE

Line 1094: FROM ra_cust_trx_line_gl_dist

1090: IF NVL(ar_calc_aging.ca_sob_type,'P') = 'P'
1091: THEN
1092: SELECT NVL(SUM(NVL(acctd_amount,0)),0)
1093: INTO l_rounding_diff
1094: FROM ra_cust_trx_line_gl_dist
1095: WHERE amount = 0
1096: AND gl_date BETWEEN l_gl_date_low AND l_gl_date_high ;
1097: ELSE
1098: SELECT NVL(SUM(NVL(acctd_amount,0)),0)

Line 1573: AND lk.source_distribution_type = ''RA_CUST_TRX_LINE_GL_DIST_ALL'')

1569: WHERE lk.event_id = hdr.event_id
1570: AND lk.ae_header_id = ae.ae_header_id
1571: AND lk.ae_line_num = ae.ae_line_num
1572: AND lk.application_id = 222
1573: AND lk.source_distribution_type = ''RA_CUST_TRX_LINE_GL_DIST_ALL'')
1574: '|| l_trx_org_where;
1575:
1576: IF p_co_seg_low IS NOT NULL OR p_co_seg_high IS NOT NULL THEN
1577: l_sales_journal_salect := l_sales_journal_salect ||'