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 2351: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */

2347: l_row := dbms_sql.EXECUTE(l_cur);
2348: dbms_sql.close_cursor(l_cur);
2349: /* END for je_source is project and je_category is labour_cost */
2350: 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');
2351: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */
2352:
2353: l_string2 := ' SELECT glb.je_batch_id,
2354: ffp.fund_value,
2355: ffp.description,

Line 2401: ar_cash_receipt_history_all arch,

2397: fv_report_definitions frd,
2398: fv_fund_parameters ffp,
2399: fv_treasury_symbols fts,
2400: ar_distributions_all ard,
2401: ar_cash_receipt_history_all arch,
2402: gl_import_references glir,
2403: xla_ae_headers xah,
2404: xla_ae_lines xal,
2405: xla_events xet,

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

2457: dbms_sql.bind_variable(l_cur,':b_login_id',g_login_id);
2458: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2459: l_row := dbms_sql.EXECUTE(l_cur);
2460: dbms_sql.close_cursor(l_cur);
2461: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2462: 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');
2463: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2464:
2465: l_string2 := ' SELECT glb.je_batch_id,

Line 2462: 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');

2458: dbms_sql.bind_variable(l_cur,':b_request_id',g_request_id);
2459: l_row := dbms_sql.EXECUTE(l_cur);
2460: dbms_sql.close_cursor(l_cur);
2461: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
2462: 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');
2463: /* Start for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL */
2464:
2465: l_string2 := ' SELECT glb.je_batch_id,
2466: ffp.fund_value,

Line 3293: FROM Ar_Cash_Receipt_History_All

3289: END;
3290: BEGIN
3291: SELECT 'Y'
3292: INTO l_exists
3293: FROM Ar_Cash_Receipt_History_All
3294: WHERE cash_receipt_history_id = to_number(l_cash_receipt_hist_id)
3295: AND cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3296: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3297: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||

Line 3298: 'Ar_Cash_Receipt_History_All.');

3294: WHERE cash_receipt_history_id = to_number(l_cash_receipt_hist_id)
3295: AND cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3296: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3297: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||
3298: 'Ar_Cash_Receipt_History_All.');
3299: END IF;
3300: EXCEPTION
3301: WHEN no_data_found THEN
3302: IF(l_je_category = 'Misc Receipts') THEN

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

3302: IF(l_je_category = 'Misc Receipts') THEN
3303: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR MISC RECEIPT: '||
3305: 'Cash Receipt Hist Id does not '||
3306: 'exist in Ar_Cash_Receipt_History_All table.'||
3307: 'Checking in Ar_Misc_Cash_Distributions_All table.');
3308: END IF;
3309: l_exists := 'M';
3310: ELSE

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

3310: ELSE
3311: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3312: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR TRADE RECEIPT: '||
3313: 'Cash Receipt Hist Id does not '||
3314: 'exist in Ar_Cash_Receipt_History_All table.'||
3315: 'Checking in Ar_Receivable_Applications_All table.');
3316: END IF;
3317: l_exists := 'C';
3318: END IF;

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

3331: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3332: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||
3333: 'Ar_Receivable_Applications_All table and is '||
3334: TO_NUMBER(l_cash_receipt_hist_id)||'.Checking in '||
3335: 'Ar_Cash_Receipt_History_All to see if it is a valid '||
3336: 'cash receipt hist id.');
3337: END IF;
3338: BEGIN
3339: SELECT 'Y'

Line 3341: FROM Ar_Cash_Receipt_History_All

3337: END IF;
3338: BEGIN
3339: SELECT 'Y'
3340: INTO l_exists
3341: FROM Ar_Cash_Receipt_History_All
3342: WHERE cash_receipt_history_id = TO_NUMBER(l_cash_receipt_hist_id)
3343: AND cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3344: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3345: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||

Line 3346: 'the Ar_Cash_Receipt_History_All table.');

3342: WHERE cash_receipt_history_id = TO_NUMBER(l_cash_receipt_hist_id)
3343: AND cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3344: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3345: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT HIST ID EXISTS IN '||
3346: 'the Ar_Cash_Receipt_History_All table.');
3347: END IF;
3348: EXCEPTION
3349: WHEN NO_DATA_FOUND THEN
3350: x_name := 'Invalid Cash Receipt History Id - '

Line 3505: FROM Ar_Cash_Receipt_History_All

3501: ELSE -- rev check
3502: BEGIN
3503: SELECT 'Y'
3504: INTO l_exists
3505: FROM Ar_Cash_Receipt_History_All
3506: WHERE cash_receipt_history_id = l_cash_receipt_hist_id
3507: AND cash_receipt_id = l_cash_receipt_id
3508: AND status='REVERSED';
3509: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4420: WHEN NO_DATA_FOUND THEN
4421: l_reclass_receipt_number:=NULL;
4422: END;
4423: BEGIN
4424: sql_stmt:='SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL ac, Ar_Cash_Receipt_History_All ah
4425: where ac.cash_receipt_id = ah.cash_receipt_id
4426: and ah.cash_receipt_history_id = '|| l_cash_receipt_hist_id ||
4427: ' and ah.STATUS= ''REVERSED'' '||
4428: ' AND ah.CURRENT_RECORD_FLAG = ''Y'' '||