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_ARXVASUM2 dependencies on AR_PAYMENT_SCHEDULES

Line 10: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

6: procedure get_amounts( p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
7: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
8: p_start_date IN gl_period_statuses.start_date%TYPE,
9: p_end_date IN gl_period_statuses.end_date%TYPE,
10: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
11: p_inv_count IN OUT NOCOPY NUMBER,
12: p_dm_count IN OUT NOCOPY NUMBER,
13: p_cb_count IN OUT NOCOPY NUMBER,
14: p_dep_count IN OUT NOCOPY NUMBER,

Line 60: p_status IN ar_payment_schedules.status%TYPE,

56: p_func_curr IN VARCHAR2,
57: p_exc_rate IN NUMBER,
58: p_precision IN NUMBER,
59: p_min_acc_unit IN NUMBER,
60: p_status IN ar_payment_schedules.status%TYPE,
61: p_incl_rct_spmenu IN VARCHAR2
62: ) IS
63: BEGIN
64: SELECT decode(p_currency_code,

Line 283: from ar_payment_schedules ps

279: p_guar_count,
280: p_cm_count,
281: /* 18-MAY-2000 J Rautiainen BR Implementation */
282: p_br_count
283: from ar_payment_schedules ps
284: where nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
285: and ps.gl_date between p_start_date and p_end_date
286: and ps.invoice_currency_code = nvl(p_currency_code,ps.invoice_currency_code)
287: and nvl(ps.receipt_confirmed_flag,'Y') = 'Y'

Line 345: ar_payment_schedules ps

341: p_sum_risk_func_ori_amt,
342: p_sum_risk_func_rem_amt,
343: p_risk_count
344: from ar_cash_receipts cr,
345: ar_payment_schedules ps
346: where ps.cash_receipt_id = cr.cash_receipt_id
347: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
348: and ps.gl_date between p_start_date and p_end_date
349: and ps.invoice_currency_code = nvl(p_currency_code,ps.invoice_currency_code)

Line 353: FROM ar_payment_schedules PS_DM,

349: and ps.invoice_currency_code = nvl(p_currency_code,ps.invoice_currency_code)
350: and (nvl(cr.reversal_category, cr.status||'X') <> cr.status OR
351: (nvl(cr.reversal_category, cr.status||'X') = cr.status AND
352: 'Y' = (SELECT 'Y'
353: FROM ar_payment_schedules PS_DM,
354: ra_cust_trx_types CTT_DM,
355: ra_customer_trx CT_DM,
356: ra_cust_trx_line_gl_dist DM_GLD
357: WHERE PS_DM.reversed_cash_receipt_id = cr.cash_receipt_id

Line 407: ar_payment_schedules ps,

403: p_sum_risk_func_ori_amt,
404: p_sum_risk_func_rem_amt,
405: p_risk_count
406: from ar_cash_receipts cr,
407: ar_payment_schedules ps,
408: ar_cash_receipt_history crh
409: where ps.cash_receipt_id = cr.cash_receipt_id
410: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
411: and ps.gl_date between p_start_date and p_end_date

Line 449: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

445: p_start_date IN gl_period_statuses.start_date%TYPE,
446: p_end_date IN gl_period_statuses.end_date%TYPE,
447: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
448: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
449: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
450: p_func_curr IN VARCHAR2,
451: p_exc_rate IN NUMBER,
452: p_precision IN NUMBER,
453: p_min_acc_unit IN NUMBER,

Line 454: p_status IN ar_payment_schedules.status%TYPE

450: p_func_curr IN VARCHAR2,
451: p_exc_rate IN NUMBER,
452: p_precision IN NUMBER,
453: p_min_acc_unit IN NUMBER,
454: p_status IN ar_payment_schedules.status%TYPE
455: ) is
456: begin
457:
458: select nvl(sum(decode(sign(ra.apply_date - ps.due_date),1, 1,0)),0),

Line 491: ar_payment_schedules ps

487: p_payments_ontime_amount,
488: p_payments_late_func_amt,
489: p_payments_ontime_func_amt
490: from ar_receivable_applications ra,
491: ar_payment_schedules ps
492: where ra.applied_payment_schedule_id = ps.payment_schedule_id
493: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
494: AND ra.apply_date between p_start_date and p_end_date
495: and ra.status = 'APP'

Line 516: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

512: p_start_date IN gl_period_statuses.start_date%TYPE,
513: p_end_date IN gl_period_statuses.end_date%TYPE,
514: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
515: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
516: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
517: p_func_curr IN VARCHAR2,
518: p_exc_rate IN NUMBER,
519: p_precision IN NUMBER,
520: p_min_acc_unit NUMBER,

Line 521: p_status IN ar_payment_schedules.status%TYPE

517: p_func_curr IN VARCHAR2,
518: p_exc_rate IN NUMBER,
519: p_precision IN NUMBER,
520: p_min_acc_unit NUMBER,
521: p_status IN ar_payment_schedules.status%TYPE
522: ) is
523: begin
524: SELECT decode(p_currency_code,
525: NULL , NULL ,

Line 540: ar_payment_schedules ps

536: INTO p_nsf_stop_amount,
537: p_nsf_stop_func_amt,
538: p_nsf_stop_count
539: FROM ar_cash_receipts cr,
540: ar_payment_schedules ps
541: WHERE ps.gl_date between p_start_date and p_end_date
542: AND ps.cash_receipt_id = cr.cash_receipt_id
543: AND cr.reversal_category in ('NSF','STOP')
544: and nvl(cr.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(cr.customer_site_use_id, -10) )

Line 564: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

560: p_start_date IN gl_period_statuses.start_date%TYPE,
561: p_end_date IN gl_period_statuses.end_date%TYPE,
562: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
563: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
564: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
565: p_func_curr IN VARCHAR2,
566: p_exc_rate IN NUMBER,
567: p_precision IN NUMBER,
568: p_min_acc_unit IN NUMBER,

Line 569: p_status IN ar_payment_schedules.status%TYPE

565: p_func_curr IN VARCHAR2,
566: p_exc_rate IN NUMBER,
567: p_precision IN NUMBER,
568: p_min_acc_unit IN NUMBER,
569: p_status IN ar_payment_schedules.status%TYPE
570: ) is
571: begin
572: select decode(p_currency_code,
573: NULL , NULL , nvl(sum(a.amount),0)

Line 590: ar_payment_schedules ps

586: p_adjustment_func_amt,
587: p_adjustment_count
588: from ar_adjustments a,
589: ar_receivables_trx rt,
590: ar_payment_schedules ps
591: where a.gl_date between p_start_date and p_end_date
592: and nvl(a.postable,'Y') = 'Y'
593: and a.payment_schedule_id = ps.payment_schedule_id
594: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )

Line 617: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

613: p_start_date IN gl_period_statuses.start_date%TYPE,
614: p_end_date IN gl_period_statuses.end_date%TYPE,
615: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
616: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
617: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
618: p_func_curr IN VARCHAR2,
619: p_exc_rate IN NUMBER,
620: p_precision IN NUMBER,
621: p_min_acc_unit IN NUMBER,

Line 622: p_status IN ar_payment_schedules.status%TYPE

618: p_func_curr IN VARCHAR2,
619: p_exc_rate IN NUMBER,
620: p_precision IN NUMBER,
621: p_min_acc_unit IN NUMBER,
622: p_status IN ar_payment_schedules.status%TYPE
623: ) is
624: begin
625: select decode(p_currency_code,
626: NULL , NULL , nvl(sum(a.amount),0)

Line 643: ar_payment_schedules ps

639: p_financecharg_func_amt,
640: p_financecharg_count
641: from ar_adjustments a,
642: ar_receivables_trx rt,
643: ar_payment_schedules ps
644: where a.gl_date between p_start_date and p_end_date
645: and nvl(a.postable,'Y') = 'Y'
646: and a.payment_schedule_id = ps.payment_schedule_id
647: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )

Line 672: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

668: p_start_date IN gl_period_statuses.start_date%TYPE,
669: p_end_date IN gl_period_statuses.end_date%TYPE,
670: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
671: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
672: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
673: p_func_curr IN VARCHAR2,
674: p_exc_rate IN NUMBER,
675: p_precision IN NUMBER,
676: p_min_acc_unit IN NUMBER,

Line 677: p_status IN ar_payment_schedules.status%TYPE

673: p_func_curr IN VARCHAR2,
674: p_exc_rate IN NUMBER,
675: p_precision IN NUMBER,
676: p_min_acc_unit IN NUMBER,
677: p_status IN ar_payment_schedules.status%TYPE
678: ) is
679: begin
680: SELECT decode(p_currency_code,
681: NULL , NULL ,

Line 723: ar_payment_schedules ps

719: p_unearned_func_disc,
720: p_earned_disc_count,
721: p_unearned_disc_count
722: FROM ar_receivable_applications ra,
723: ar_payment_schedules ps
724: where ra.gl_date between p_start_date and p_end_date
725: and ps.payment_schedule_id = ra.applied_payment_schedule_id
726: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
727: and ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)

Line 747: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

743: p_start_date IN gl_period_statuses.start_date%TYPE,
744: p_end_date IN gl_period_statuses.end_date%TYPE,
745: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
746: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
747: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
748: p_func_curr IN VARCHAR2,
749: p_exc_rate IN NUMBER,
750: p_precision IN NUMBER,
751: p_min_acc_unit IN NUMBER,

Line 752: p_status IN ar_payment_schedules.status%TYPE

748: p_func_curr IN VARCHAR2,
749: p_exc_rate IN NUMBER,
750: p_precision IN NUMBER,
751: p_min_acc_unit IN NUMBER,
752: p_status IN ar_payment_schedules.status%TYPE
753: ) is
754: begin
755: select decode(p_currency_code,
756: NULL , NULL ,

Line 770: from ar_payment_schedules ps,

766: count(cr.amount)
767: into p_pend_confirm_amt,
768: p_pend_confirm_func_amt,
769: p_pend_confirm_count
770: from ar_payment_schedules ps,
771: ar_cash_receipts cr,
772: ar_cash_receipt_history crh
773: where ps.cash_receipt_id = cr.cash_receipt_id
774: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id,

Line 811: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

807: p_start_date IN gl_period_statuses.start_date%TYPE,
808: p_end_date IN gl_period_statuses.end_date%TYPE,
809: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
810: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
811: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
812: p_func_curr IN VARCHAR2,
813: p_exc_rate IN NUMBER,
814: p_precision IN NUMBER,
815: p_min_acc_unit IN NUMBER,

Line 816: p_status IN ar_payment_schedules.status%TYPE,

812: p_func_curr IN VARCHAR2,
813: p_exc_rate IN NUMBER,
814: p_precision IN NUMBER,
815: p_min_acc_unit IN NUMBER,
816: p_status IN ar_payment_schedules.status%TYPE,
817: p_incl_rct_spmenu IN VARCHAR2
818: ) is
819: l_ori_amount number;
820: l_func_ori_amt number;

Line 876: ar_payment_schedules ps,

872: l_func_ori_amt,
873: l_func_rem_amt,
874: l_count
875: from ar_cash_receipts cr,
876: ar_payment_schedules ps,
877: ar_cash_receipt_history crh,
878: ar_receipt_methods rm,
879: ar_receipt_classes rc
880: where ps.cash_receipt_id = cr.cash_receipt_id

Line 957: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

953: p_start_date IN gl_period_statuses.start_date%TYPE,
954: p_end_date IN gl_period_statuses.end_date%TYPE,
955: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
956: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
957: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
958: p_func_curr IN VARCHAR2,
959: p_exc_rate IN NUMBER,
960: p_precision IN NUMBER,
961: p_min_acc_unit IN NUMBER,

Line 962: p_status IN ar_payment_schedules.status%TYPE,

958: p_func_curr IN VARCHAR2,
959: p_exc_rate IN NUMBER,
960: p_precision IN NUMBER,
961: p_min_acc_unit IN NUMBER,
962: p_status IN ar_payment_schedules.status%TYPE,
963: p_incl_rct_spmenu IN VARCHAR2
964: ) is
965: l_ori_amount number;
966: l_func_ori_amt number;

Line 1020: ar_payment_schedules ps,

1016: l_func_ori_amt,
1017: l_func_rem_amt,
1018: l_count
1019: from ar_cash_receipts cr,
1020: ar_payment_schedules ps,
1021: ar_cash_receipt_history crh
1022: where ps.cash_receipt_id = cr.cash_receipt_id
1023: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
1024: and ps.gl_date between p_start_date and p_end_date

Line 1077: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

1073: p_start_date IN gl_period_statuses.start_date%TYPE,
1074: p_end_date IN gl_period_statuses.end_date%TYPE,
1075: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1076: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1077: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1078: p_func_curr IN VARCHAR2,
1079: p_exc_rate IN NUMBER,
1080: p_precision IN NUMBER,
1081: p_min_acc_unit IN NUMBER,

Line 1082: p_status IN ar_payment_schedules.status%TYPE) IS

1078: p_func_curr IN VARCHAR2,
1079: p_exc_rate IN NUMBER,
1080: p_precision IN NUMBER,
1081: p_min_acc_unit IN NUMBER,
1082: p_status IN ar_payment_schedules.status%TYPE) IS
1083: BEGIN
1084: IF PG_DEBUG in ('Y', 'C') THEN
1085: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()+ ');
1086: END IF;

Line 1105: ar_payment_schedules ps

1101: into p_BR_protested_amt,
1102: p_BR_protested_func_amt,
1103: p_BR_protested_count
1104: from ar_transaction_history trh,
1105: ar_payment_schedules ps
1106: where trh.gl_date between p_start_date and p_end_date
1107: and trh.status = 'PROTESTED'
1108: and nvl(trh.current_record_flag,'Y') = 'Y'
1109: and ps.customer_trx_id = trh.customer_trx_id

Line 1134: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

1130: p_start_date IN gl_period_statuses.start_date%TYPE,
1131: p_end_date IN gl_period_statuses.end_date%TYPE,
1132: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1133: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1134: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1135: p_func_curr IN VARCHAR2,
1136: p_exc_rate IN NUMBER,
1137: p_precision IN NUMBER,
1138: p_min_acc_unit IN NUMBER,

Line 1139: p_status IN ar_payment_schedules.status%TYPE) IS

1135: p_func_curr IN VARCHAR2,
1136: p_exc_rate IN NUMBER,
1137: p_precision IN NUMBER,
1138: p_min_acc_unit IN NUMBER,
1139: p_status IN ar_payment_schedules.status%TYPE) IS
1140: BEGIN
1141:
1142: IF PG_DEBUG in ('Y', 'C') THEN
1143: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()+ ');

Line 1163: ar_payment_schedules ps

1159: into p_BR_unpaid_amt,
1160: p_BR_unpaid_func_amt,
1161: p_BR_unpaid_count
1162: from ar_transaction_history trh,
1163: ar_payment_schedules ps
1164: where trh.gl_date between p_start_date and p_end_date
1165: and trh.status = 'UNPAID'
1166: and nvl(trh.current_record_flag,'Y') = 'Y'
1167: and ps.customer_trx_id = trh.customer_trx_id

Line 1192: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

1188: p_start_date IN gl_period_statuses.start_date%TYPE,
1189: p_end_date IN gl_period_statuses.end_date%TYPE,
1190: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1191: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1192: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1193: p_func_curr IN VARCHAR2,
1194: p_exc_rate IN NUMBER,
1195: p_precision IN NUMBER,
1196: p_min_acc_unit IN NUMBER) IS