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_CONFIRMATION dependencies on AR_RECEIVABLE_APPLICATIONS_S

Line 1460: SELECT ar_receivable_applications_s.nextval

1456: --Retrieve sequence id for receivable application id of UNAPP record
1457: --Note as this procedure creates a single UNAPP record hence this kind
1458: --of select from dual for sequence id is done
1459:
1460: SELECT ar_receivable_applications_s.nextval
1461: INTO l_unapp_id
1462: FROM dual;
1463:
1464: --Insert negative UNAPP record for confirmed APP record

Line 2097: SELECT ar_receivable_applications_s.nextval

2093:
2094: FOR l_app_rec IN get_app LOOP
2095:
2096: --retrieve sequence
2097: SELECT ar_receivable_applications_s.nextval
2098: INTO l_new_app_id
2099: FROM dual;
2100:
2101: --Create actual reversing apps

Line 2274: ar_receivable_applications_s.nextval,

2270: -- create new unconfirmed records from old confirmed records:
2271:
2272: SELECT
2273: receivable_application_id,
2274: ar_receivable_applications_s.nextval,
2275: acctd_amount_applied_from,
2276: amount_applied,
2277: DECODE(status,
2278: 'UNAPP', '40.0',