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.

[Home] [Help]

APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 84: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS

80: SELECT name
81: FROM ra_cust_trx_types
82: WHERE cust_trx_type_id = cv_settlement_type_id;
83:
84: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS
85: SELECT trx_number
86: FROM ar_payment_schedules
87: WHERE payment_schedule_id = cv_settlement_type_id;
88:

Line 86: FROM ar_payment_schedules

82: WHERE cust_trx_type_id = cv_settlement_type_id;
83:
84: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS
85: SELECT trx_number
86: FROM ar_payment_schedules
87: WHERE payment_schedule_id = cv_settlement_type_id;
88:
89: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS
90: SELECT name

Line 151: OPEN csr_ar_payment_schedules (p_settlement_type_id);

147: IF((l_claim_class = 'DEDUCTION' AND p_payment_method ='WRITE_OFF' AND
148: p_settlement_type_id is not null AND p_settlement_type_id = -3)
149: OR (l_claim_class = 'OVERPAYMENT' AND (p_payment_method ='WRITE_OFF' OR p_payment_method = 'ON_ACCT_CREDIT')))THEN
150:
151: OPEN csr_ar_payment_schedules (p_settlement_type_id);
152: FETCH csr_ar_payment_schedules INTO x_settlement_type;
153: CLOSE csr_ar_payment_schedules;
154: ELSE
155: OPEN csr_ar_receivables_trx (p_settlement_type_id);

Line 152: FETCH csr_ar_payment_schedules INTO x_settlement_type;

148: p_settlement_type_id is not null AND p_settlement_type_id = -3)
149: OR (l_claim_class = 'OVERPAYMENT' AND (p_payment_method ='WRITE_OFF' OR p_payment_method = 'ON_ACCT_CREDIT')))THEN
150:
151: OPEN csr_ar_payment_schedules (p_settlement_type_id);
152: FETCH csr_ar_payment_schedules INTO x_settlement_type;
153: CLOSE csr_ar_payment_schedules;
154: ELSE
155: OPEN csr_ar_receivables_trx (p_settlement_type_id);
156: FETCH csr_ar_receivables_trx INTO x_settlement_type;

Line 153: CLOSE csr_ar_payment_schedules;

149: OR (l_claim_class = 'OVERPAYMENT' AND (p_payment_method ='WRITE_OFF' OR p_payment_method = 'ON_ACCT_CREDIT')))THEN
150:
151: OPEN csr_ar_payment_schedules (p_settlement_type_id);
152: FETCH csr_ar_payment_schedules INTO x_settlement_type;
153: CLOSE csr_ar_payment_schedules;
154: ELSE
155: OPEN csr_ar_receivables_trx (p_settlement_type_id);
156: FETCH csr_ar_receivables_trx INTO x_settlement_type;
157: CLOSE csr_ar_receivables_trx;

Line 301: , ar_payment_schedules pay

297: , rec.apply_date
298: , rec.amount_applied
299: , pay.status
300: FROM ar_receivable_applications rec
301: , ar_payment_schedules pay
302: WHERE rec.cash_receipt_id = cv_cash_receipt_id
303: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
304: AND pay.customer_trx_id = cv_customer_trx_id
305: AND rec.display = 'Y';

Line 315: FROM ar_payment_schedules pay

311: , pay.trx_number
312: , pay.trx_date --?? verify
313: , pay.amount_applied
314: , pay.status
315: FROM ar_payment_schedules pay
316: WHERE pay.customer_trx_id = cv_customer_trx_id;
317:
318: -- Chargeback
319: CURSOR csr_chargeback(cv_customer_trx_id IN NUMBER) IS

Line 328: , ar_payment_schedules pay

324: , sum(cust_lines.extended_amount) --"settlement_amount"
325: , pay.status --"status_code"
326: FROM ra_customer_trx cust
327: , ra_customer_trx_lines cust_lines
328: , ar_payment_schedules pay
329: WHERE cust.customer_trx_id = cv_customer_trx_id
330: AND cust.customer_trx_id = pay.customer_trx_id
331: AND cust.customer_trx_id = cust_lines.customer_trx_id
332: AND pay.customer_trx_id = cust_lines.customer_trx_id -- fix for bug 4897546

Line 350: , ar_payment_schedules pay

346: , rec.apply_date
347: , rec.amount_applied
348: , pay.status
349: FROM ar_receivable_applications rec
350: , ar_payment_schedules pay
351: WHERE rec.cash_receipt_id = cv_cash_receipt_id
352: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
353: AND pay.payment_schedule_id = -1
354: AND rec.display='Y'

Line 366: , ar_payment_schedules pay

362: , rec.apply_date
363: , rec.amount_applied
364: , pay.status
365: FROM ar_receivable_applications rec
366: , ar_payment_schedules pay
367: WHERE rec.cash_receipt_id = cv_cash_receipt_id
368: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
369: AND pay.payment_schedule_id = -3
370: AND rec.display='Y'

Line 382: , ar_payment_schedules pay

