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.FV_RECEIVABLES_ACTIVITY_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 253: AR_PAYMENT_SCHEDULES_ALL aps,

249: hzp1.category_code customer_category_code
250: --fvis.status
251: FROM RA_CUSTOMER_TRX_ALL rct,
252: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd,
253: AR_PAYMENT_SCHEDULES_ALL aps,
254: --RA_CUSTOMERS rc, Bug#4476059 Quick Change
255: hz_cust_accounts hzca1,
256: hz_parties hzp1,
257: FV_RECEIVABLE_TYPES_ALL frt,

Line 297: AR_PAYMENT_SCHEDULES_ALL aps2,

293: rct2.interface_header_attribute3 created_from,
294: hzp2.category_code customer_category_code
295: -- fvis.status
296: FROM RA_CUSTOMER_TRX_ALL rct2,
297: AR_PAYMENT_SCHEDULES_ALL aps2,
298: --RA_CUSTOMERS rc2 Bug#4476059 Quick Change
299: hz_cust_accounts hzca2,
300: hz_parties hzp2
301: -- FV_INVOICE_STATUSES_ALL fvis

Line 317: AR_PAYMENT_SCHEDULES_ALL aps3,

313: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd3,
314: --RA_CUSTOMERS rc3,-- Bug#4476059 Quick Change
315: hz_cust_accounts hzca3,
316: hz_parties hzp3,
317: AR_PAYMENT_SCHEDULES_ALL aps3,
318: FV_RECEIVABLE_TYPES_ALL frt3,
319: FV_REC_CUST_TRX_TYPES_ALL fctt3,
320: -- FV_FUND_PARAMETERS fp3, -- Bug 4655467
321: -- FV_TREASURY_SYMBOLS fts3, -- Bug 4655467

Line 542: FROM ar_payment_schedules_all a

538: l_dm_due_date := recs.due_date;
539: IF recs.class = 'DM' and recs.related_customer_trx_id IS NOT NULL then
540: SELECT nvl(min(due_date),recs.due_date)
541: INTO l_dm_due_date
542: FROM ar_payment_schedules_all a
543: WHERE a.customer_trx_id = recs.related_customer_trx_id
544: AND amount_due_remaining > 0;
545: ELSIF recs.class = 'INV' AND recs.amount_due_remaining > 0 THEN
546: SELECT MIN(payment_schedule_id)

Line 548: FROM ar_payment_schedules_all a

544: AND amount_due_remaining > 0;
545: ELSIF recs.class = 'INV' AND recs.amount_due_remaining > 0 THEN
546: SELECT MIN(payment_schedule_id)
547: INTO l_pay_schedule_id
548: FROM ar_payment_schedules_all a
549: WHERE a.customer_trx_id = recs.customer_trx_id;
550: END IF;
551:
552: IF recs.payment_schedule_id = l_pay_schedule_id THEN

Line 660: FROM ar_payment_schedules_all

656:
657:
658: SELECT min(payment_schedule_id)
659: INTO l_pay_schedule_id
660: FROM ar_payment_schedules_all
661: WHERE customer_trx_id = recs.customer_trx_id
662: AND amount_due_remaining > 0;
663:
664: IF recs.payment_schedule_id = l_pay_schedule_id THEN

Line 1015: AR_PAYMENT_SCHEDULES_ALL aps,

1011: rct.interface_header_attribute3 created_from,
1012: hzp1.category_code customer_category_code
1013: FROM RA_CUSTOMER_TRX_ALL rct,
1014: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd,
1015: AR_PAYMENT_SCHEDULES_ALL aps,
1016: --RA_CUSTOMERS rc, --Bug#4476059 Quick Change
1017: hz_cust_accounts hzca1,
1018: hz_parties hzp1,
1019: FV_RECEIVABLE_TYPES_ALL frt,

Line 1054: ar_payment_schedules_all aps2,

1050: aps2.payment_schedule_id,
1051: rct2.interface_header_attribute3 created_from,
1052: hzp2.category_code customer_category_code
1053: from RA_CUSTOMER_TRX_ALL rct2,
1054: ar_payment_schedules_all aps2,
1055: --ra_customers rc2 --Bug#4476059 Quick Change
1056: hz_cust_accounts hzca2,
1057: hz_parties hzp2
1058: where aps2.class in ('DM','CM')

Line 1073: AR_PAYMENT_SCHEDULES_ALL aps3,

1069: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd3,
1070: --RA_CUSTOMERS rc3, --Bug#4476059 Quick Change
1071: hz_cust_accounts hzca3,
1072: hz_parties hzp3,
1073: AR_PAYMENT_SCHEDULES_ALL aps3,
1074: FV_RECEIVABLE_TYPES_ALL frt3,
1075: FV_REC_CUST_TRX_TYPES_ALL fctt3,
1076: -- FV_FUND_PARAMETERS fp3, -- Bug 4655467
1077: -- FV_TREASURY_SYMBOLS fts3, -- Bug 4655467

Line 1188: ar_payment_schedules_all aps

1184: ara.cash_receipt_id,
1185: aps.class
1186: from ar_receivable_applications_all ara,
1187: ar_cash_receipts_all acr,
1188: ar_payment_schedules_all aps
1189: where ara.cash_receipt_id = acr.cash_receipt_id
1190: and acr.set_of_books_id = vp_sob_id
1191: and nvl(ara.days_late,0) >= 0
1192: and trunc(ara.apply_date) > trunc(aps.due_date)

Line 1258: l_pay_schedule_id ar_payment_schedules_all.payment_schedule_id%type;

1254: l_act_amt NUMBER;
1255: l_cust_trx_id NUMBER;
1256: l_rec_desc_tbl g_rec_desc_type ;
1257:
1258: l_pay_schedule_id ar_payment_schedules_all.payment_schedule_id%type;
1259: schedule_id ar_receivable_applications_all.applied_payment_schedule_id%type;
1260:
1261: dummy varchar2(2);
1262: fc_flag varchar2(2);

Line 1354: FROM ar_payment_schedules_all a

1350:
1351: -- 1A1 Begining FY Balance Number
1352: SELECT MIN(payment_schedule_id)
1353: INTO l_pay_schedule_id
1354: FROM ar_payment_schedules_all a
1355: WHERE a.customer_trx_id = recs.customer_trx_id
1356: AND actual_date_closed > vl_fy_begin_date;
1357:
1358: IF (recs.trx_date < vl_fy_begin_date ) AND

Line 1367: FROM ar_payment_schedules_all a

1363:
1364: -- 1A2 New Receivables Number
1365: SELECT min(payment_schedule_id)
1366: INTO l_pay_schedule_id
1367: FROM ar_payment_schedules_all a
1368: WHERE a.customer_trx_id = recs.customer_trx_id;
1369:
1370: --1A2 New Receivables Amount
1371: IF (recs.trx_date >= vl_fy_begin_date and recs.class = 'INV') THEN