APPS.AR_TRX_SUMMARY_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 170: FROM AR_PAYMENT_SCHEDULES_ALL C

166: 0 LAST_RECEIPT_AMOUNT,
167: TO_DATE(NULL) LAST_RECEIPT_DATE,
168: NULL LAST_RECEIPT_NUMBER,
169: SUM(C.AMOUNT_ADJUSTED_PENDING) PENDING_ADJ_AMT
170: FROM AR_PAYMENT_SCHEDULES_ALL C
171: WHERE c.customer_id >0
172: GROUP BY C.CUSTOMER_ID,
173: C.CUSTOMER_SITE_USE_ID,
174: C.INVOICE_CURRENCY_CODE ,

Line 468: FROM AR_PAYMENT_SCHEDULES_all ps,

464: null,ra.earned_discount_taken), null)) edisc_taken,
465: sum(decode(ps.class, 'INV',
466: decode(ra.unearned_discount_taken,0,
467: null,ra.unearned_discount_taken), null)) unedisc_taken
468: FROM AR_PAYMENT_SCHEDULES_all ps,
469: AR_RECEIVABLE_APPLICATIONS_ALL RA,
470: ( select history_id, payment_schedule_id, due_date, amount_in_dispute
471: from ar_trx_summary_hist
472: where history_id in

Line 619: from ar_payment_schedules_all ps,

615: sum(decode(ps.class, 'INV', decode(ra.unearned_discount_taken,0,null,ra.unearned_discount_taken), null)) unedisc_taken,
616: sum(decode(ps.class, 'INV',decode(nvl(ra.unearned_discount_taken,0),0,null,1),null)) unedisc_count,
617: sum(decode(ps.class, 'INV',
618: (ra.apply_date - nvl(trx_hist.due_date, ps.due_date))* ra.amount_applied, null)) app_amt_days_late
619: from ar_payment_schedules_all ps,
620: ( select history_id, payment_schedule_id, due_date, amount_in_dispute
621: from ar_trx_summary_hist
622: where history_id in
623: (select max(history_id)

Line 689: from ar_payment_schedules_all ps,

685: 0 unedisc_count,
686: 0 app_amt_days_late,
687: sum(adj.amount) adj_amount,
688: count(adjustment_id) adj_count
689: from ar_payment_schedules_all ps,
690: ar_adjustments_all adj
691: where ps.payment_schedule_id = adj.payment_schedule_id
692: and adj.receivables_trx_id(+) > 0
693: and ps.trx_date > add_months(sysdate, -24)

Line 750: from ar_payment_schedules_all

746: customer_trx_id desc) rank_amount
747: from ( select customer_id,customer_site_use_id,
748: invoice_currency_code,customer_trx_id,
749: trx_date,SUM(amount_due_original) amount
750: from ar_payment_schedules_all
751: where class = '||''''||'INV'||''''||
752: ' and customer_id > 0
753: and trx_date >= add_months(sysdate, -24)
754: group by customer_id,customer_site_use_id,

Line 872: from ar_payment_schedules_all ps

868: as_of_date , sum(net_amount) net_amount
869: from
870: (select ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
871: ps.trx_date as_of_date, sum(ps.amount_due_original) net_amount
872: from ar_payment_schedules_all ps
873: where ps.class in ('||''''||'INV'||''''||','
874: ||''''||'CM'||''''||','
875: ||''''||'DM'||''''||','
876: ||''''||'DEP'||''''||','

Line 888: from ar_payment_schedules_all ps,

884: ra.apply_date as_of_date,
885: sum(-ra.amount_applied
886: -nvl(ra.earned_discount_taken,0)
887: -nvl(ra.unearned_discount_taken,0)) net_amount
888: from ar_payment_schedules_all ps,
889: ar_receivable_applications_all ra
890: where ps.payment_schedule_id = ra.applied_payment_schedule_id
891: and ps.customer_id > 0
892: and ra.status = '||''''||'APP'||''''||'

Line 905: from ar_payment_schedules_all ps,

901: ps.invoice_currency_code, ra.apply_date
902: union all
903: select ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
904: adj.apply_date as_of_date, sum(adj.amount)
905: from ar_payment_schedules_all ps,
906: ar_adjustments_all adj
907: where ps.payment_schedule_id = adj.payment_schedule_id
908: and ps.class in ('||''''||'INV'||''''||','
909: ||''''||'CM'||''''||','

Line 924: from ar_payment_schedules_all ps,

920: ra.apply_date as_of_date,
921: sum(nvl(ra.amount_applied_from, ra.amount_applied)
922: + nvl(ra.earned_discount_taken,0)
923: + nvl(ra.unearned_discount_taken,0)) net_amount
924: from ar_payment_schedules_all ps,
925: ar_receivable_applications_all ra
926: where ps.payment_schedule_id = ra.payment_schedule_id
927: and ps.class in ('||''''||'CM'||''''||')
928: and ra.status = '||''''||'APP'||''''||'