378: , adj.apply_date --"settlement_date"
379: , adj.amount --"settlement_amount"
380: , pay.status --"status_code"
381: FROM ar_adjustments adj
382: , ar_payment_schedules pay
383: WHERE adj.payment_schedule_id = pay.payment_schedule_id
384: AND adj.adjustment_id = cv_adjust_id;
385:
386: -- Find out claim object version number

Line 400: FROM ar_payment_schedules pay

396: , pay.trx_number
397: , sysdate
398: , (oc.amount_settled * -1)
399: , pay.status
400: FROM ar_payment_schedules pay
401: , ozf_claims oc
402: WHERE pay.customer_trx_id = oc.payment_reference_id
403: AND oc.claim_id = cv_claim_id;
404:

Line 428: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS

424: SELECT name
425: FROM ra_cust_trx_types
426: WHERE cust_trx_type_id = cv_settlement_type_id;
427:
428: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS
429: SELECT trx_number
430: FROM ar_payment_schedules
431: WHERE payment_schedule_id = cv_settlement_type_id;
432:

Line 430: FROM ar_payment_schedules

426: WHERE cust_trx_type_id = cv_settlement_type_id;
427:
428: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS
429: SELECT trx_number
430: FROM ar_payment_schedules
431: WHERE payment_schedule_id = cv_settlement_type_id;
432:
433: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS
434: SELECT name

Line 1629: ar_payment_schedules pay

1625: , pay.amount_due_original --"settlement_amount"
1626: , pay.status --"status_code"
1627: FROM ra_customer_trx cust,
1628: ra_customer_trx_lines lines,
1629: ar_payment_schedules pay
1630: where cust.customer_trx_id = lines.customer_trx_id
1631: and cust.customer_trx_id = pay.customer_trx_id
1632: and cust.complete_flag = 'Y'
1633: AND lines.interface_line_attribute2 = cv_claim_id

Line 1644: from ar_payment_schedules pay , ( select distinct customer_trx_id

1640: , pay.cust_trx_type_id --"settlement_type_id"
1641: , pay.trx_number --"settlement_number"
1642: , pay.trx_date --"settlement_date"
1643: , sum(pay.amount_due_original) --"settlement_amount"
1644: from ar_payment_schedules pay , ( select distinct customer_trx_id
1645: from ozf_claim_lines ln , ra_customer_trx_lines cm_line
1646: where cm_line.line_type = 'LINE'
1647: and cm_line.interface_line_context = 'ORDER ENTRY' --added filter for 4940650
1648: and cm_line.interface_line_attribute6 = to_char(ln.payment_reference_id) -- order line id

Line 1664: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS

1660: SELECT name
1661: FROM ra_cust_trx_types
1662: WHERE cust_trx_type_id = cv_settlement_type_id;
1663:
1664: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS
1665: SELECT trx_number
1666: FROM ar_payment_schedules
1667: WHERE payment_schedule_id = cv_settlement_type_id;
1668:

Line 1666: FROM ar_payment_schedules

1662: WHERE cust_trx_type_id = cv_settlement_type_id;
1663:
1664: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS
1665: SELECT trx_number
1666: FROM ar_payment_schedules
1667: WHERE payment_schedule_id = cv_settlement_type_id;
1668:
1669: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS
1670: SELECT name

Line 2712: , ar_payment_schedules pay

2708: , adj.apply_date --"settlement_date"
2709: , adj.amount --"settlement_amount"
2710: , pay.status --"status_code"
2711: FROM ar_adjustments adj
2712: , ar_payment_schedules pay
2713: WHERE adj.payment_schedule_id = pay.payment_schedule_id
2714: AND adj.adjustment_id = cv_adjust_id;
2715:
2716: BEGIN

Line 2877: from ar_payment_schedules ps, ra_customer_trx trx , ( select distinct customer_trx_id

2873: select sum(nvl(amount_line_items_original, 0))
2874: , sum(nvl(tax_original,0))
2875: , sum(nvl(freight_original,0))
2876: , previous_customer_trx_id
2877: from ar_payment_schedules ps, ra_customer_trx trx , ( select distinct customer_trx_id
2878: from ozf_claim_lines ln , ra_customer_trx_lines cm_line
2879: where cm_line.line_type = 'LINE'
2880: and cm_line.interface_line_context = 'ORDER ENTRY' --added filter for 4953844
2881: and cm_line.interface_line_attribute6 = to_char(ln.payment_reference_id)

Line 3857: FROM ar_payment_schedules

3853: CURSOR csr_cm_dm_total_amount(cv_customer_trx_id IN NUMBER) IS
3854: SELECT NVL(SUM(amount_line_items_original), 0)
3855: , NVL(SUM(tax_original), 0)
3856: , NVL(SUM(freight_original), 0)
3857: FROM ar_payment_schedules
3858: WHERE customer_trx_id = cv_customer_trx_id;
3859:
3860: CURSOR csr_sum_line_amount(cv_claim_id IN NUMBER) IS
3861: SELECT SUM(claim_currency_amount)