APPS.AR_CALC_AGING dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 43: l_gl_dist_table := 'ra_cust_trx_line_gl_dist ';

39: l_ps_table := 'ar_payment_schedules ';
40: l_ra_table := 'ar_receivable_applications ';
41: l_adj_table := 'ar_adjustments ';
42: l_ard_table := 'ar_distributions ';
43: l_gl_dist_table := 'ra_cust_trx_line_gl_dist ';
44: l_line_table := 'ra_customer_trx_lines ';
45: l_trx_table := 'ra_customer_trx ';
46: l_cr_table := 'ar_cash_receipts ';
47: ELSE

Line 948: SELECT /*+ LEADING(gl_dist,trx,type) index(gl_dist RA_CUST_TRX_LINE_GL_DIST_N2) */

944: p_coa_id);
945:
946: IF p_co_seg_low IS NOT NULL OR p_co_seg_high IS NOT NULL THEN
947: l_post_select := '
948: SELECT /*+ LEADING(gl_dist,trx,type) index(gl_dist RA_CUST_TRX_LINE_GL_DIST_N2) */
949: NVL(SUM(NVL(gl_dist.amount,0)),0) Invoice_Currency,
950: NVL(SUM(NVL(gl_dist.acctd_amount,0)),0) Functional_Currency
951: FROM ra_cust_trx_types type,
952: '||l_trx_table||' trx,

Line 991: SELECT /*+ LEADING(gl_dist,trx,type) index(gl_dist RA_CUST_TRX_LINE_GL_DIST_N2) */

987: '||l_trx_org_where ||'
988: '||company_segment_where;
989: ELSE
990: l_post_select := '
991: SELECT /*+ LEADING(gl_dist,trx,type) index(gl_dist RA_CUST_TRX_LINE_GL_DIST_N2) */
992: NVL(SUM(NVL(gl_dist.amount,0)),0) Invoice_Currency,
993: NVL(SUM(NVL(gl_dist.acctd_amount,0)),0) Functional_Currency
994: FROM ra_cust_trx_types type,
995: '||l_trx_table||' trx,

Line 1097: FROM ra_cust_trx_line_gl_dist

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

Line 1357: SELECT /*+ LEADING(gl_dist) index(gl_dist RA_CUST_TRX_LINE_GL_DIST_N2) */

1353: p_co_seg_high,
1354: p_coa_id);
1355:
1356: l_post_select := '
1357: SELECT /*+ LEADING(gl_dist) index(gl_dist RA_CUST_TRX_LINE_GL_DIST_N2) */
1358: NVL(SUM(NVL(gl_dist.amount,0)),0) ,
1359: NVL(SUM(NVL(gl_dist.acctd_amount,0)),0)
1360: FROM
1361: ra_cust_trx_types type,

Line 1579: AND lk.source_distribution_type = ''RA_CUST_TRX_LINE_GL_DIST_ALL''

1575: AND lk.event_id = hdr.event_id
1576: AND lk.ae_header_id = ae.ae_header_id
1577: AND lk.ae_line_num = ae.ae_line_num
1578: AND lk.application_id = 222
1579: AND lk.source_distribution_type = ''RA_CUST_TRX_LINE_GL_DIST_ALL''
1580: '|| l_trx_org_where;
1581:
1582: IF p_co_seg_low IS NOT NULL OR p_co_seg_high IS NOT NULL THEN
1583: l_sales_journal_salect := l_sales_journal_salect ||'