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_BAL_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 59: FROM ra_customer_trx_lines

55: IF ( p_extended_amount IS NULL )
56: THEN
57: SELECT extended_amount
58: INTO l_original_amount
59: FROM ra_customer_trx_lines
60: WHERE customer_trx_line_id = p_customer_trx_line_id;
61: ELSE l_original_amount := p_extended_amount;
62: END IF;
63: */

Line 69: FROM ra_customer_trx_lines

65: SELECT DECODE(line_type, 'LINE',
66: NVL(gross_extended_amount, extended_amount),
67: extended_amount)
68: INTO l_original_amount
69: FROM ra_customer_trx_lines
70: WHERE customer_trx_line_id = p_customer_trx_line_id;
71:
72:
73: /*-----------------------------------------------------+

Line 96: ra_customer_trx_lines ctl

92: ), 0
93: )
94: INTO l_net_amount
95: FROM ra_customer_trx ct,
96: ra_customer_trx_lines ctl
97: WHERE ctl.previous_customer_trx_line_id = p_customer_trx_line_id
98: AND ctl.customer_trx_id = ct.customer_trx_id;
99:
100: RETURN(l_net_amount);

Line 151: FROM ra_customer_trx_lines

147: SELECT NVL(
148: SUM( extended_amount ), 0
149: )
150: INTO l_credit_amount
151: FROM ra_customer_trx_lines
152: WHERE previous_customer_trx_line_id = p_prev_customer_trx_line_id;
153:
154: RETURN(l_credit_amount);
155: END IF;

Line 649: FROM ra_customer_trx_lines ctl,

645: ) -- freight_credited
646: INTO l_line_credits1,
647: l_tax_credits1,
648: l_freight_credits1
649: FROM ra_customer_trx_lines ctl,
650: ra_cust_trx_line_gl_dist rec,
651: ra_customer_trx ct
652: WHERE ct.customer_trx_id = ctl.customer_trx_id
653: AND ct.customer_trx_id = rec.customer_trx_id

Line 1025: ra_customer_trx_lines orig_ctl,

1021: l_freight_credits,
1022: l_total_credits,
1023: l_base_total_original
1024: FROM ra_cust_trx_line_gl_dist lgd,
1025: ra_customer_trx_lines orig_ctl,
1026: ra_customer_trx_lines ctl,
1027: ra_customer_trx ct
1028: WHERE (
1029: ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id

Line 1026: ra_customer_trx_lines ctl,

1022: l_total_credits,
1023: l_base_total_original
1024: FROM ra_cust_trx_line_gl_dist lgd,
1025: ra_customer_trx_lines orig_ctl,
1026: ra_customer_trx_lines ctl,
1027: ra_customer_trx ct
1028: WHERE (
1029: ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
1030: OR

Line 1904: ra_customer_trx_lines lines,

1900: l_currency_code,
1901: l_sub_inv_trx_type_id,
1902: l_allocate_t_f
1903: FROM hz_cust_accounts cust_acct,
1904: ra_customer_trx_lines lines,
1905: ra_customer_trx trx,
1906: ra_cust_trx_types type
1907: WHERE trx.customer_trx_id = p_customer_trx_id
1908: AND trx.cust_trx_type_id = type.cust_trx_type_id

Line 1958: ra_customer_trx_lines l

1954: NVL( SUM(NVL(i.promised_commitment_amount,
1955: i.amount)), 0)
1956: INTO l_commitment_bal
1957: FROM ra_interface_lines i,
1958: ra_customer_trx_lines l
1959: WHERE NVL(interface_status,
1960: 'A') <> 'P'
1961: AND (i.line_type = 'LINE'
1962: OR i.line_type = DECODE(l_allocate_t_f,'Y','FREIGHT','LINE'))

Line 2026: ra_customer_trx_lines line

2022: 0
2023: )
2024: INTO l_commitment_bal
2025: FROM ra_customer_trx trx,
2026: ra_customer_trx_lines line
2027: WHERE trx.customer_trx_id = line.customer_trx_id
2028: AND trx.previous_customer_trx_id = p_customer_trx_id
2029: AND trx.complete_flag = 'Y';
2030:

Line 2273: FROM RA_CUSTOMER_TRX_LINES

2269: INTO l_count
2270: from ar_activity_details
2271: WHERE customer_trx_line_id in
2272: (SELECT customer_trx_line_id
2273: FROM RA_CUSTOMER_TRX_LINES
2274: WHERE customer_trx_id = p_customer_trx_id)
2275: and nvl(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'; -- bug 7241111
2276:
2277: IF ( l_count > 0) THEN

Line 2434: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;

2430: l_base_curr_code fnd_currencies.currency_code%type;
2431: l_base_precision fnd_currencies.precision%type;
2432: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2433:
2434: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;
2435: BEGIN
2436:
2437: /* initialize the items */
2438:

Line 2468: from ra_customer_Trx_lines

2464: IF (p_line_num IS NOT NULL) THEN
2465:
2466: select customer_Trx_line_id
2467: into l_customer_trx_line_id
2468: from ra_customer_Trx_lines
2469: where line_number = p_line_num
2470: and line_type = 'LINE'
2471: and customer_trx_id = p_customer_trx_id;
2472:

Line 2493: ra_customer_trx_lines lines

2489: INTO l_line_original,
2490: l_tax_original,
2491: l_freight_original
2492: from ra_customer_trx ct,
2493: ra_customer_trx_lines lines
2494: where (lines.customer_Trx_line_id = l_customer_trx_line_id or
2495: lines.link_to_cust_trx_line_id = l_customer_trx_line_id)
2496: and ct.customer_Trx_id = lines.customer_trx_id
2497: and ct.customer_trx_id = p_customer_trx_id;

Line 2548: ra_customer_trx_lines line

2544: INTO
2545: l_charges_receipts,
2546: l_freight_discount
2547: FROM AR_ACTIVITY_DETAILS act,
2548: ra_customer_trx_lines line
2549: WHERE line.customer_Trx_id = p_customer_trx_id
2550: and line.line_number = p_line_num
2551: and line.line_type = 'LINE'
2552: and nvl(act.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- bug 7241111

Line 2562: ra_customer_trx_lines ctl

2558: INTO
2559: l_freight_receipts,
2560: l_base_freight_receipts
2561: FROM ar_distributions ard,
2562: ra_customer_trx_lines ctl
2563: WHERE ard.source_table = 'RA'
2564: AND ard.source_id in (select receivable_application_id
2565: from ar_receivable_applications
2566: where status = 'APP' and

Line 2663: ra_customer_trx_lines lines

2659: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2660: INTO l_tax_adjustments,
2661: l_base_tax_adjustments
2662: from ar_distributions dist,
2663: ra_customer_trx_lines lines
2664: where lines.link_to_cust_trx_line_id = l_customer_trx_line_id
2665: and lines.line_type = 'TAX'
2666: and dist.ref_customer_trx_line_id = lines.customer_trx_line_id
2667: and dist.source_table = 'ADJ'

Line 2676: ra_customer_trx_lines lines

2672: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2673: INTO l_freight_adjustments,
2674: l_base_freight_adjustments
2675: from ar_distributions dist,
2676: ra_customer_trx_lines lines
2677: where lines.link_to_cust_trx_line_id = l_customer_trx_line_id
2678: and dist.ref_customer_trx_line_id = lines.link_to_cust_trx_line_id
2679: and lines.line_type = 'FREIGHT'
2680: and dist.source_table = 'ADJ'