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_BF_BILL dependencies on AR_RECEIVABLE_APPLICATIONS

Line 297: UPDATE ar_receivable_applications

293: AND CI.cons_inv_id = IT.cons_inv_id
294: AND CI.cons_inv_id in (select cons_inv_id from ar_cons_inv i
295: where i.status = 'PRE_REJECTED'));
296:
297: UPDATE ar_receivable_applications
298: SET cons_inv_id = NULL
299: WHERE receivable_application_id IN
300: (SELECT IT.adj_ps_id
301: FROM ar_cons_inv CI,

Line 310: UPDATE ar_receivable_applications

306: AND CI.cons_inv_id = IT.cons_inv_id
307: AND CI.cons_inv_id in (select cons_inv_id from ar_cons_inv i
308: where i.status = 'PRE_REJECTED'));
309:
310: UPDATE ar_receivable_applications
311: SET cons_inv_id_to = NULL
312: WHERE receivable_application_id IN
313: (SELECT IT.adj_ps_id
314: FROM ar_cons_inv CI,

Line 1411: FROM ar_receivable_applications ra

1407: INTO l_cm_flag
1408: FROM RA_CUSTOMER_TRX ct,
1409: AR_PAYMENT_SCHEDULES ps
1410: WHERE ct.customer_trx_id IN (Select ra.APPLIED_CUSTOMER_TRX_ID
1411: FROM ar_receivable_applications ra
1412: WHERE ra.customer_trx_id = l_inv_trx.trx_id
1413: AND ra.status = 'APP'
1414: AND ra.application_type = 'CM'
1415: AND ra.apply_date <= l_billing_date

Line 1433: FROM ar_receivable_applications

1429: -- Added code to handle the case of receipt being applied against CM and CM.
1430: If l_cm_flag = 0 THEN
1431: SELECT count(*)
1432: INTO l_cm_flag
1433: FROM ar_receivable_applications
1434: WHERE APPLIED_CUSTOMER_TRX_ID = l_inv_trx.trx_id
1435: AND status = 'APP'
1436: AND application_type = 'CASH'
1437: AND cash_receipt_id IS NOT NULL;

Line 1800: FROM ar_receivable_applications ra,

1796: AND nvl(PS.exclude_from_cons_bill_flag, 'N') <> 'Y'
1797: AND (PS.status = 'OP'
1798: OR (ps.amount_due_original +
1799: (SELECT nvl(SUM(nvl(ra.amount_applied_from, ra.amount_applied)), 0)
1800: FROM ar_receivable_applications ra,
1801: ar_payment_schedules ps_inv,
1802: ra_customer_trx inv_trx
1803: WHERE ra.cash_receipt_id = cr.cash_receipt_id
1804: AND inv_trx.customer_trx_id = ra.applied_customer_trx_id

Line 1887: ar_receivable_applications RA,

1883: RA.receivable_application_id,
1884: NULL,
1885: ps_cash.org_id
1886: FROM
1887: ar_receivable_applications RA,
1888: ar_payment_schedules ps_cash,
1889: ar_payment_schedules ps_inv
1890: WHERE
1891: RA.cons_inv_id IS NULL

Line 1948: ar_receivable_applications RA,

1944: RA.receivable_application_id,
1945: NULL,
1946: ps_cash.org_id
1947: FROM
1948: ar_receivable_applications RA,
1949: ar_payment_schedules ps_cash,
1950: ar_payment_schedules ps_inv
1951: WHERE
1952: RA.cons_inv_id_to IS NULL

Line 2005: ar_receivable_applications ra,

2001: NULL,
2002: ps_cash.org_id
2003: FROM
2004: ar_cons_inv_trx inv_trx,
2005: ar_receivable_applications ra,
2006: ar_payment_schedules ps_cash,
2007: ar_payment_schedules ps_inv
2008: WHERE ra.cons_inv_id_to is not null
2009: AND ra.cons_inv_id is null

Line 2051: ar_receivable_applications ra,

2047: NULL,
2048: ps_cash.org_id
2049: FROM
2050: ar_cons_inv_trx inv_trx,
2051: ar_receivable_applications ra,
2052: ar_payment_schedules ps_cash,
2053: ar_payment_schedules ps_inv
2054: WHERE ra.cons_inv_id_to is null
2055: AND ra.cons_inv_id is not null

Line 2095: AR_RECEIVABLE_APPLICATIONS RA ,

2091: NULL,
2092: PS_CM.org_id
2093: FROM
2094: AR_PAYMENT_SCHEDULES PS_CM ,
2095: AR_RECEIVABLE_APPLICATIONS RA ,
2096: AR_PAYMENT_SCHEDULES PS_INV,
2097: AR_CONS_INV_TRX CTRX,
2098: AR_CONS_INV C
2099: WHERE

Line 2140: ar_receivable_applications RA,

2136: RA.receivable_application_id,
2137: NULL,
2138: PS_CM.org_id
2139: FROM
2140: ar_receivable_applications RA,
2141: ar_payment_schedules PS_CM,
2142: ar_payment_schedules PS_INV
2143: WHERE
2144: RA.cons_inv_id_to IS NULL

Line 2196: ar_receivable_applications RA,

2192: RA.receivable_application_id,
2193: NULL,
2194: PS_INV.org_id
2195: FROM
2196: ar_receivable_applications RA,
2197: ar_payment_schedules PS_INV, -- INV
2198: ar_payment_schedules PS_CM -- CM
2199: WHERE
2200: RA.cons_inv_id_to IS NULL

Line 2261: FROM ar_receivable_applications ra,

2257: AND nvl(PS.exclude_from_cons_bill_flag, 'N') <> 'Y'
2258: AND (PS.status = 'OP'
2259: OR (ps.amount_due_original +
2260: (SELECT nvl(SUM(nvl(ra.amount_applied_from, ra.amount_applied)), 0)
2261: FROM ar_receivable_applications ra,
2262: ar_payment_schedules ps_inv,
2263: ra_customer_trx inv_trx
2264: WHERE ra.cash_receipt_id = cr.cash_receipt_id
2265: AND inv_trx.customer_trx_id = ra.applied_customer_trx_id

Line 2370: ar_receivable_applications RA,

2366: RA.receivable_application_id,
2367: NULL,
2368: ps_cash.org_id
2369: FROM
2370: ar_receivable_applications RA,
2371: ar_payment_schedules ps_cash,
2372: ra_customer_trx inv_trx,
2373: ar_payment_schedules ps_app
2374: WHERE

Line 2421: ar_receivable_applications RA,

2417: RA.receivable_application_id,
2418: NULL,
2419: ps_cash.org_id
2420: FROM
2421: ar_receivable_applications RA,
2422: ar_payment_schedules ps_cash
2423: WHERE
2424: RA.cons_inv_id IS NULL
2425: AND RA.applied_payment_schedule_id = -3

Line 2499: /** For Site: update ar_payment_schedules, ar_receivable_applications

2495: ending_balance = beginning_balance + l_period_trx + l_period_receipts +
2496: l_period_adj + l_period_credits + l_period_finchrg
2497: WHERE cons_inv_id = l_consinv_id;
2498:
2499: /** For Site: update ar_payment_schedules, ar_receivable_applications
2500: and ar_adjustments **/
2501:
2502: write_debug_and_log('Updating AR_PAYMENT_SCHEDULES');
2503:

Line 2521: write_debug_and_log('Updating AR_RECEIVABLE_APPLICATIONS');

2517: FROM ar_cons_inv_trx IT
2518: WHERE IT.cons_inv_id = l_consinv_id
2519: AND IT.transaction_type = 'RECEIPT REV');
2520:
2521: write_debug_and_log('Updating AR_RECEIVABLE_APPLICATIONS');
2522:
2523: UPDATE ar_receivable_applications RA
2524: SET RA.cons_inv_id = l_consinv_id
2525: WHERE RA.receivable_application_id IN

Line 2523: UPDATE ar_receivable_applications RA

2519: AND IT.transaction_type = 'RECEIPT REV');
2520:
2521: write_debug_and_log('Updating AR_RECEIVABLE_APPLICATIONS');
2522:
2523: UPDATE ar_receivable_applications RA
2524: SET RA.cons_inv_id = l_consinv_id
2525: WHERE RA.receivable_application_id IN
2526: (SELECT IT.adj_ps_id
2527: FROM ar_cons_inv_trx IT

Line 2538: UPDATE ar_receivable_applications RA

2534: 'EXCLUDE_CMREV',
2535: 'RECEIPT ADJUST',
2536: 'DELAY_CMAPP')); -- Bug 8946152
2537:
2538: UPDATE ar_receivable_applications RA
2539: SET RA.cons_inv_id_to = l_consinv_id
2540: WHERE RA.receivable_application_id IN
2541: (SELECT IT.adj_ps_id
2542: FROM ar_cons_inv_trx IT