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.AR_ARXCCS_XMLP_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 243: from ar_payment_schedules

239: decode(exchange_rate,
240: NULL, '*', ' '))), ' ')
241: into l_aging_credit,
242: l_aging_convert_credit
243: from ar_payment_schedules
244: where customer_id = customer_id
245: and customer_site_use_id = site_use_id
246: and invoice_currency_code = Currency_Bucket
247: and class = 'CM'

Line 265: FROM AR_PAYMENT_SCHEDULES

261: DECODE(INVOICE_CURRENCY_CODE, functional_currency, ' ',
262: DECODE(EXCHANGE_RATE, NULL, '*', ' ')), ' ')), ' ') CCONV
263: INTO l_aging_in_collection,
264: l_aging_convert_collection
265: FROM AR_PAYMENT_SCHEDULES
266: WHERE CUSTOMER_ID = CUSTOMER_ID
267: AND CUSTOMER_SITE_USE_ID = site_use_id
268: AND INVOICE_CURRENCY_CODE = Currency_Bucket
269: AND STATUS = 'OP'

Line 293: FROM AR_PAYMENT_SCHEDULES

289: SELECT NVL(AMOUNT_DUE_ORIGINAL, 0),
290: DECODE(INVOICE_CURRENCY_CODE, functional_currency, ' ',
291: DECODE(EXCHANGE_RATE, NULL, '*', ' ')),
292: TRX_DATE
293: FROM AR_PAYMENT_SCHEDULES
294: WHERE CUSTOMER_ID = CUSTOMER_ID
295: AND CUSTOMER_SITE_USE_ID = SITE_USE_ID
296: AND INVOICE_CURRENCY_CODE = Currency_Bucket
297: AND CLASS NOT IN ('CM', 'PMT')

Line 517: from ar_payment_schedules

513: l_ytd_convert_sales,
514: l_ytd_sales_count,
515: d_ytd_finance_charge_amount,
516: d_ytd_finance_charge_convert
517: from ar_payment_schedules
518: --where ar_payment_schedules.customer_id = customer_id
519: where ar_payment_schedules.customer_id = customer_id_1
520: and customer_site_use_id = site_use_id
521: and invoice_currency_code = Currency_Bucket

Line 518: --where ar_payment_schedules.customer_id = customer_id

514: l_ytd_sales_count,
515: d_ytd_finance_charge_amount,
516: d_ytd_finance_charge_convert
517: from ar_payment_schedules
518: --where ar_payment_schedules.customer_id = customer_id
519: where ar_payment_schedules.customer_id = customer_id_1
520: and customer_site_use_id = site_use_id
521: and invoice_currency_code = Currency_Bucket
522: and ar_payment_schedules.trx_date between

Line 519: where ar_payment_schedules.customer_id = customer_id_1

515: d_ytd_finance_charge_amount,
516: d_ytd_finance_charge_convert
517: from ar_payment_schedules
518: --where ar_payment_schedules.customer_id = customer_id
519: where ar_payment_schedules.customer_id = customer_id_1
520: and customer_site_use_id = site_use_id
521: and invoice_currency_code = Currency_Bucket
522: and ar_payment_schedules.trx_date between
523: add_months(sysdate, -12) and sysdate

Line 522: and ar_payment_schedules.trx_date between

518: --where ar_payment_schedules.customer_id = customer_id
519: where ar_payment_schedules.customer_id = customer_id_1
520: and customer_site_use_id = site_use_id
521: and invoice_currency_code = Currency_Bucket
522: and ar_payment_schedules.trx_date between
523: add_months(sysdate, -12) and sysdate
524: and ar_payment_schedules.class not in ('CM', 'PMT')
525: ;
526:

Line 524: and ar_payment_schedules.class not in ('CM', 'PMT')

520: and customer_site_use_id = site_use_id
521: and invoice_currency_code = Currency_Bucket
522: and ar_payment_schedules.trx_date between
523: add_months(sysdate, -12) and sysdate
524: and ar_payment_schedules.class not in ('CM', 'PMT')
525: ;
526:
527: select nvl(sum(-amount), 0) payment_amount,
528: nvl(max(decode(currency_code, functional_currency, ' ',

Line 545: nvl(max(decode(ar_payment_schedules.invoice_currency_code,

541: and ar_cash_receipts.status <> 'REV'
542: and nvl(ar_cash_receipts.confirmed_flag,'Y') = 'Y'
543: ;
544: select nvl(sum(amount_due_original ), 0),
545: nvl(max(decode(ar_payment_schedules.invoice_currency_code,
546: functional_currency, ' ',
547: decode(ar_payment_schedules.exchange_rate,
548: NULL, '*', ' '))), ' '),
549: count(customer_trx_id)

Line 547: decode(ar_payment_schedules.exchange_rate,

543: ;
544: select nvl(sum(amount_due_original ), 0),
545: nvl(max(decode(ar_payment_schedules.invoice_currency_code,
546: functional_currency, ' ',
547: decode(ar_payment_schedules.exchange_rate,
548: NULL, '*', ' '))), ' '),
549: count(customer_trx_id)
550: into l_ytd_credit_amount,
551: l_ytd_convert_credit,

Line 553: from ar_payment_schedules

549: count(customer_trx_id)
550: into l_ytd_credit_amount,
551: l_ytd_convert_credit,
552: l_ytd_credit_count
553: from ar_payment_schedules
554: where ar_payment_schedules.trx_date between add_months(sysdate,-12) and
555: sysdate
556: --and ar_payment_schedules.customer_id = customer_id
557: and ar_payment_schedules.customer_id = customer_id_1

Line 554: where ar_payment_schedules.trx_date between add_months(sysdate,-12) and

550: into l_ytd_credit_amount,
551: l_ytd_convert_credit,
552: l_ytd_credit_count
553: from ar_payment_schedules
554: where ar_payment_schedules.trx_date between add_months(sysdate,-12) and
555: sysdate
556: --and ar_payment_schedules.customer_id = customer_id
557: and ar_payment_schedules.customer_id = customer_id_1
558: and customer_site_use_id = site_use_id

Line 556: --and ar_payment_schedules.customer_id = customer_id

552: l_ytd_credit_count
553: from ar_payment_schedules
554: where ar_payment_schedules.trx_date between add_months(sysdate,-12) and
555: sysdate
556: --and ar_payment_schedules.customer_id = customer_id
557: and ar_payment_schedules.customer_id = customer_id_1
558: and customer_site_use_id = site_use_id
559: and invoice_currency_code = Currency_Bucket
560: and ar_payment_schedules.class = 'CM'

Line 557: and ar_payment_schedules.customer_id = customer_id_1

553: from ar_payment_schedules
554: where ar_payment_schedules.trx_date between add_months(sysdate,-12) and
555: sysdate
556: --and ar_payment_schedules.customer_id = customer_id
557: and ar_payment_schedules.customer_id = customer_id_1
558: and customer_site_use_id = site_use_id
559: and invoice_currency_code = Currency_Bucket
560: and ar_payment_schedules.class = 'CM'
561: ;

Line 560: and ar_payment_schedules.class = 'CM'

556: --and ar_payment_schedules.customer_id = customer_id
557: and ar_payment_schedules.customer_id = customer_id_1
558: and customer_site_use_id = site_use_id
559: and invoice_currency_code = Currency_Bucket
560: and ar_payment_schedules.class = 'CM'
561: ;
562:
563: select nvl(sum(amount), 0),
564: nvl(max(decode(ar_payment_schedules.invoice_currency_code,

Line 564: nvl(max(decode(ar_payment_schedules.invoice_currency_code,

560: and ar_payment_schedules.class = 'CM'
561: ;
562:
563: select nvl(sum(amount), 0),
564: nvl(max(decode(ar_payment_schedules.invoice_currency_code,
565: functional_currency, ' ',
566: decode(ar_payment_schedules.exchange_rate,
567: NULL, '*', ' '))), ' '),
568: count(adjustment_id)

Line 566: decode(ar_payment_schedules.exchange_rate,

562:
563: select nvl(sum(amount), 0),
564: nvl(max(decode(ar_payment_schedules.invoice_currency_code,
565: functional_currency, ' ',
566: decode(ar_payment_schedules.exchange_rate,
567: NULL, '*', ' '))), ' '),
568: count(adjustment_id)
569: into l_ytd_finance_charge_amount,
570: l_ytd_convert_finance_charge,

Line 574: ar_payment_schedules

570: l_ytd_convert_finance_charge,
571: l_ytd_finance_charge_count
572: from ar_adjustments,
573: ar_receivables_trx,
574: ar_payment_schedules
575: where ar_adjustments.payment_schedule_id=
576: ar_payment_schedules.payment_schedule_id
577: and ar_payment_schedules.customer_site_use_id = site_use_id
578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket

Line 576: ar_payment_schedules.payment_schedule_id

572: from ar_adjustments,
573: ar_receivables_trx,
574: ar_payment_schedules
575: where ar_adjustments.payment_schedule_id=
576: ar_payment_schedules.payment_schedule_id
577: and ar_payment_schedules.customer_site_use_id = site_use_id
578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id
580: and ar_receivables_trx.type='FINCHRG'

Line 577: and ar_payment_schedules.customer_site_use_id = site_use_id

573: ar_receivables_trx,
574: ar_payment_schedules
575: where ar_adjustments.payment_schedule_id=
576: ar_payment_schedules.payment_schedule_id
577: and ar_payment_schedules.customer_site_use_id = site_use_id
578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id
580: and ar_receivables_trx.type='FINCHRG'
581: and ar_adjustments.apply_date between add_months(sysdate,-12) and sysdate

Line 578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket

574: ar_payment_schedules
575: where ar_adjustments.payment_schedule_id=
576: ar_payment_schedules.payment_schedule_id
577: and ar_payment_schedules.customer_site_use_id = site_use_id
578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id
580: and ar_receivables_trx.type='FINCHRG'
581: and ar_adjustments.apply_date between add_months(sysdate,-12) and sysdate
582: and nvl(ar_adjustments.postable,'Y')='Y'

Line 583: --and ar_payment_schedules.customer_id=customer_id

579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id
580: and ar_receivables_trx.type='FINCHRG'
581: and ar_adjustments.apply_date between add_months(sysdate,-12) and sysdate
582: and nvl(ar_adjustments.postable,'Y')='Y'
583: --and ar_payment_schedules.customer_id=customer_id
584: and ar_payment_schedules.customer_id=customer_id_1
585: ;
586:
587: select nvl(sum(ar_adjustments.amount), 0),

Line 584: and ar_payment_schedules.customer_id=customer_id_1

580: and ar_receivables_trx.type='FINCHRG'
581: and ar_adjustments.apply_date between add_months(sysdate,-12) and sysdate
582: and nvl(ar_adjustments.postable,'Y')='Y'
583: --and ar_payment_schedules.customer_id=customer_id
584: and ar_payment_schedules.customer_id=customer_id_1
585: ;
586:
587: select nvl(sum(ar_adjustments.amount), 0),
588: nvl(max(decode(ar_payment_schedules.invoice_currency_code,

Line 588: nvl(max(decode(ar_payment_schedules.invoice_currency_code,

584: and ar_payment_schedules.customer_id=customer_id_1
585: ;
586:
587: select nvl(sum(ar_adjustments.amount), 0),
588: nvl(max(decode(ar_payment_schedules.invoice_currency_code,
589: functional_currency, ' ',
590: decode(ar_payment_schedules.exchange_rate,
591: NULL, '*', ' '))), ' ')
592: into l_ytd_writeoff_amount,

Line 590: decode(ar_payment_schedules.exchange_rate,

586:
587: select nvl(sum(ar_adjustments.amount), 0),
588: nvl(max(decode(ar_payment_schedules.invoice_currency_code,
589: functional_currency, ' ',
590: decode(ar_payment_schedules.exchange_rate,
591: NULL, '*', ' '))), ' ')
592: into l_ytd_writeoff_amount,
593: l_ytd_convert_writeoff
594: from ar_adjustments,

Line 596: ar_payment_schedules

592: into l_ytd_writeoff_amount,
593: l_ytd_convert_writeoff
594: from ar_adjustments,
595: ar_lookups lk,
596: ar_payment_schedules
597: where ar_adjustments.reason_code
598: = lk.lookup_code(+)
599: and lk.lookup_code(+) = 'WRITE OFF'
600: and lk.lookup_type(+) = 'ADJUST_REASON'

Line 601: --and ar_payment_schedules.customer_id = customer_id

597: where ar_adjustments.reason_code
598: = lk.lookup_code(+)
599: and lk.lookup_code(+) = 'WRITE OFF'
600: and lk.lookup_type(+) = 'ADJUST_REASON'
601: --and ar_payment_schedules.customer_id = customer_id
602: and ar_payment_schedules.customer_id = customer_id_1
603: and ar_payment_schedules.customer_site_use_id = site_use_id
604: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
605: and ar_adjustments.payment_schedule_id =

Line 602: and ar_payment_schedules.customer_id = customer_id_1

598: = lk.lookup_code(+)
599: and lk.lookup_code(+) = 'WRITE OFF'
600: and lk.lookup_type(+) = 'ADJUST_REASON'
601: --and ar_payment_schedules.customer_id = customer_id
602: and ar_payment_schedules.customer_id = customer_id_1
603: and ar_payment_schedules.customer_site_use_id = site_use_id
604: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
605: and ar_adjustments.payment_schedule_id =
606: ar_payment_schedules.payment_schedule_id

Line 603: and ar_payment_schedules.customer_site_use_id = site_use_id

599: and lk.lookup_code(+) = 'WRITE OFF'
600: and lk.lookup_type(+) = 'ADJUST_REASON'
601: --and ar_payment_schedules.customer_id = customer_id
602: and ar_payment_schedules.customer_id = customer_id_1
603: and ar_payment_schedules.customer_site_use_id = site_use_id
604: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
605: and ar_adjustments.payment_schedule_id =
606: ar_payment_schedules.payment_schedule_id
607: and ar_adjustments.apply_date between

Line 604: and ar_payment_schedules.invoice_currency_code = Currency_Bucket

600: and lk.lookup_type(+) = 'ADJUST_REASON'
601: --and ar_payment_schedules.customer_id = customer_id
602: and ar_payment_schedules.customer_id = customer_id_1
603: and ar_payment_schedules.customer_site_use_id = site_use_id
604: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
605: and ar_adjustments.payment_schedule_id =
606: ar_payment_schedules.payment_schedule_id
607: and ar_adjustments.apply_date between
608: add_months(sysdate, -12) and sysdate

Line 606: ar_payment_schedules.payment_schedule_id

602: and ar_payment_schedules.customer_id = customer_id_1
603: and ar_payment_schedules.customer_site_use_id = site_use_id
604: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
605: and ar_adjustments.payment_schedule_id =
606: ar_payment_schedules.payment_schedule_id
607: and ar_adjustments.apply_date between
608: add_months(sysdate, -12) and sysdate
609: and nvl(ar_adjustments.postable, 'Y') = 'Y'
610: ;

Line 615: decode(ar_payment_schedules.invoice_currency_code,

611:
612: select nvl(sum(ar_receivable_applications.earned_discount_taken ), 0) earned,
613: nvl(max(decode(nvl(ar_receivable_applications.earned_discount_taken, 0),
614: 0, ' ',
615: decode(ar_payment_schedules.invoice_currency_code,
616: functional_currency, ' ',
617: decode(ar_payment_schedules.exchange_rate,
618: NULL, '*', ' ')))), ' ') earned_cvt,
619: nvl(sum(ar_receivable_applications.unearned_discount_taken), 0) unearned,

Line 617: decode(ar_payment_schedules.exchange_rate,

613: nvl(max(decode(nvl(ar_receivable_applications.earned_discount_taken, 0),
614: 0, ' ',
615: decode(ar_payment_schedules.invoice_currency_code,
616: functional_currency, ' ',
617: decode(ar_payment_schedules.exchange_rate,
618: NULL, '*', ' ')))), ' ') earned_cvt,
619: nvl(sum(ar_receivable_applications.unearned_discount_taken), 0) unearned,
620: nvl(max(decode(nvl(ar_receivable_applications.unearned_discount_taken, 0),
621: 0, ' ',

Line 622: decode(ar_payment_schedules.invoice_currency_code,

618: NULL, '*', ' ')))), ' ') earned_cvt,
619: nvl(sum(ar_receivable_applications.unearned_discount_taken), 0) unearned,
620: nvl(max(decode(nvl(ar_receivable_applications.unearned_discount_taken, 0),
621: 0, ' ',
622: decode(ar_payment_schedules.invoice_currency_code,
623: functional_currency, ' ',
624: decode(ar_payment_schedules.exchange_rate,
625: NULL, '*', ' ')))), ' ') unearned_cvt,
626: decode(count(ar_receivable_applications.apply_date), 0, 0,

Line 624: decode(ar_payment_schedules.exchange_rate,

620: nvl(max(decode(nvl(ar_receivable_applications.unearned_discount_taken, 0),
621: 0, ' ',
622: decode(ar_payment_schedules.invoice_currency_code,
623: functional_currency, ' ',
624: decode(ar_payment_schedules.exchange_rate,
625: NULL, '*', ' ')))), ' ') unearned_cvt,
626: decode(count(ar_receivable_applications.apply_date), 0, 0,
627: round(sum(ar_receivable_applications.apply_date -
628: ar_payment_schedules.trx_date) /

Line 628: ar_payment_schedules.trx_date) /

624: decode(ar_payment_schedules.exchange_rate,
625: NULL, '*', ' ')))), ' ') unearned_cvt,
626: decode(count(ar_receivable_applications.apply_date), 0, 0,
627: round(sum(ar_receivable_applications.apply_date -
628: ar_payment_schedules.trx_date) /
629: count(ar_receivable_applications.apply_date))) avgdays,
630: decode(count(ar_receivable_applications.apply_date), 0, 0,
631: round(sum(ar_receivable_applications.apply_date -
632: ar_payment_schedules.due_date) /

Line 632: ar_payment_schedules.due_date) /

628: ar_payment_schedules.trx_date) /
629: count(ar_receivable_applications.apply_date))) avgdays,
630: decode(count(ar_receivable_applications.apply_date), 0, 0,
631: round(sum(ar_receivable_applications.apply_date -
632: ar_payment_schedules.due_date) /
633: count(ar_receivable_applications.apply_date))) avgdayslate,
634: nvl(sum(decode(sign(ar_receivable_applications.apply_date -
635: ar_payment_schedules.due_date),
636: 1, 1, 0)), 0) newlate,

Line 635: ar_payment_schedules.due_date),

631: round(sum(ar_receivable_applications.apply_date -
632: ar_payment_schedules.due_date) /
633: count(ar_receivable_applications.apply_date))) avgdayslate,
634: nvl(sum(decode(sign(ar_receivable_applications.apply_date -
635: ar_payment_schedules.due_date),
636: 1, 1, 0)), 0) newlate,
637: nvl(sum( decode(sign(ar_receivable_applications.apply_date -
638: ar_payment_schedules.due_date),
639: 1, 0, 1)), 0) newontime

Line 638: ar_payment_schedules.due_date),

634: nvl(sum(decode(sign(ar_receivable_applications.apply_date -
635: ar_payment_schedules.due_date),
636: 1, 1, 0)), 0) newlate,
637: nvl(sum( decode(sign(ar_receivable_applications.apply_date -
638: ar_payment_schedules.due_date),
639: 1, 0, 1)), 0) newontime
640: into l_ytd_earned_discount_amount,
641: l_ytd_convert_earned_discount,
642: l_ytd_unearned_discount_amount,

Line 648: from ar_receivable_applications, ar_payment_schedules

644: l_ytd_average_payment_days,
645: l_ytd_average_days_late,
646: l_ytd_late_payments_count,
647: l_ytd_on_time_payments_count
648: from ar_receivable_applications, ar_payment_schedules
649: where ar_receivable_applications.applied_payment_schedule_id =
650: ar_payment_schedules.payment_schedule_id
651: and ar_payment_schedules.customer_id = customer_id
652: and ar_payment_schedules.customer_site_use_id = site_use_id

Line 650: ar_payment_schedules.payment_schedule_id

646: l_ytd_late_payments_count,
647: l_ytd_on_time_payments_count
648: from ar_receivable_applications, ar_payment_schedules
649: where ar_receivable_applications.applied_payment_schedule_id =
650: ar_payment_schedules.payment_schedule_id
651: and ar_payment_schedules.customer_id = customer_id
652: and ar_payment_schedules.customer_site_use_id = site_use_id
653: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
654: and ar_receivable_applications.apply_date between

Line 651: and ar_payment_schedules.customer_id = customer_id

647: l_ytd_on_time_payments_count
648: from ar_receivable_applications, ar_payment_schedules
649: where ar_receivable_applications.applied_payment_schedule_id =
650: ar_payment_schedules.payment_schedule_id
651: and ar_payment_schedules.customer_id = customer_id
652: and ar_payment_schedules.customer_site_use_id = site_use_id
653: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
654: and ar_receivable_applications.apply_date between
655: add_months(sysdate, -12) and sysdate

Line 652: and ar_payment_schedules.customer_site_use_id = site_use_id

648: from ar_receivable_applications, ar_payment_schedules
649: where ar_receivable_applications.applied_payment_schedule_id =
650: ar_payment_schedules.payment_schedule_id
651: and ar_payment_schedules.customer_id = customer_id
652: and ar_payment_schedules.customer_site_use_id = site_use_id
653: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
654: and ar_receivable_applications.apply_date between
655: add_months(sysdate, -12) and sysdate
656: and ar_receivable_applications.status = 'APP'

Line 653: and ar_payment_schedules.invoice_currency_code = Currency_Bucket

649: where ar_receivable_applications.applied_payment_schedule_id =
650: ar_payment_schedules.payment_schedule_id
651: and ar_payment_schedules.customer_id = customer_id
652: and ar_payment_schedules.customer_site_use_id = site_use_id
653: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
654: and ar_receivable_applications.apply_date between
655: add_months(sysdate, -12) and sysdate
656: and ar_receivable_applications.status = 'APP'
657: and ar_receivable_applications.display = 'Y'

Line 658: and nvl(ar_payment_schedules.receipt_confirmed_flag,'Y') = 'Y'

654: and ar_receivable_applications.apply_date between
655: add_months(sysdate, -12) and sysdate
656: and ar_receivable_applications.status = 'APP'
657: and ar_receivable_applications.display = 'Y'
658: and nvl(ar_payment_schedules.receipt_confirmed_flag,'Y') = 'Y'
659: ;
660:
661: select nvl(sum(ROUND(decode(ar_cash_receipts.status,'NSF', acrh.acctd_amount, 'STOP', acrh.acctd_amount, 0)
662: , 2)), 0) nsf_amount,

Line 1026: from ar_payment_schedules ps

1022: base_amount NUMBER;
1023: curr_exists NUMBER;
1024: CURSOR ps_trx IS
1025: SELECT invoice_currency_code, NVL(SUM(AMOUNT_DUE_REMAINING), 0) ammount_due,exchange_rate_type
1026: from ar_payment_schedules ps
1027: where ps.customer_id = qc_customer
1028: and ps.customer_site_use_id = NVL(qc_site,ps.customer_site_use_id)
1029: and ps.status = 'OP'
1030: and ps.class not in ('CM', 'PMT')

Line 1204: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,

1200:
1201: CURSOR C_LAST_INVOICE IS
1202: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1203: RA_CUST_TRX_TYPES.NAME,
1204: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1205: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1206: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1207: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1208: RA_CUSTOMER_TRX.TRX_DATE,

Line 1205: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,

1201: CURSOR C_LAST_INVOICE IS
1202: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1203: RA_CUST_TRX_TYPES.NAME,
1204: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1205: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1206: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1207: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1208: RA_CUSTOMER_TRX.TRX_DATE,
1209: TO_CHAR(ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE))

Line 1206: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',

1202: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1203: RA_CUST_TRX_TYPES.NAME,
1204: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1205: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1206: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1207: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1208: RA_CUSTOMER_TRX.TRX_DATE,
1209: TO_CHAR(ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE))
1210: FROM RA_CUST_TRX_TYPES,

Line 1207: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

1203: RA_CUST_TRX_TYPES.NAME,
1204: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1205: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1206: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1207: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1208: RA_CUSTOMER_TRX.TRX_DATE,
1209: TO_CHAR(ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE))
1210: FROM RA_CUST_TRX_TYPES,
1211: AR_PAYMENT_SCHEDULES,

Line 1211: AR_PAYMENT_SCHEDULES,

1207: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1208: RA_CUSTOMER_TRX.TRX_DATE,
1209: TO_CHAR(ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE))
1210: FROM RA_CUST_TRX_TYPES,
1211: AR_PAYMENT_SCHEDULES,
1212: RA_CUSTOMER_TRX
1213: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1214: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1215: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

Line 1213: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID

1209: TO_CHAR(ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE))
1210: FROM RA_CUST_TRX_TYPES,
1211: AR_PAYMENT_SCHEDULES,
1212: RA_CUSTOMER_TRX
1213: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1214: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1215: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1216: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1217: AND AR_PAYMENT_SCHEDULES.CLASS || '' = 'INV'

Line 1216: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id

1212: RA_CUSTOMER_TRX
1213: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1214: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1215: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1216: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1217: AND AR_PAYMENT_SCHEDULES.CLASS || '' = 'INV'
1218: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,
1219: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1220: ;

Line 1217: AND AR_PAYMENT_SCHEDULES.CLASS || '' = 'INV'

1213: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1214: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1215: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1216: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1217: AND AR_PAYMENT_SCHEDULES.CLASS || '' = 'INV'
1218: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,
1219: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1220: ;
1221:

Line 1313: FROM RA_CUST_TRX_TYPES TYPES, RA_CUSTOMER_TRX TRX1, AR_PAYMENT_SCHEDULES PS,

1309: TRX1.TRX_DATE,
1310: ROUND(TRUNC(SYSDATE) - TRX1.TRX_DATE),
1311: TRX2.CUSTOMER_TRX_ID,
1312: TRX1.CUSTOMER_TRX_ID
1313: FROM RA_CUST_TRX_TYPES TYPES, RA_CUSTOMER_TRX TRX1, AR_PAYMENT_SCHEDULES PS,
1314: RA_CUSTOMER_TRX TRX2, AR_RECEIVABLE_APPLICATIONS APP
1315: WHERE TRX1.CUST_TRX_TYPE_ID = TYPES.CUST_TRX_TYPE_ID
1316: AND TRX1.BILL_TO_CUSTOMER_ID = CUSTOMER_ID_1
1317: AND APP.APPLIED_CUSTOMER_TRX_ID = TRX2.CUSTOMER_TRX_ID (+)

Line 1396: FROM AR_PAYMENT_SCHEDULES P

1392: MAX(DECODE(P.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1393: DECODE(P.EXCHANGE_RATE,NULL, '*', ' ')))
1394: INTO l_last_cm_amount,
1395: l_last_cm_converted
1396: FROM AR_PAYMENT_SCHEDULES P
1397: WHERE P.CUSTOMER_TRX_ID = c_last_cm_id
1398: AND P.CUSTOMER_SITE_USE_ID = SITE_USE_ID_1
1399: ;
1400: c_last_cm_amount := l_last_cm_amount ;

Line 1450: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,

1446:
1447: CURSOR C_guar IS
1448: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1449: RA_CUST_TRX_TYPES.NAME,
1450: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1451: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1452: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1453: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1454: RA_CUSTOMER_TRX.TRX_DATE,

Line 1451: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,

1447: CURSOR C_guar IS
1448: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1449: RA_CUST_TRX_TYPES.NAME,
1450: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1451: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1452: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1453: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1454: RA_CUSTOMER_TRX.TRX_DATE,
1455: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)

Line 1452: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',

1448: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1449: RA_CUST_TRX_TYPES.NAME,
1450: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1451: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1452: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1453: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1454: RA_CUSTOMER_TRX.TRX_DATE,
1455: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1456: FROM RA_CUST_TRX_TYPES,

Line 1453: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

1449: RA_CUST_TRX_TYPES.NAME,
1450: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1451: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1452: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1453: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1454: RA_CUSTOMER_TRX.TRX_DATE,
1455: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1456: FROM RA_CUST_TRX_TYPES,
1457: RA_CUSTOMER_TRX,

Line 1458: AR_PAYMENT_SCHEDULES

1454: RA_CUSTOMER_TRX.TRX_DATE,
1455: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1456: FROM RA_CUST_TRX_TYPES,
1457: RA_CUSTOMER_TRX,
1458: AR_PAYMENT_SCHEDULES
1459: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1460: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1461: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1462: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id

Line 1459: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID

1455: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1456: FROM RA_CUST_TRX_TYPES,
1457: RA_CUSTOMER_TRX,
1458: AR_PAYMENT_SCHEDULES
1459: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1460: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1461: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1462: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1463: AND AR_PAYMENT_SCHEDULES.CLASS = 'GUAR'

Line 1462: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id

1458: AR_PAYMENT_SCHEDULES
1459: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1460: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1461: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1462: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1463: AND AR_PAYMENT_SCHEDULES.CLASS = 'GUAR'
1464: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,
1465: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1466: ;

Line 1463: AND AR_PAYMENT_SCHEDULES.CLASS = 'GUAR'

1459: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1460: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1461: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1462: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1463: AND AR_PAYMENT_SCHEDULES.CLASS = 'GUAR'
1464: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,
1465: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1466: ;
1467:

Line 1545: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,

1541:
1542: CURSOR C_DEP IS
1543: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1544: RA_CUST_TRX_TYPES.NAME,
1545: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1546: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1547: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1548: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1549: RA_CUSTOMER_TRX.TRX_DATE,

Line 1546: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,

1542: CURSOR C_DEP IS
1543: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1544: RA_CUST_TRX_TYPES.NAME,
1545: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1546: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1547: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1548: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1549: RA_CUSTOMER_TRX.TRX_DATE,
1550: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)

Line 1547: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',

1543: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1544: RA_CUST_TRX_TYPES.NAME,
1545: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1546: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1547: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1548: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1549: RA_CUSTOMER_TRX.TRX_DATE,
1550: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1551: FROM RA_CUST_TRX_TYPES,

Line 1548: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

1544: RA_CUST_TRX_TYPES.NAME,
1545: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1546: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1547: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1548: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1549: RA_CUSTOMER_TRX.TRX_DATE,
1550: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1551: FROM RA_CUST_TRX_TYPES,
1552: RA_CUSTOMER_TRX,

Line 1553: AR_PAYMENT_SCHEDULES

1549: RA_CUSTOMER_TRX.TRX_DATE,
1550: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1551: FROM RA_CUST_TRX_TYPES,
1552: RA_CUSTOMER_TRX,
1553: AR_PAYMENT_SCHEDULES
1554: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1555: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1556: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1557: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id

Line 1554: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID

1550: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1551: FROM RA_CUST_TRX_TYPES,
1552: RA_CUSTOMER_TRX,
1553: AR_PAYMENT_SCHEDULES
1554: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1555: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1556: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1557: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1558: AND AR_PAYMENT_SCHEDULES.CLASS = 'DEP'

Line 1557: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id

1553: AR_PAYMENT_SCHEDULES
1554: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1555: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1556: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1557: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1558: AND AR_PAYMENT_SCHEDULES.CLASS = 'DEP'
1559: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,
1560: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1561: ;

Line 1558: AND AR_PAYMENT_SCHEDULES.CLASS = 'DEP'

1554: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1555: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1556: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1557: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1558: AND AR_PAYMENT_SCHEDULES.CLASS = 'DEP'
1559: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,
1560: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1561: ;
1562:

Line 1637: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,

1633:
1634: CURSOR C_DM IS
1635: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1636: RA_CUST_TRX_TYPES.NAME,
1637: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1638: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1639: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1640: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1641: RA_CUSTOMER_TRX.TRX_DATE,

Line 1638: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,

1634: CURSOR C_DM IS
1635: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1636: RA_CUST_TRX_TYPES.NAME,
1637: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1638: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1639: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1640: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1641: RA_CUSTOMER_TRX.TRX_DATE,
1642: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)

Line 1639: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',

1635: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1636: RA_CUST_TRX_TYPES.NAME,
1637: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1638: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1639: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1640: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1641: RA_CUSTOMER_TRX.TRX_DATE,
1642: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1643: FROM RA_CUST_TRX_TYPES,

Line 1640: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

1636: RA_CUST_TRX_TYPES.NAME,
1637: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1638: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1639: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,functional_currency, ' ',
1640: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1641: RA_CUSTOMER_TRX.TRX_DATE,
1642: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1643: FROM RA_CUST_TRX_TYPES,
1644: RA_CUSTOMER_TRX,

Line 1645: AR_PAYMENT_SCHEDULES

1641: RA_CUSTOMER_TRX.TRX_DATE,
1642: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1643: FROM RA_CUST_TRX_TYPES,
1644: RA_CUSTOMER_TRX,
1645: AR_PAYMENT_SCHEDULES
1646: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1647: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1648: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1649: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id

Line 1646: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID

1642: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1643: FROM RA_CUST_TRX_TYPES,
1644: RA_CUSTOMER_TRX,
1645: AR_PAYMENT_SCHEDULES
1646: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1647: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1648: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1649: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1650: AND AR_PAYMENT_SCHEDULES.CLASS = 'DM'

Line 1649: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id

1645: AR_PAYMENT_SCHEDULES
1646: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1647: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1648: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1649: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1650: AND AR_PAYMENT_SCHEDULES.CLASS = 'DM'
1651: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,
1652: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1653: ;

Line 1650: AND AR_PAYMENT_SCHEDULES.CLASS = 'DM'

1646: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1647: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1648: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1649: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1650: AND AR_PAYMENT_SCHEDULES.CLASS = 'DM'
1651: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,
1652: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1653: ;
1654:

Line 1731: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,

1727:
1728: CURSOR C_CB IS
1729: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1730: RA_CUST_TRX_TYPES.NAME,
1731: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1732: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1733: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1734: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1735: RA_CUSTOMER_TRX.TRX_DATE,

Line 1732: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,

1728: CURSOR C_CB IS
1729: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1730: RA_CUST_TRX_TYPES.NAME,
1731: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1732: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1733: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1734: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1735: RA_CUSTOMER_TRX.TRX_DATE,
1736: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)

Line 1733: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',

1729: SELECT RA_CUSTOMER_TRX.TRX_NUMBER,
1730: RA_CUST_TRX_TYPES.NAME,
1731: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1732: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1733: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1734: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1735: RA_CUSTOMER_TRX.TRX_DATE,
1736: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1737: FROM RA_CUST_TRX_TYPES,

Line 1734: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

1730: RA_CUST_TRX_TYPES.NAME,
1731: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
1732: AR_PAYMENT_SCHEDULES.AMOUNT_DUE_ORIGINAL,
1733: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1734: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1735: RA_CUSTOMER_TRX.TRX_DATE,
1736: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1737: FROM RA_CUST_TRX_TYPES,
1738: RA_CUSTOMER_TRX,

Line 1739: AR_PAYMENT_SCHEDULES

1735: RA_CUSTOMER_TRX.TRX_DATE,
1736: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1737: FROM RA_CUST_TRX_TYPES,
1738: RA_CUSTOMER_TRX,
1739: AR_PAYMENT_SCHEDULES
1740: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1741: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1742: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1743: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id

Line 1740: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID

1736: ROUND(TRUNC(SYSDATE) - RA_CUSTOMER_TRX.TRX_DATE)
1737: FROM RA_CUST_TRX_TYPES,
1738: RA_CUSTOMER_TRX,
1739: AR_PAYMENT_SCHEDULES
1740: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1741: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1742: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1743: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1744: AND AR_PAYMENT_SCHEDULES.CLASS = 'CB'

Line 1743: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id

1739: AR_PAYMENT_SCHEDULES
1740: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1741: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1742: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1743: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1744: AND AR_PAYMENT_SCHEDULES.CLASS = 'CB'
1745: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,
1746: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1747: ;

Line 1744: AND AR_PAYMENT_SCHEDULES.CLASS = 'CB'

1740: WHERE AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX.CUSTOMER_TRX_ID
1741: AND RA_CUSTOMER_TRX.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID
1742: AND RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
1743: AND AR_PAYMENT_SCHEDULES.Customer_site_use_id = site_use_id
1744: AND AR_PAYMENT_SCHEDULES.CLASS = 'CB'
1745: ORDER BY RA_CUSTOMER_TRX.TRX_DATE DESC,
1746: RA_CUSTOMER_TRX.CUSTOMER_TRX_ID DESC
1747: ;
1748:

Line 1929: AR_PAYMENT_SCHEDULES.TRX_NUMBER,

1925: l_dummy NUMBER (1);
1926:
1927: CURSOR C_ADJUSTMENT IS
1928: SELECT LK.MEANING,
1929: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
1930: ar_payment_schedules.invoice_currency_code,
1931: AR_ADJUSTMENTS.AMOUNT,
1932: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1933: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

Line 1930: ar_payment_schedules.invoice_currency_code,

1926:
1927: CURSOR C_ADJUSTMENT IS
1928: SELECT LK.MEANING,
1929: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
1930: ar_payment_schedules.invoice_currency_code,
1931: AR_ADJUSTMENTS.AMOUNT,
1932: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1933: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1934: AR_ADJUSTMENTS.APPLY_DATE,

Line 1932: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',

1928: SELECT LK.MEANING,
1929: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
1930: ar_payment_schedules.invoice_currency_code,
1931: AR_ADJUSTMENTS.AMOUNT,
1932: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1933: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1934: AR_ADJUSTMENTS.APPLY_DATE,
1935: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
1936: FROM AR_ADJUSTMENTS,

Line 1933: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

1929: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
1930: ar_payment_schedules.invoice_currency_code,
1931: AR_ADJUSTMENTS.AMOUNT,
1932: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1933: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1934: AR_ADJUSTMENTS.APPLY_DATE,
1935: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
1936: FROM AR_ADJUSTMENTS,
1937: AR_LOOKUPS LK,

Line 1938: AR_PAYMENT_SCHEDULES

1934: AR_ADJUSTMENTS.APPLY_DATE,
1935: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
1936: FROM AR_ADJUSTMENTS,
1937: AR_LOOKUPS LK,
1938: AR_PAYMENT_SCHEDULES
1939: WHERE AR_ADJUSTMENTS.REASON_CODE = LK.LOOKUP_CODE (+)
1940: AND LK.LOOKUP_TYPE = 'ADJUST_REASON'
1941: AND AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID =
1942: AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID

Line 1942: AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID

1938: AR_PAYMENT_SCHEDULES
1939: WHERE AR_ADJUSTMENTS.REASON_CODE = LK.LOOKUP_CODE (+)
1940: AND LK.LOOKUP_TYPE = 'ADJUST_REASON'
1941: AND AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID =
1942: AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID
1943: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
1944: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
1945: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id
1946: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,

Line 1944: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID

1940: AND LK.LOOKUP_TYPE = 'ADJUST_REASON'
1941: AND AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID =
1942: AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID
1943: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
1944: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
1945: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id
1946: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,
1947: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC
1948: ;

Line 1945: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id

1941: AND AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID =
1942: AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID
1943: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
1944: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
1945: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id
1946: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,
1947: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC
1948: ;
1949:

Line 2026: AR_PAYMENT_SCHEDULES.TRX_NUMBER,

2022: l_dummy NUMBER (1);
2023:
2024: CURSOR C_WRITEOFF IS
2025: SELECT LK.LOOKUP_CODE,
2026: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
2027: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
2028: AR_ADJUSTMENTS.AMOUNT,
2029: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2030: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

Line 2027: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,

2023:
2024: CURSOR C_WRITEOFF IS
2025: SELECT LK.LOOKUP_CODE,
2026: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
2027: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
2028: AR_ADJUSTMENTS.AMOUNT,
2029: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2030: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
2031: AR_ADJUSTMENTS.APPLY_DATE,

Line 2029: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',

2025: SELECT LK.LOOKUP_CODE,
2026: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
2027: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
2028: AR_ADJUSTMENTS.AMOUNT,
2029: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2030: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
2031: AR_ADJUSTMENTS.APPLY_DATE,
2032: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
2033: FROM AR_ADJUSTMENTS,

Line 2030: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),

2026: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
2027: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
2028: AR_ADJUSTMENTS.AMOUNT,
2029: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2030: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
2031: AR_ADJUSTMENTS.APPLY_DATE,
2032: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
2033: FROM AR_ADJUSTMENTS,
2034: AR_LOOKUPS LK,

Line 2035: AR_PAYMENT_SCHEDULES

2031: AR_ADJUSTMENTS.APPLY_DATE,
2032: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
2033: FROM AR_ADJUSTMENTS,
2034: AR_LOOKUPS LK,
2035: AR_PAYMENT_SCHEDULES
2036: WHERE AR_ADJUSTMENTS.REASON_CODE
2037: = LK.LOOKUP_CODE(+)
2038: AND AR_ADJUSTMENTS.CUSTOMER_TRX_ID = AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID
2039: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'

Line 2038: AND AR_ADJUSTMENTS.CUSTOMER_TRX_ID = AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID

2034: AR_LOOKUPS LK,
2035: AR_PAYMENT_SCHEDULES
2036: WHERE AR_ADJUSTMENTS.REASON_CODE
2037: = LK.LOOKUP_CODE(+)
2038: AND AR_ADJUSTMENTS.CUSTOMER_TRX_ID = AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID
2039: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
2040: AND LK.LOOKUP_CODE(+) = 'WRITE OFF'
2041: AND LK.LOOKUP_TYPE(+) = 'ADJUST_REASON'
2042: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID

Line 2042: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID

2038: AND AR_ADJUSTMENTS.CUSTOMER_TRX_ID = AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID
2039: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
2040: AND LK.LOOKUP_CODE(+) = 'WRITE OFF'
2041: AND LK.LOOKUP_TYPE(+) = 'ADJUST_REASON'
2042: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
2043: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id
2044: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,
2045: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC
2046: ;

Line 2043: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id

2039: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
2040: AND LK.LOOKUP_CODE(+) = 'WRITE OFF'
2041: AND LK.LOOKUP_TYPE(+) = 'ADJUST_REASON'
2042: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
2043: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id
2044: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,
2045: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC
2046: ;
2047:

Line 2273: FROM ar_payment_schedules ps,

2269: CORR.CORRESPONDENCE_TYPE,
2270: ps.invoice_currency_code,
2271: MAX(CORR.CORRESPONDENCE_DATE),
2272: TRUNC(SYSDATE) - MAX(CORR.CORRESPONDENCE_DATE)
2273: FROM ar_payment_schedules ps,
2274: ar_correspondence_pay_sched cps,
2275: AR_DUNNING_LETTERS DUNN,
2276: AR_CORRESPONDENCES CORR
2277: WHERE CORR.REFERENCE1 = DUNN.DUNNING_LETTER_ID

Line 2479: AR_PAYMENT_SCHEDULES.TRX_NUMBER,

2475: SELECT cont_point.phone_area_code||'-' ||
2476: RTRIM(RPAD(decode(cont_point.contact_point_type,
2477: 'TLX', cont_point.telex_number,
2478: cont_point.phone_number),15)),
2479: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
2480: AR_PAYMENT_SCHEDULES.invoice_currency_code,
2481: AR_CALL_ACTIONS.ACTION_AMOUNT,
2482: DECODE(AR_CALL_ACTIONS.ACTION_AMOUNT, NULL, NULL,
2483: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',

Line 2480: AR_PAYMENT_SCHEDULES.invoice_currency_code,

2476: RTRIM(RPAD(decode(cont_point.contact_point_type,
2477: 'TLX', cont_point.telex_number,
2478: cont_point.phone_number),15)),
2479: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
2480: AR_PAYMENT_SCHEDULES.invoice_currency_code,
2481: AR_CALL_ACTIONS.ACTION_AMOUNT,
2482: DECODE(AR_CALL_ACTIONS.ACTION_AMOUNT, NULL, NULL,
2483: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2484: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' '))),

Line 2483: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',

2479: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
2480: AR_PAYMENT_SCHEDULES.invoice_currency_code,
2481: AR_CALL_ACTIONS.ACTION_AMOUNT,
2482: DECODE(AR_CALL_ACTIONS.ACTION_AMOUNT, NULL, NULL,
2483: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2484: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' '))),
2485: AR_CUSTOMER_CALL_TOPICS.CALL_DATE,
2486: ROUND(TRUNC(SYSDATE) - AR_CUSTOMER_CALL_TOPICS.CALL_DATE)
2487: FROM hz_contact_points cont_point,

Line 2484: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' '))),

2480: AR_PAYMENT_SCHEDULES.invoice_currency_code,
2481: AR_CALL_ACTIONS.ACTION_AMOUNT,
2482: DECODE(AR_CALL_ACTIONS.ACTION_AMOUNT, NULL, NULL,
2483: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2484: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' '))),
2485: AR_CUSTOMER_CALL_TOPICS.CALL_DATE,
2486: ROUND(TRUNC(SYSDATE) - AR_CUSTOMER_CALL_TOPICS.CALL_DATE)
2487: FROM hz_contact_points cont_point,
2488: hz_cust_account_roles car, AR_LOOKUPS LKUPS,

Line 2489: AR_PAYMENT_SCHEDULES, AR_CUSTOMER_CALL_TOPICS, AR_CALL_ACTIONS

2485: AR_CUSTOMER_CALL_TOPICS.CALL_DATE,
2486: ROUND(TRUNC(SYSDATE) - AR_CUSTOMER_CALL_TOPICS.CALL_DATE)
2487: FROM hz_contact_points cont_point,
2488: hz_cust_account_roles car, AR_LOOKUPS LKUPS,
2489: AR_PAYMENT_SCHEDULES, AR_CUSTOMER_CALL_TOPICS, AR_CALL_ACTIONS
2490: --WHERE AR_CUSTOMER_CALL_TOPICS.CUSTOMER_ID = CUSTOMER_ID
2491: WHERE AR_CUSTOMER_CALL_TOPICS.CUSTOMER_ID = CUSTOMER_ID_1
2492: --and AR_CUSTOMER_CALL_TOPICS.site_use_id(+) = site_use_id
2493: and AR_CUSTOMER_CALL_TOPICS.site_use_id(+) = site_use_id_1

Line 2500: AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID (+)

2496: AND car.party_id = cont_point.owner_table_id
2497: AND cont_point.owner_table_name = 'HZ_PARTIES'
2498: AND cont_point.contact_point_type not in ('EDI','EMAIL','WEB')
2499: AND AR_CUSTOMER_CALL_TOPICS.CUSTOMER_TRX_ID =
2500: AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID (+)
2501: AND AR_CUSTOMER_CALL_TOPICS.CUSTOMER_CALL_TOPIC_ID =
2502: AR_CALL_ACTIONS.CUSTOMER_CALL_TOPIC_ID (+)
2503: AND AR_CUSTOMER_CALL_TOPICS.FOLLOW_UP_ACTION =
2504: LKUPS.LOOKUP_CODE (+)

Line 3242: from ar_payment_schedules ps

3238: curr_exists NUMBER;
3239:
3240: CURSOR ps_trx IS
3241: SELECT invoice_currency_code, NVL(SUM(AMOUNT_DUE_REMAINING), 0) ammount_due
3242: from ar_payment_schedules ps
3243: where ps.customer_id = customer_id
3244: and ps.customer_site_use_id = site_use_id
3245: and ps.status = 'OP'
3246: and ps.class not in ('CM', 'PMT')

Line 3704: from ar_payment_schedules ps

3700: curr_exists NUMBER;
3701:
3702: CURSOR ps_trx IS
3703: SELECT invoice_currency_code, NVL(SUM(AMOUNT_DUE_REMAINING), 0) ammount_due,exchange_rate_type
3704: from ar_payment_schedules ps
3705: where ps.customer_id = customer_id
3706: and ps.customer_site_use_id = site_use_id
3707: and ps.status = 'OP'
3708: and ps.class not in ('CM', 'PMT')