eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_RECONCILE dependencies on RA_CUSTOMER_TRX_LINES

Line 446: FROM ra_customer_trx_lines ctl,

442: nvl(adj.line_adjusted,0) br_adj_line_amt ,
443: nvl(adj.tax_adjusted,0) br_adj_tax_amt ,
444: nvl(adj.freight_adjusted,0) br_adj_frt_amt ,
445: nvl(adj.receivables_charges_adjusted,0) br_adj_chrg_amt
446: FROM ra_customer_trx_lines ctl,
447: ar_adjustments adj,
448: ra_customer_trx ct
449: WHERE ctl.customer_trx_id = p_customer_trx_id
450: AND ctl.br_adjustment_id = adj.adjustment_id

Line 740: from3_stmt VARCHAR2(150) := 'from ra_customer_trx_lines ctl,

736: ard.tax_group_code_id tax_group_code_id,
737: ard.tax_code_id tax_code_id,
738: ard.code_combination_id code_combination_id';
739:
740: from3_stmt VARCHAR2(150) := 'from ra_customer_trx_lines ctl,
741: ar_distributions ard
742: where ';
743:
744: where3_stmt VARCHAR2(3000) := ' ctl.br_ref_customer_trx_id = :p_customer_trx_id

Line 843: --from3_mrc_stmt VARCHAR2(150) := ' from ra_customer_trx_lines ctl,

839: --from2_mrc_stmt VARCHAR2(150) := ' from ar_mc_distributions_all ard,
840: -- ar_adjustments adj
841: -- where ';
842:
843: --from3_mrc_stmt VARCHAR2(150) := ' from ra_customer_trx_lines ctl,
844: -- ar_mc_distributions_all ard
845: -- where ';
846:
847: --from4_mrc_stmt VARCHAR2(100) := ' from ar_mc_distributions_all ard

Line 1057: from ra_customer_trx_lines

1053: where exists( select 'x'
1054: from ar_payment_schedules ps
1055: where ps.customer_trx_id in (
1056: select customer_trx_id
1057: from ra_customer_trx_lines
1058: start with br_ref_customer_trx_id = p_customer_trx_id
1059: connect by prior customer_trx_id = br_ref_customer_trx_id
1060: )
1061: and ps.status = 'OP'

Line 1570: FROM ra_customer_trx_lines ctl,

1566: nvl(adj.line_adjusted,0) br_adj_line_amt ,
1567: nvl(adj.tax_adjusted,0) br_adj_tax_amt ,
1568: nvl(adj.freight_adjusted,0) br_adj_frt_amt ,
1569: nvl(adj.receivables_charges_adjusted,0) br_adj_chrg_amt
1570: FROM ra_customer_trx_lines ctl,
1571: ar_adjustments adj,
1572: ra_customer_trx ct
1573: WHERE ctl.customer_trx_id = p_customer_trx_id
1574: AND ctl.br_adjustment_id = adj.adjustment_id

Line 2264: ra_customer_trx_lines ctl,

2260: p_ae_sys_rec.base_min_acc_unit),
2261: '')) taxable_acctd_amount
2262: FROM ra_customer_trx ct ,
2263: ra_cust_trx_line_gl_dist gld,
2264: ra_customer_trx_lines ctl,
2265: ra_customer_trx_lines ctl1
2266: where ct.customer_trx_id = p_customer_trx_id
2267: and p_calling_point IN ('TRAN', 'BLTR')
2268: and ct.customer_trx_id = gld.customer_trx_id

Line 2265: ra_customer_trx_lines ctl1

2261: '')) taxable_acctd_amount
2262: FROM ra_customer_trx ct ,
2263: ra_cust_trx_line_gl_dist gld,
2264: ra_customer_trx_lines ctl,
2265: ra_customer_trx_lines ctl1
2266: where ct.customer_trx_id = p_customer_trx_id
2267: and p_calling_point IN ('TRAN', 'BLTR')
2268: and ct.customer_trx_id = gld.customer_trx_id
2269: and gld.customer_trx_id = ctl.customer_trx_id

Line 2276: from ra_customer_trx_lines ctl2

2272: and gld.collected_tax_ccid IS NOT NULL --deferred tax lines only
2273: and gld.account_set_flag = 'N'
2274: and ctl.link_to_cust_trx_line_id = ctl1.customer_trx_line_id --outer join not required here
2275: and not exists (select 'x'
2276: from ra_customer_trx_lines ctl2
2277: where ctl2.customer_trx_id = p_customer_trx_id
2278: and p_calling_point IN ('TRAN', 'BLTR')
2279: and ctl2.autorule_complete_flag = 'N')
2280: group by ctl.customer_trx_line_id ,

Line 2381: from ra_customer_trx_lines ctl,

2377: sum(nvl(ard.taxable_entered_dr,0) * -1 +
2378: nvl(ard.taxable_entered_cr,0)) taxable_amount ,
2379: sum(nvl(ard.taxable_accounted_dr,0) * -1 +
2380: nvl(ard.taxable_accounted_cr,0)) taxable_acctd_amount
2381: from ra_customer_trx_lines ctl,
2382: ar_distributions ard
2383: where p_ae_sys_rec.sob_type = 'P'
2384: and ctl.br_ref_customer_trx_id = p_customer_trx_id
2385: and p_calling_point IN ('TRAN', 'BLTR')

Line 3533: ra_customer_trx_lines ctl

3529: --used - it is all vat tax id on TAX line type
3530: SELECT max(gld.collected_tax_ccid) ae_collected_tax_ccid
3531: INTO l_collected_ccid
3532: FROM ra_cust_trx_line_gl_dist gld,
3533: ra_customer_trx_lines ctl
3534: --ra_customer_trx_lines ctl1
3535: WHERE ctl.customer_trx_id = p_customer_trx_id
3536: AND gld.customer_trx_id = ctl.customer_trx_id
3537: AND gld.customer_trx_line_id = ctl.customer_trx_line_id

Line 3534: --ra_customer_trx_lines ctl1

3530: SELECT max(gld.collected_tax_ccid) ae_collected_tax_ccid
3531: INTO l_collected_ccid
3532: FROM ra_cust_trx_line_gl_dist gld,
3533: ra_customer_trx_lines ctl
3534: --ra_customer_trx_lines ctl1
3535: WHERE ctl.customer_trx_id = p_customer_trx_id
3536: AND gld.customer_trx_id = ctl.customer_trx_id
3537: AND gld.customer_trx_line_id = ctl.customer_trx_line_id
3538: AND gld.account_class = 'TAX'

Line 3549: from ra_customer_trx_lines ctl1

3545: AND ctl.vat_tax_id = nvl(p_tax_code_id,-999)
3546: --AND ctl.link_to_cust_trx_line_id = ctl1.customer_trx_line_id
3547: --AND ctl1.vat_tax_id = nvl(p_tax_group_code_id,ctl1.vat_tax_id)
3548: AND not exists (select 'x'
3549: from ra_customer_trx_lines ctl1
3550: where ctl1.customer_trx_id = p_customer_trx_id
3551: and ctl1.autorule_complete_flag = 'N');
3552:
3553: IF PG_DEBUG in ('Y', 'C') THEN