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

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

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

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

Line 1583: drawee_site_use_id ra_customer_trx.drawee_site_use_id%TYPE,

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

Line 1600: l_cust_inv_rec ra_customer_trx%ROWTYPE;

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

Line 2223: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

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

Line 2261: FROM ra_customer_trx ct ,

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

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

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

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: