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_ARXVASUM 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 ps.customer_id = p_customer_id /* bug1963032 */
285: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
286: and ps.gl_date between p_start_date and p_end_date
287: and ps.invoice_currency_code = nvl(p_currency_code,ps.invoice_currency_code)

Line 346: ar_payment_schedules ps

342: p_sum_risk_func_ori_amt,
343: p_sum_risk_func_rem_amt,
344: p_risk_count
345: from ar_cash_receipts cr,
346: ar_payment_schedules ps
347: where ps.customer_id = p_customer_id /* Bug 1963032 */
348: and ps.cash_receipt_id = cr.cash_receipt_id
349: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
350: and ps.gl_date between p_start_date and p_end_date

Line 355: FROM ar_payment_schedules PS_DM,

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

Line 409: ar_payment_schedules ps,

405: p_sum_risk_func_ori_amt,
406: p_sum_risk_func_rem_amt,
407: p_risk_count
408: from ar_cash_receipts cr,
409: ar_payment_schedules ps,
410: ar_cash_receipt_history crh
411: where ps.customer_id = p_customer_id /* Bug 1963032 */
412: and ps.cash_receipt_id = cr.cash_receipt_id
413: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )

Line 452: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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

Line 457: p_status IN ar_payment_schedules.status%TYPE

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

Line 494: ar_payment_schedules ps

490: p_payments_ontime_amount,
491: p_payments_late_func_amt,
492: p_payments_ontime_func_amt
493: from ar_receivable_applications ra,
494: ar_payment_schedules ps
495: where ra.applied_payment_schedule_id = ps.payment_schedule_id
496: and ps.customer_id = p_customer_id /* bug1963032 */
497: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
498: AND ra.apply_date between p_start_date and p_end_date

Line 520: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

516: p_start_date IN gl_period_statuses.start_date%TYPE,
517: p_end_date IN gl_period_statuses.end_date%TYPE,
518: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
519: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
520: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
521: p_func_curr IN VARCHAR2,
522: p_exc_rate IN NUMBER,
523: p_precision IN NUMBER,
524: p_min_acc_unit NUMBER,

Line 525: p_status IN ar_payment_schedules.status%TYPE

521: p_func_curr IN VARCHAR2,
522: p_exc_rate IN NUMBER,
523: p_precision IN NUMBER,
524: p_min_acc_unit NUMBER,
525: p_status IN ar_payment_schedules.status%TYPE
526: ) is
527: begin
528: SELECT decode(p_currency_code,
529: NULL , NULL ,

Line 544: ar_payment_schedules ps

540: INTO p_nsf_stop_amount,
541: p_nsf_stop_func_amt,
542: p_nsf_stop_count
543: FROM ar_cash_receipts cr,
544: ar_payment_schedules ps
545: WHERE ps.gl_date between p_start_date and p_end_date
546: AND ps.cash_receipt_id = cr.cash_receipt_id
547: AND cr.reversal_category in ('NSF','STOP')
548: AND cr.pay_from_customer = p_customer_id /* bug1963032 */

Line 569: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

565: p_start_date IN gl_period_statuses.start_date%TYPE,
566: p_end_date IN gl_period_statuses.end_date%TYPE,
567: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
568: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
569: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
570: p_func_curr IN VARCHAR2,
571: p_exc_rate IN NUMBER,
572: p_precision IN NUMBER,
573: p_min_acc_unit IN NUMBER,

Line 574: p_status IN ar_payment_schedules.status%TYPE

570: p_func_curr IN VARCHAR2,
571: p_exc_rate IN NUMBER,
572: p_precision IN NUMBER,
573: p_min_acc_unit IN NUMBER,
574: p_status IN ar_payment_schedules.status%TYPE
575: ) is
576: begin
577: select decode(p_currency_code,
578: NULL , NULL , nvl(sum(a.amount),0)

Line 595: ar_payment_schedules ps

591: p_adjustment_func_amt,
592: p_adjustment_count
593: from ar_adjustments a,
594: ar_receivables_trx rt,
595: ar_payment_schedules ps
596: where a.gl_date between p_start_date and p_end_date
597: and nvl(a.postable,'Y') = 'Y'
598: and a.payment_schedule_id = ps.payment_schedule_id
599: and ps.customer_id = p_customer_id /* bug1963032 */

Line 623: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

619: p_start_date IN gl_period_statuses.start_date%TYPE,
620: p_end_date IN gl_period_statuses.end_date%TYPE,
621: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
622: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
623: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
624: p_func_curr IN VARCHAR2,
625: p_exc_rate IN NUMBER,
626: p_precision IN NUMBER,
627: p_min_acc_unit IN NUMBER,

Line 628: p_status IN ar_payment_schedules.status%TYPE

624: p_func_curr IN VARCHAR2,
625: p_exc_rate IN NUMBER,
626: p_precision IN NUMBER,
627: p_min_acc_unit IN NUMBER,
628: p_status IN ar_payment_schedules.status%TYPE
629: ) is
630: begin
631: select decode(p_currency_code,
632: NULL , NULL , nvl(sum(a.amount),0)

Line 649: ar_payment_schedules ps

645: p_financecharg_func_amt,
646: p_financecharg_count
647: from ar_adjustments a,
648: ar_receivables_trx rt,
649: ar_payment_schedules ps
650: where a.gl_date between p_start_date and p_end_date
651: and nvl(a.postable,'Y') = 'Y'
652: and a.payment_schedule_id = ps.payment_schedule_id
653: and ps.customer_id = p_customer_id /* bug1963032 */

Line 679: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

675: p_start_date IN gl_period_statuses.start_date%TYPE,
676: p_end_date IN gl_period_statuses.end_date%TYPE,
677: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
678: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
679: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
680: p_func_curr IN VARCHAR2,
681: p_exc_rate IN NUMBER,
682: p_precision IN NUMBER,
683: p_min_acc_unit IN NUMBER,

Line 684: p_status IN ar_payment_schedules.status%TYPE

680: p_func_curr IN VARCHAR2,
681: p_exc_rate IN NUMBER,
682: p_precision IN NUMBER,
683: p_min_acc_unit IN NUMBER,
684: p_status IN ar_payment_schedules.status%TYPE
685: ) is
686: begin
687: SELECT decode(p_currency_code,
688: NULL , NULL ,

Line 730: ar_payment_schedules ps

726: p_unearned_func_disc,
727: p_earned_disc_count,
728: p_unearned_disc_count
729: FROM ar_receivable_applications ra,
730: ar_payment_schedules ps
731: where ra.gl_date between p_start_date and p_end_date
732: and ps.payment_schedule_id = ra.applied_payment_schedule_id
733: and ps.customer_id = p_customer_id /* bug1963032 */
734: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )

Line 755: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

751: p_start_date IN gl_period_statuses.start_date%TYPE,
752: p_end_date IN gl_period_statuses.end_date%TYPE,
753: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
754: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
755: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
756: p_func_curr IN VARCHAR2,
757: p_exc_rate IN NUMBER,
758: p_precision IN NUMBER,
759: p_min_acc_unit IN NUMBER,

Line 760: p_status IN ar_payment_schedules.status%TYPE

756: p_func_curr IN VARCHAR2,
757: p_exc_rate IN NUMBER,
758: p_precision IN NUMBER,
759: p_min_acc_unit IN NUMBER,
760: p_status IN ar_payment_schedules.status%TYPE
761: ) is
762: begin
763: select decode(p_currency_code,
764: NULL , NULL ,

Line 778: from ar_payment_schedules ps,

774: count(cr.amount)
775: into p_pend_confirm_amt,
776: p_pend_confirm_func_amt,
777: p_pend_confirm_count
778: from ar_payment_schedules ps,
779: ar_cash_receipts cr,
780: ar_cash_receipt_history crh
781: where ps.customer_id = p_customer_id /* bug1963032 */
782: and ps.cash_receipt_id = cr.cash_receipt_id

Line 820: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

816: p_start_date IN gl_period_statuses.start_date%TYPE,
817: p_end_date IN gl_period_statuses.end_date%TYPE,
818: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
819: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
820: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
821: p_func_curr IN VARCHAR2,
822: p_exc_rate IN NUMBER,
823: p_precision IN NUMBER,
824: p_min_acc_unit IN NUMBER,

Line 825: p_status IN ar_payment_schedules.status%TYPE,

821: p_func_curr IN VARCHAR2,
822: p_exc_rate IN NUMBER,
823: p_precision IN NUMBER,
824: p_min_acc_unit IN NUMBER,
825: p_status IN ar_payment_schedules.status%TYPE,
826: p_incl_rct_spmenu IN VARCHAR2
827: ) is
828: l_ori_amount number;
829: l_func_ori_amt number;

Line 885: ar_payment_schedules ps,

881: l_func_ori_amt,
882: l_func_rem_amt,
883: l_count
884: from ar_cash_receipts cr,
885: ar_payment_schedules ps,
886: ar_cash_receipt_history crh,
887: ar_receipt_methods rm,
888: ar_receipt_classes rc
889: where ps.customer_id = p_customer_id /* bug1963032 */

Line 967: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

963: p_start_date IN gl_period_statuses.start_date%TYPE,
964: p_end_date IN gl_period_statuses.end_date%TYPE,
965: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
966: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
967: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
968: p_func_curr IN VARCHAR2,
969: p_exc_rate IN NUMBER,
970: p_precision IN NUMBER,
971: p_min_acc_unit IN NUMBER,

Line 972: p_status IN ar_payment_schedules.status%TYPE,

968: p_func_curr IN VARCHAR2,
969: p_exc_rate IN NUMBER,
970: p_precision IN NUMBER,
971: p_min_acc_unit IN NUMBER,
972: p_status IN ar_payment_schedules.status%TYPE,
973: p_incl_rct_spmenu IN VARCHAR2
974: ) is
975: l_ori_amount number;
976: l_func_ori_amt number;

Line 1030: ar_payment_schedules ps,

1026: l_func_ori_amt,
1027: l_func_rem_amt,
1028: l_count
1029: from ar_cash_receipts cr,
1030: ar_payment_schedules ps,
1031: ar_cash_receipt_history crh
1032: where ps.customer_id = p_customer_id /* bug1963032 */
1033: and ps.cash_receipt_id = cr.cash_receipt_id
1034: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )

Line 1088: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

1084: p_start_date IN gl_period_statuses.start_date%TYPE,
1085: p_end_date IN gl_period_statuses.end_date%TYPE,
1086: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1087: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1088: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1089: p_func_curr IN VARCHAR2,
1090: p_exc_rate IN NUMBER,
1091: p_precision IN NUMBER,
1092: p_min_acc_unit IN NUMBER,

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

1089: p_func_curr IN VARCHAR2,
1090: p_exc_rate IN NUMBER,
1091: p_precision IN NUMBER,
1092: p_min_acc_unit IN NUMBER,
1093: p_status IN ar_payment_schedules.status%TYPE) IS
1094: BEGIN
1095: IF PG_DEBUG in ('Y', 'C') THEN
1096: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()+ ');
1097: END IF;

Line 1116: ar_payment_schedules ps

1112: into p_BR_protested_amt,
1113: p_BR_protested_func_amt,
1114: p_BR_protested_count
1115: from ar_transaction_history trh,
1116: ar_payment_schedules ps
1117: where trh.gl_date between p_start_date and p_end_date
1118: and trh.status = 'PROTESTED'
1119: and nvl(trh.current_record_flag,'Y') = 'Y'
1120: and ps.customer_trx_id = trh.customer_trx_id

Line 1146: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

1142: p_start_date IN gl_period_statuses.start_date%TYPE,
1143: p_end_date IN gl_period_statuses.end_date%TYPE,
1144: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1145: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1146: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1147: p_func_curr IN VARCHAR2,
1148: p_exc_rate IN NUMBER,
1149: p_precision IN NUMBER,
1150: p_min_acc_unit IN NUMBER,

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

1147: p_func_curr IN VARCHAR2,
1148: p_exc_rate IN NUMBER,
1149: p_precision IN NUMBER,
1150: p_min_acc_unit IN NUMBER,
1151: p_status IN ar_payment_schedules.status%TYPE) IS
1152: BEGIN
1153:
1154: IF PG_DEBUG in ('Y', 'C') THEN
1155: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()+ ');

Line 1175: ar_payment_schedules ps

1171: into p_BR_unpaid_amt,
1172: p_BR_unpaid_func_amt,
1173: p_BR_unpaid_count
1174: from ar_transaction_history trh,
1175: ar_payment_schedules ps
1176: where trh.gl_date between p_start_date and p_end_date
1177: and trh.status = 'UNPAID'
1178: and nvl(trh.current_record_flag,'Y') = 'Y'
1179: and ps.customer_trx_id = trh.customer_trx_id

Line 1205: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

1201: p_start_date IN gl_period_statuses.start_date%TYPE,
1202: p_end_date IN gl_period_statuses.end_date%TYPE,
1203: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1204: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1205: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
1206: p_func_curr IN VARCHAR2,
1207: p_exc_rate IN NUMBER,
1208: p_precision IN NUMBER,
1209: p_min_acc_unit IN NUMBER) IS