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 1055: from ra_customer_trx_lines rct

1051: into p_all_br_closed
1052: from dual
1053: where exists ( select /*+ ordered leading(rc.rct) use_nl(rc.rct ps)*/ 'x'
1054: from ( select customer_trx_id
1055: from ra_customer_trx_lines rct
1056: start with br_ref_customer_trx_id = p_customer_trx_id
1057: connect by prior customer_trx_id = br_ref_customer_trx_id
1058: ) rc, ar_payment_schedules ps
1059: where ps.customer_trx_id = rc.customer_trx_id

Line 1569: FROM ra_customer_trx_lines ctl,

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

Line 2263: ra_customer_trx_lines ctl,

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

Line 2264: ra_customer_trx_lines ctl1

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

Line 2275: from ra_customer_trx_lines ctl2

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

Line 2380: from ra_customer_trx_lines ctl,

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

Line 3532: ra_customer_trx_lines ctl

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

Line 3533: --ra_customer_trx_lines ctl1

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

Line 3548: from ra_customer_trx_lines ctl1

3544: AND ctl.vat_tax_id = nvl(p_tax_code_id,-999)
3545: --AND ctl.link_to_cust_trx_line_id = ctl1.customer_trx_line_id
3546: --AND ctl1.vat_tax_id = nvl(p_tax_group_code_id,ctl1.vat_tax_id)
3547: AND not exists (select 'x'
3548: from ra_customer_trx_lines ctl1
3549: where ctl1.customer_trx_id = p_customer_trx_id
3550: and ctl1.autorule_complete_flag = 'N');
3551: --bug7484223
3552: IF l_collected_ccid IS NULL then

Line 3562: ra_customer_trx_lines ctl

3558:
3559: SELECT max(gld.collected_tax_ccid) ae_collected_tax_ccid
3560: INTO l_collected_ccid
3561: FROM ra_cust_trx_line_gl_dist gld,
3562: ra_customer_trx_lines ctl
3563: --ra_customer_trx_lines ctl1
3564: WHERE ctl.customer_trx_id = p_customer_trx_id
3565: AND gld.customer_trx_id = ctl.customer_trx_id
3566: AND gld.customer_trx_line_id = ctl.customer_trx_line_id

Line 3563: --ra_customer_trx_lines ctl1

3559: SELECT max(gld.collected_tax_ccid) ae_collected_tax_ccid
3560: INTO l_collected_ccid
3561: FROM ra_cust_trx_line_gl_dist gld,
3562: ra_customer_trx_lines ctl
3563: --ra_customer_trx_lines ctl1
3564: WHERE ctl.customer_trx_id = p_customer_trx_id
3565: AND gld.customer_trx_id = ctl.customer_trx_id
3566: AND gld.customer_trx_line_id = ctl.customer_trx_line_id
3567: AND gld.account_class = 'TAX'

Line 3578: from ra_customer_trx_lines ctl1

3574: AND ctl.vat_tax_id = nvl(p_tax_code_id,-999)
3575: --AND ctl.link_to_cust_trx_line_id = ctl1.customer_trx_line_id
3576: --AND ctl1.vat_tax_id = nvl(p_tax_group_code_id,ctl1.vat_tax_id)
3577: AND not exists (select 'x'
3578: from ra_customer_trx_lines ctl1
3579: where ctl1.customer_trx_id = p_customer_trx_id
3580: and ctl1.autorule_complete_flag = 'N');
3581: END IF;
3582: