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_TRX_SUMMARY_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 7: ar_payment_schedules_all.customer_id%type

3:
4: /* Globals */
5: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
6: TYPE l_cust_id_type IS TABLE OF
7: ar_payment_schedules_all.customer_id%type
8: INDEX BY BINARY_INTEGER;
9:
10: t_cust_id l_cust_id_type;
11:

Line 141: FROM AR_PAYMENT_SCHEDULES_ALL C

137: 0 LAST_RECEIPT_AMOUNT,
138: TO_DATE(NULL) LAST_RECEIPT_DATE,
139: NULL LAST_RECEIPT_NUMBER,
140: SUM(C.AMOUNT_ADJUSTED_PENDING) PENDING_ADJ_AMT
141: FROM AR_PAYMENT_SCHEDULES_ALL C
142: WHERE C.payment_schedule_id > 0
143: AND C.customer_id is not null
144: AND C.org_id is not null
145: GROUP BY C.CUSTOMER_ID,

Line 591: FROM AR_PAYMENT_SCHEDULES_all ps,

587: null,ra.earned_discount_taken), null)) edisc_taken,
588: sum(decode(ps.class, 'INV',
589: decode(ra.unearned_discount_taken,0,
590: null,ra.unearned_discount_taken), null)) unedisc_taken
591: FROM AR_PAYMENT_SCHEDULES_all ps,
592: AR_RECEIVABLE_APPLICATIONS_ALL RA
593: WHERE RA.APPLIED_PAYMENT_SCHEDULE_ID(+) = PS.PAYMENT_SCHEDULE_ID
594: AND RA.CREATION_DATE(+) <= l_program_start_date
595: AND RA.DISPLAY(+) = 'Y'

Line 730: from ar_payment_schedules_all ps,

726: sum(decode(ps.class, 'INV', decode(ra.unearned_discount_taken,0,null,ra.unearned_discount_taken), null)) unedisc_taken,
727: sum(decode(ps.class, 'INV',decode(nvl(ra.unearned_discount_taken,0),0,null,1),null)) unedisc_count,
728: sum(decode(ps.class, 'INV',
729: (ra.apply_date - ps.due_date)* ra.amount_applied, null)) app_amt_days_late
730: from ar_payment_schedules_all ps,
731: ra_terms_b rt,
732: ar_receivable_applications_all ra
733: where ps.payment_schedule_id = ra.applied_payment_schedule_id
734: and ps.customer_id > 0

Line 791: from ar_payment_schedules_all ps,

787: 0 unedisc_count,
788: 0 app_amt_days_late,
789: sum(adj.amount) adj_amount,
790: count(adjustment_id) adj_count
791: from ar_payment_schedules_all ps,
792: ar_adjustments_all adj
793: where ps.payment_schedule_id = adj.payment_schedule_id
794: and adj.receivables_trx_id(+) > 0
795: and ps.trx_date > add_months(sysdate, -24)

Line 854: from ar_payment_schedules_all

850: customer_trx_id desc) rank_amount
851: from ( select customer_id,customer_site_use_id,
852: invoice_currency_code,customer_trx_id,
853: trx_date,SUM(amount_due_original) amount
854: from ar_payment_schedules_all
855: where class = '||''''||'INV'||''''||
856: ' and customer_id > 0
857: and trx_date >= add_months(sysdate, -24)
858: group by customer_id,customer_site_use_id,

Line 977: from ar_payment_schedules_all ps

973: as_of_date , sum(net_amount) net_amount
974: from
975: (select ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
976: ps.trx_date as_of_date, sum(ps.amount_due_original) net_amount
977: from ar_payment_schedules_all ps
978: where ps.class in ('||''''||'INV'||''''||','
979: ||''''||'CM'||''''||','
980: ||''''||'DM'||''''||','
981: ||''''||'DEP'||''''||','

Line 993: from ar_payment_schedules_all ps,

989: ra.apply_date as_of_date,
990: sum(-ra.amount_applied
991: -nvl(ra.earned_discount_taken,0)
992: -nvl(ra.unearned_discount_taken,0)) net_amount
993: from ar_payment_schedules_all ps,
994: ar_receivable_applications_all ra
995: where ps.payment_schedule_id = ra.applied_payment_schedule_id
996: and ps.customer_id > 0
997: and ra.status = '||''''||'APP'||''''||'

Line 1011: from ar_payment_schedules_all ps,

1007: ps.invoice_currency_code, ra.apply_date
1008: union all
1009: select ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
1010: adj.apply_date as_of_date, sum(adj.amount)
1011: from ar_payment_schedules_all ps,
1012: ar_adjustments_all adj
1013: where ps.payment_schedule_id = adj.payment_schedule_id
1014: and ps.class in ('||''''||'INV'||''''||','
1015: ||''''||'CM'||''''||','

Line 1151: FROM ar_payment_schedules_all

1147: p_cust_id IN OUT NOCOPY l_cust_id_type) IS
1148:
1149: CURSOR c_cust_all IS
1150: SELECT DISTINCT customer_id
1151: FROM ar_payment_schedules_all
1152: WHERE MOD(customer_id, p_max_workers) = p_worker_number
1153: AND payment_schedule_id > 0;
1154:
1155: CURSOR c_cust_active IS

Line 1157: FROM ar_payment_schedules_all

1153: AND payment_schedule_id > 0;
1154:
1155: CURSOR c_cust_active IS
1156: SELECT DISTINCT customer_id
1157: FROM ar_payment_schedules_all
1158: WHERE MOD(customer_id, p_max_workers) = p_worker_number
1159: AND payment_schedule_id > 0
1160: AND trx_date > add_months(sysdate, -24);
1161:

Line 1508: FROM AR_PAYMENT_SCHEDULES_ALL C

1504: 0 LAST_RECEIPT_AMOUNT,
1505: TO_DATE(NULL) LAST_RECEIPT_DATE,
1506: NULL LAST_RECEIPT_NUMBER,
1507: SUM(C.AMOUNT_ADJUSTED_PENDING) PENDING_ADJ_AMT
1508: FROM AR_PAYMENT_SCHEDULES_ALL C
1509: WHERE c.customer_id = p_cust_id(i)
1510: GROUP BY C.CUSTOMER_ID,
1511: C.CUSTOMER_SITE_USE_ID,
1512: C.INVOICE_CURRENCY_CODE ,

Line 1807: FROM AR_PAYMENT_SCHEDULES_all ps,

1803: null,ra.earned_discount_taken), null)) edisc_taken,
1804: sum(decode(ps.class, 'INV',
1805: decode(ra.unearned_discount_taken,0,
1806: null,ra.unearned_discount_taken), null)) unedisc_taken
1807: FROM AR_PAYMENT_SCHEDULES_all ps,
1808: AR_RECEIVABLE_APPLICATIONS_ALL RA
1809: WHERE RA.APPLIED_PAYMENT_SCHEDULE_ID(+) = PS.PAYMENT_SCHEDULE_ID
1810: AND RA.DISPLAY(+) = 'Y'
1811: AND RA.STATUS(+) = 'APP'

