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_ADJUSTMENTS_ALL

Line 19: vp_write_off_activity_1 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;

15: vp_retcode NUMBER ;
16: vp_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE ;
17: vp_nonfed_customer_class ar_lookups.lookup_code%TYPE;
18: vp_type_of_receivable FV_RECEIVABLE_TYPES_ALL.receivable_type%TYPE ;
19: vp_write_off_activity_1 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;
20: vp_write_off_activity_2 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;
21: vp_write_off_activity_3 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;
22:
23: --Bug 5414783

Line 20: vp_write_off_activity_2 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;

16: vp_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE ;
17: vp_nonfed_customer_class ar_lookups.lookup_code%TYPE;
18: vp_type_of_receivable FV_RECEIVABLE_TYPES_ALL.receivable_type%TYPE ;
19: vp_write_off_activity_1 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;
20: vp_write_off_activity_2 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;
21: vp_write_off_activity_3 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;
22:
23: --Bug 5414783
24: --vp_org_id NUMBER; -- Bug 4655467

Line 21: vp_write_off_activity_3 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;

17: vp_nonfed_customer_class ar_lookups.lookup_code%TYPE;
18: vp_type_of_receivable FV_RECEIVABLE_TYPES_ALL.receivable_type%TYPE ;
19: vp_write_off_activity_1 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;
20: vp_write_off_activity_2 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;
21: vp_write_off_activity_3 AR_ADJUSTMENTS_ALL.Receivables_trx_id%type;
22:
23: --Bug 5414783
24: --vp_org_id NUMBER; -- Bug 4655467
25:

Line 1116: FROM ar_adjustments_all ara,

1112: ara.customer_trx_id,
1113: hzp1.category_code customer_category_code,
1114: ara.type,
1115: rctt.type trx_type
1116: FROM ar_adjustments_all ara,
1117: ra_customer_trx_all rct,
1118: --ra_customers rc, --Bug#4476059 Quick Change
1119: hz_cust_accounts hzca1,
1120: hz_parties hzp1,

Line 1336: from ar_adjustments_all

1332: IF (recs.trx_date < vl_fy_begin_date ) and
1333: recs.actual_date_closed > vl_fy_begin_date THEN
1334: select nvl(sum(amount),0)
1335: into l_adj_amount
1336: from ar_adjustments_all
1337: where customer_trx_id = recs.customer_trx_id
1338: and apply_date < vl_fy_begin_date + 1;
1339:
1340: select nvl(sum(amount_applied),0) * -1