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

Line 47: PROCEDURE Check_Entry(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

43: | Private Procedure/Function prototypes |
44: +============================================================================*/
45: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
46:
47: PROCEDURE Check_Entry(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
48: p_type IN VARCHAR2,
49: p_required OUT NOCOPY BOOLEAN );
50:
51: PROCEDURE Check_all_bills_closed(p_customer_trx_id IN NUMBER ,

Line 89: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

85: p_mode IN VARCHAR2 ,
86: p_ae_doc_rec IN ae_doc_rec_type ,
87: p_ae_event_rec IN ae_event_rec_type ,
88: p_ae_sys_rec IN ae_sys_rec_type ,
89: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
90: p_customer_trx_id IN NUMBER ,
91: p_br_cust_trx_line_id IN NUMBER ,
92: p_calling_point IN VARCHAR2 ,
93: p_pay_class IN VARCHAR2 ,

Line 111: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

107: p_mode IN VARCHAR2 ,
108: p_ae_doc_rec IN ae_doc_rec_type ,
109: p_ae_event_rec IN ae_event_rec_type ,
110: p_ae_sys_rec IN ae_sys_rec_type ,
111: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
112: p_br_cust_trx_line_id IN NUMBER ,
113: p_customer_trx_id IN NUMBER ,
114: p_simul_app IN VARCHAR2 ,
115: p_calling_point IN VARCHAR2 ,

Line 134: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,

130: p_tax_group_code_id IN NUMBER,
131: p_tax_code_id IN NUMBER,
132: p_code_combination_id IN NUMBER,
133: p_ae_doc_rec IN ae_doc_rec_type,
134: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,
135: p_calling_point IN VARCHAR2,
136: p_ae_line_rec IN OUT NOCOPY ae_line_rec_type);
137:
138: PROCEDURE Build_Tax (p_customer_trx_id IN NUMBER,

Line 173: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,

169: PROCEDURE Reconcile_trx_br(
170: p_mode IN VARCHAR2,
171: p_ae_doc_rec IN ae_doc_rec_type,
172: p_ae_event_rec IN ae_event_rec_type,
173: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,
174: p_activity_cust_trx_id IN NUMBER,
175: p_activity_amt IN NUMBER,
176: p_activity_acctd_amt IN NUMBER,
177: p_call_num IN NUMBER,

Line 328: PROCEDURE Check_Entry(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

324: | p_type IN Transaction or Bill
325: | p_required OUT NOCOPY Flag indicates whether tax processing
326: | is required
327: * ======================================================================*/
328: PROCEDURE Check_Entry(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
329: p_type IN VARCHAR2 ,
330: p_required OUT NOCOPY BOOLEAN ) IS
331:
332: l_def_flag VARCHAR2(1);

Line 424: l_cust_inv_rec ra_customer_trx%ROWTYPE;

420: p_calling_point IN VARCHAR2 ,
421: p_g_ae_ctr IN OUT NOCOPY BINARY_INTEGER ,
422: p_g_ae_line_tbl IN OUT NOCOPY ae_line_tbl_type ) IS
423:
424: l_cust_inv_rec ra_customer_trx%ROWTYPE;
425:
426: CURSOR get_assignments(p_customer_trx_id IN NUMBER) is
427: SELECT ctl.customer_trx_id br_cust_trx_id ,
428: ctl.customer_trx_line_id br_customer_trx_line_id ,

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 448: ra_customer_trx ct

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
451: AND ct.customer_trx_id = ctl.br_ref_customer_trx_id
452: AND adj.status = 'A'

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 1111: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

1107: p_mode IN VARCHAR2 ,
1108: p_ae_doc_rec IN ae_doc_rec_type ,
1109: p_ae_event_rec IN ae_event_rec_type ,
1110: p_ae_sys_rec IN ae_sys_rec_type ,
1111: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
1112: p_customer_trx_id IN NUMBER ,
1113: p_br_cust_trx_line_id IN NUMBER ,
1114: p_calling_point IN VARCHAR2 ,
1115: p_pay_class IN VARCHAR2 ,

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 1572: ra_customer_trx ct

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
1575: AND ct.customer_trx_id = ctl.br_ref_customer_trx_id
1576: AND adj.status = 'A'

Line 1584: drawee_site_use_id ra_customer_trx.drawee_site_use_id%TYPE,

1580: br_cust_trx_id NUMBER,
1581: br_customer_trx_line_id NUMBER,
1582: br_ref_customer_trx_id NUMBER,
1583: br_ref_payment_schedule_id NUMBER,
1584: drawee_site_use_id ra_customer_trx.drawee_site_use_id%TYPE,
1585: br_adj_id NUMBER,
1586: br_adj_amt NUMBER,
1587: br_adj_acctd_amt NUMBER,
1588: br_adj_line_amt NUMBER,

Line 1601: l_cust_inv_rec ra_customer_trx%ROWTYPE;

1597:
1598: TYPE l_br_tbl_type IS TABLE of l_br_rec_type
1599: INDEX BY BINARY_INTEGER;
1600:
1601: l_cust_inv_rec ra_customer_trx%ROWTYPE;
1602:
1603: l_assn_ctr BINARY_INTEGER := 0;
1604:
1605: l_pay_tbl g_pay_tbl_type;

Line 2224: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

2220: p_mode IN VARCHAR2 ,
2221: p_ae_doc_rec IN ae_doc_rec_type ,
2222: p_ae_event_rec IN ae_event_rec_type ,
2223: p_ae_sys_rec IN ae_sys_rec_type ,
2224: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
2225: p_br_cust_trx_line_id IN NUMBER ,
2226: p_customer_trx_id IN NUMBER ,
2227: p_simul_app IN VARCHAR2 ,
2228: p_calling_point IN VARCHAR2 ,

Line 2262: FROM ra_customer_trx ct ,

2258: p_cust_inv_rec.exchange_rate ,
2259: p_ae_sys_rec.base_precision ,
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

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 3392: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,

3388: p_tax_group_code_id IN NUMBER,
3389: p_tax_code_id IN NUMBER,
3390: p_code_combination_id IN NUMBER,
3391: p_ae_doc_rec IN ae_doc_rec_type,
3392: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,
3393: p_calling_point IN VARCHAR2,
3394: p_ae_line_rec IN OUT NOCOPY ae_line_rec_type ) IS
3395:
3396: BEGIN

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