Line 1942: from ar_payment_schedules_all ps,

1938: sum(decode(ps.class, 'INV', decode(ra.unearned_discount_taken,0,null,ra.unearned_discount_taken), null)) unedisc_taken,
1939: sum(decode(ps.class, 'INV',decode(nvl(ra.unearned_discount_taken,0),0,null,1),null)) unedisc_count,
1940: sum(decode(ps.class, 'INV',
1941: (ra.apply_date - ps.due_date) * ra.amount_applied, null)) app_amt_days_late
1942: from ar_payment_schedules_all ps,
1943: ra_terms_b rt,
1944: ar_receivable_applications_all ra
1945: where ps.payment_schedule_id = ra.applied_payment_schedule_id
1946: and ps.customer_id = p_cust_id(i)

Line 2002: from ar_payment_schedules_all ps,

1998: 0 unedisc_count,
1999: 0 app_amt_days_late,
2000: sum(adj.amount) adj_amount,
2001: count(adjustment_id) adj_count
2002: from ar_payment_schedules_all ps,
2003: ar_adjustments_all adj
2004: where ps.customer_id = p_cust_id(i)
2005: and ps.payment_schedule_id = adj.payment_schedule_id
2006: and adj.receivables_trx_id(+) > 0

Line 2066: from ar_payment_schedules_all ps,

2062: customer_trx_id desc) rank_amount
2063: from ( select ps.customer_id, ps.customer_site_use_id,
2064: ps.invoice_currency_code, ps.customer_trx_id,
2065: ps.trx_date, SUM(ps.amount_due_original) amount
2066: from ar_payment_schedules_all ps,
2067: ar_cust_search_gt gt
2068: where ps.customer_id = gt.customer_id
2069: and ps.class = '||''''||'INV'||''''||
2070: ' and trx_date >= add_months(sysdate, -24)

Line 2200: from ar_payment_schedules_all ps

2196: as_of_date , sum(net_amount) net_amount
2197: from
2198: (select ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
2199: ps.trx_date as_of_date, sum(ps.amount_due_original) net_amount
2200: from ar_payment_schedules_all ps
2201: where ps.class in ('||''''||'INV'||''''||','
2202: ||''''||'CM'||''''||','
2203: ||''''||'DM'||''''||','
2204: ||''''||'DEP'||''''||','

Line 2216: from ar_payment_schedules_all ps,

2212: ra.apply_date as_of_date,
2213: sum(-ra.amount_applied
2214: -nvl(ra.earned_discount_taken,0)
2215: -nvl(ra.unearned_discount_taken,0)) net_amount
2216: from ar_payment_schedules_all ps,
2217: ar_receivable_applications_all ra
2218: where ps.payment_schedule_id = ra.applied_payment_schedule_id
2219: and ps.customer_id in (select customer_id from cust_list)
2220: and ra.status = '||''''||'APP'||''''||'

Line 2234: from ar_payment_schedules_all ps,

2230: ps.invoice_currency_code, ra.apply_date
2231: union all
2232: select ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
2233: adj.apply_date as_of_date, sum(adj.amount)
2234: from ar_payment_schedules_all ps,
2235: ar_adjustments_all adj
2236: where ps.payment_schedule_id = adj.payment_schedule_id
2237: and ps.class in ('||''''||'INV'||''''||','
2238: ||''''||'CM'||''''||','