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_SF224_TRANSACTIONS dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 2476: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */

2472: l_row := dbms_sql.EXECUTE(l_cur);
2473: dbms_sql.close_cursor(l_cur);
2474: /* END for je_source is project and je_category is labour_cost */
2475: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is project and je_category is labour_cost');
2476: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */
2477:
2478: l_string2 := ' SELECT glb.je_batch_id,
2479: ffp.fund_value,
2480: ffp.description,

Line 2526: ar_cash_receipt_history_all arch,

2522: fv_report_definitions frd,
2523: fv_fund_parameters ffp,
2524: fv_treasury_symbols fts,
2525: ar_distributions_all ard,
2526: ar_cash_receipt_history_all arch,
2527: gl_import_references glir,
2528: xla_ae_headers xah,
2529: xla_ae_lines xal,
2530: xla_events xet,

Line 2587: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/

2583: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2584: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2585: l_row := dbms_sql.EXECUTE(l_cur);
2586: dbms_sql.close_cursor(l_cur);
2587: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables, based on ar_cash_receipt_history_all');
2589: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2590:
2591: l_string2 := ' SELECT glb.je_batch_id,

Line 2588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables, based on ar_cash_receipt_history_all');

2584: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2585: l_row := dbms_sql.EXECUTE(l_cur);
2586: dbms_sql.close_cursor(l_cur);
2587: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert for je_source is Receivables, based on ar_cash_receipt_history_all');
2589: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2590:
2591: l_string2 := ' SELECT glb.je_batch_id,
2592: ffp.fund_value,

Line 3428: FROM Ar_Cash_Receipt_History_All

3424: END;
3425: BEGIN
3426: SELECT 'Y'
3427: INTO l_exists
3428: FROM Ar_Cash_Receipt_History_All
3429: WHERE cash_receipt_history_id = to_number(l_cash_receipt_hist_id)
3430: AND cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3431: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||

Line 3433: 'Ar_Cash_Receipt_History_All.');

3429: WHERE cash_receipt_history_id = to_number(l_cash_receipt_hist_id)
3430: AND cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3431: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||
3433: 'Ar_Cash_Receipt_History_All.');
3434: END IF;
3435: EXCEPTION
3436: WHEN no_data_found THEN
3437: IF(l_je_category = 'Misc Receipts') THEN

Line 3441: 'exist in Ar_Cash_Receipt_History_All table.'||

3437: IF(l_je_category = 'Misc Receipts') THEN
3438: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR MISC RECEIPT: '||
3440: 'Cash Receipt Hist Id does not '||
3441: 'exist in Ar_Cash_Receipt_History_All table.'||
3442: 'Checking in Ar_Misc_Cash_Distributions_All table.');
3443: END IF;
3444: l_exists := 'M';
3445: ELSE

Line 3449: 'exist in Ar_Cash_Receipt_History_All table.'||

3445: ELSE
3446: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3447: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR TRADE RECEIPT: '||
3448: 'Cash Receipt Hist Id does not '||
3449: 'exist in Ar_Cash_Receipt_History_All table.'||
3450: 'Checking in Ar_Receivable_Applications_All table.');
3451: END IF;
3452: l_exists := 'C';
3453: END IF;

Line 3470: 'Ar_Cash_Receipt_History_All to see if it is a valid '||

3466: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||
3468: 'Ar_Receivable_Applications_All table and is '||
3469: TO_NUMBER(l_cash_receipt_hist_id)||'.Checking in '||
3470: 'Ar_Cash_Receipt_History_All to see if it is a valid '||
3471: 'cash receipt hist id.');
3472: END IF;
3473: BEGIN
3474: SELECT 'Y'

Line 3476: FROM Ar_Cash_Receipt_History_All

3472: END IF;
3473: BEGIN
3474: SELECT 'Y'
3475: INTO l_exists
3476: FROM Ar_Cash_Receipt_History_All
3477: WHERE cash_receipt_history_id = TO_NUMBER(l_cash_receipt_hist_id)
3478: AND cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3479: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||

Line 3481: 'the Ar_Cash_Receipt_History_All table.');

3477: WHERE cash_receipt_history_id = TO_NUMBER(l_cash_receipt_hist_id)
3478: AND cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3479: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||
3481: 'the Ar_Cash_Receipt_History_All table.');
3482: END IF;
3483: EXCEPTION
3484: WHEN NO_DATA_FOUND THEN
3485: x_name := 'Invalid Cash Receipt History Id - '

Line 3640: FROM Ar_Cash_Receipt_History_All

3636: ELSE -- rev check
3637: BEGIN
3638: SELECT 'Y'
3639: INTO l_exists
3640: FROM Ar_Cash_Receipt_History_All
3641: WHERE cash_receipt_history_id = l_cash_receipt_hist_id
3642: AND cash_receipt_id = l_cash_receipt_id
3643: AND status='REVERSED';
3644: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4562: sql_stmt:='SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL ac, Ar_Cash_Receipt_History_All ah

4558: WHEN NO_DATA_FOUND THEN
4559: l_reclass_receipt_number:=NULL;
4560: END;
4561: BEGIN
4562: sql_stmt:='SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL ac, Ar_Cash_Receipt_History_All ah
4563: where ac.cash_receipt_id = ah.cash_receipt_id
4564: and ah.cash_receipt_history_id = '|| l_cash_receipt_hist_id ||
4565: ' and ah.STATUS= ''REVERSED'' '||
4566: ' AND ah.CURRENT_RECORD_FLAG = ''Y'' '||