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

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

1432:
1433: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert
1434: for je_source is project and je_category is labour_cost');
1435:
1436: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */
1437:
1438: l_string2 := 'SELECT
1439: fv_sf1219_temp_s.NEXTVAL,
1440: glb.je_batch_id,

Line 1490: ar_cash_receipt_history_all arch,

1486: fv_sf1219_definitions_accts fda,
1487: fv_fund_parameters ffp,
1488: fv_treasury_symbols fts,
1489: ar_distributions_all ard,
1490: ar_cash_receipt_history_all arch,
1491: gl_import_references glir,
1492: xla_ae_headers xah,
1493: xla_ae_lines xal,
1494: xla_events xet,

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

1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1608: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1609: END IF;
1610:
1611: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
1612:
1613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert
1614: for je_source is Receivables, based on ar_cash_receipt_history_all');
1615:

Line 1614: for je_source is Receivables, based on ar_cash_receipt_history_all');

1610:
1611: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
1612:
1613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert
1614: for je_source is Receivables, based on ar_cash_receipt_history_all');
1615:
1616: /* Start for je_source is Receivables, based on AR_RECEIVABLE_APPLICATIONS_ALL*/
1617:
1618:

Line 2638: FROM Ar_Cash_Receipt_History_All

2634:
2635: BEGIN
2636: SELECT 'Y'
2637: INTO l_exists
2638: FROM Ar_Cash_Receipt_History_All
2639: WHERE cash_receipt_history_id =
2640: to_number(l_cash_receipt_hist_id)
2641: AND org_id = p_def_org_id;
2642:

Line 2647: 'ID EXISTS IN AR_CASH_RECEIPT_HISTORY_ALL.');

2643: IF (FND_LOG.LEVEL_STATEMENT >=
2644: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2645: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2646: l_module_name,' CASH RECEIPT HIST '||
2647: 'ID EXISTS IN AR_CASH_RECEIPT_HISTORY_ALL.');
2648: END IF;
2649: EXCEPTION
2650: WHEN NO_DATA_FOUND THEN
2651: IF (v_je_category = 'Misc Receipts') -- Misc Receipts

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

2654: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2655: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2656: l_module_name,' FOR MISC RECEIPT: ' ||
2657: 'CASH RECEIPT HIST ID DOES NOT '||
2658: 'exist in Ar_Cash_Receipt_History_All table. ' ||
2659: 'Checking in Ar_Misc_Cash_Distributions_All table.');
2660: END IF;
2661: l_exists := 'M';
2662:

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

2665: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2666: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2667: l_module_name,' FOR TRADE RECEIPT: ' ||
2668: 'CASH RECEIPT HIST ID DOES NOT '||
2669: 'exist in Ar_Cash_Receipt_History_All table. ' ||
2670: ' Checking in Ar_Receivable_Applications_All table.');
2671: END IF;
2672: l_exists := 'C';
2673: END IF; -- Misc Receipts

Line 2704: ' Ar_Cash_Receipt_History_All to see' ||

2700: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2701: l_module_name,' CASH RECEIPT HIST ID '||
2702: L_CASH_RECEIPT_HIST_ID ||', EXISTS IN '||
2703: 'Ar_Receivable_Applications_All. Checking in ' ||
2704: ' Ar_Cash_Receipt_History_All to see' ||
2705: ' if it is a valid id.');
2706: END IF;
2707:
2708: BEGIN

Line 2711: FROM Ar_Cash_Receipt_History_All

2707:
2708: BEGIN
2709: SELECT 'Y'
2710: INTO l_exists
2711: FROM Ar_Cash_Receipt_History_All
2712: WHERE cash_receipt_history_id =
2713: TO_NUMBER(l_cash_receipt_hist_id)
2714: AND org_id = p_def_org_id;
2715:

Line 2720: ' EXISTS IN THE AR_CASH_RECEIPT_HISTORY_ALL '

2716: IF (FND_LOG.LEVEL_STATEMENT >=
2717: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2719: l_module_name,' CASH RECEIPT HIST ID ' ||
2720: ' EXISTS IN THE AR_CASH_RECEIPT_HISTORY_ALL '
2721: ||' TABLE.');
2722: END IF;
2723: EXCEPTION
2724: WHEN NO_DATA_FOUND THEN

Line 2731: ' AR_CASH_RECEIPT_HISTORY_ALL, ' ||

2727: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2728: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2729: l_module_name,' NO_DATA_FOUND ' ||
2730: ' WHEN SELECTING FROM '||
2731: ' AR_CASH_RECEIPT_HISTORY_ALL, ' ||
2732: 'HENCE MANUAL');
2733: END IF;
2734:
2735: WHEN INVALID_NUMBER OR VALUE_ERROR THEN

Line 3209: FROM ar_cash_receipt_history_all

3205:
3206: BEGIN
3207: SELECT 'Y'
3208: INTO l_exists
3209: FROM ar_cash_receipt_history_all
3210: WHERE reversal_cash_receipt_hist_id = l_cash_receipt_hist_id
3211: AND org_id = p_def_org_id;
3212:
3213: EXCEPTION

Line 3220: 'NO_DATA_FOUND: AR_CASH_RECEIPT_HISTORY_ALL '||

3216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3217: then
3218: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3219: l_module_name,
3220: 'NO_DATA_FOUND: AR_CASH_RECEIPT_HISTORY_ALL '||
3221: 'DOES NOT HAVE DATA FOR REVERSAL_CASH_RECEIPT_HIST_ID'
3222: || ' = '|| L_CASH_RECEIPT_HIST_ID);
3223: END IF;
3224: END;

Line 5406: FROM ar_cash_receipt_history_all

5402: -- Get the cash receipt history id
5403: IF p_application_id = 222 THEN
5404: SELECT cash_receipt_history_id
5405: INTO l_cash_receipt_hist_id
5406: FROM ar_cash_receipt_history_all
5407: WHERE cash_receipt_id = p_reference
5408: AND event_id = l_event_id;
5409: END IF;
5410: