AR Cross Currency Exchange Gain/Loss

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Cross Currency Exchange Gain/Loss Report
Application: Receivables
Source: Cross Currency Exchange Gain/Loss Report (XML)
Short Name: ARXFXGL_XML
DB package: AR_ARXFXGL_XMLP_PKG
Run AR Cross Currency Exchange Gain/Loss and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT  	cash.customer_name              		Customer_Name,
        	cash.location                   		Location,
        	cash.cash_receipt_id		Receipt_Id,
	cash.receipt_number             		Receipt_Number,
        	cash.receipt_date               		Receipt_Date,
        	cash.amount                     		Receipt_Amount,
        	cash.currency_code              		Receipt_Currency,
	cash.exchange_rate			Receipt_Exchange_Rate,
	trx.trx_number			Trx_Id,
        	trx.trx_number                  		Trx_Number,
        	trx.trx_date                    		Trx_Date,
        	trx.invoice_currency_code       		Trx_Currency,
        	apps.amount_applied             		Trx_Amt_Applied,
        	apps.acctd_amount_applied_to	Trx_Amt_Applied_Base,
        	apps.amount_applied_from        	Actual_Alloc_Receipt_Amt,
        	apps.acctd_amount_applied_from  	Actual_Alloc_Receipt_Amt_Base,
        	apps.trans_to_receipt_rate	 	Actual_Cross_Curr_Rate,
	curr.precision			Receipt_Precision,
	AR_ARXFXGL_XMLP_PKG.actual_cross_curr_rate_dformul(apps.trans_to_receipt_rate) Actual_Cross_Curr_Rate_D,
	--AR_ARXFXGL_XMLP_PKG.allocated_amount_rateformula(:Rate_Sys_Curr_Rate) Rate_Alloc_Receipt_Amt,
	AR_ARXFXGL_XMLP_PKG.allocated_amount_rateformula(apps.amount_applied,curr.precision,:Rate_Sys_Curr_Rate) Rate_Alloc_Receipt_Amt,
	--AR_ARXFXGL_XMLP_PKG.rate_alloc_receipt_amt_basefor(:Rate_Sys_Curr_Rate) Rate_Alloc_Receipt_Amt_Base,
	AR_ARXFXGL_XMLP_PKG.rate_alloc_receipt_amt_basefor(:Rate_Sys_Curr_Rate,:Rate_Alloc_Receipt_Amt,cash.exchange_rate) Rate_Alloc_Receipt_Amt_Base,
	--AR_ARXFXGL_XMLP_PKG.actual_gainformula(:Actual_Gain_Loss) Actual_Gain,
	AR_ARXFXGL_XMLP_PKG.actual_gainformula(AR_ARXFXGL_XMLP_PKG.cf_gain_loss_actualfo(apps.acctd_amount_applied_from, apps.acctd_amount_applied_to)) Actual_Gain,
	--AR_ARXFXGL_XMLP_PKG.actual_rate_lossformula(:Actual_Gain_Loss) Actual_Loss,
	AR_ARXFXGL_XMLP_PKG.actual_rate_lossformula(AR_ARXFXGL_XMLP_PKG.cf_gain_loss_actualfo(apps.acctd_amount_applied_from, apps.acctd_amount_applied_to)) Actual_Loss,
	AR_ARXFXGL_XMLP_PKG.cf_gain_loss_actualfo(apps.acctd_amount_applied_from, apps.acctd_amount_applied_to) Actual_Gain_Loss,
	--AR_ARXFXGL_XMLP_PKG.sys_cross_currencyformula() Rate_Sys_Curr_Rate,
	AR_ARXFXGL_XMLP_PKG.sys_cross_currencyformula(trx.invoice_currency_code,cash.currency_code,cash.receipt_date) Rate_Sys_Curr_Rate,
	AR_ARXFXGL_XMLP_PKG.rate_sys_curr_rate_dformula(:Rate_Sys_Curr_Rate) Rate_Sys_Curr_Rate_D,
	AR_ARXFXGL_XMLP_PKG.rate_gainformula(:Rate_Gain_Loss) Rate_Gain,
	AR_ARXFXGL_XMLP_PKG.rate_lossformula(:Rate_Gain_Loss) Rate_Loss,
	AR_ARXFXGL_XMLP_PKG.rate_gain_lossformula(:Rate_Alloc_Receipt_Amt_Base, apps.acctd_amount_applied_to) Rate_Gain_Loss,
	AR_ARXFXGL_XMLP_PKG.absolute_differenceformula(:Actual_Gain_Loss, :Rate_Gain_Loss) Absolute_Difference
--from        	Actual_Alloc_Receipt_Amt,
--        	apps.acctd_amount_applied_from  	Actual_Alloc_Receipt_Amt_Base,
--        	apps.trans_to_receipt_rate	 	Actual_Cross_Curr_Rate,
--	curr.precision			Receipt_Precision
FROM    	fnd_currencies		curr,
	ra_customer_trx		trx,
        	ar_cash_receipts_v		cash,
        	ar_receivable_applications	apps
WHERE   	curr.currency_code = cash.currency_code
AND	apps.applied_customer_trx_id = trx.customer_trx_id
AND     	apps.cash_receipt_id = cash.cash_receipt_id
AND     	apps.status = 'APP'
AND     	cash.currency_code != trx.invoice_currency_code
&Where_Customer
&Where_Location
&Where_Date
&Where_Currency
/*ORDER BY
        	cash.customer_name,
        	cash.location,
        	cash.currency_code,
        	cash.receipt_number,
        	trx.trx_date,
        	trx.invoice_currency_code,
        	trx.trx_number*/
order by 1,18,2,3,4,5,6,7,8,12,9,11,10,13,14,15,16,17
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
Customer Name 
 
 LOV Oracle
Customer Site 
 
 LOV Oracle
From Receipt Date 
 
 Date
To Receipt Date 
 
 Date
Receipt Currency 
 
 LOV Oracle
Exchange Rate Type 
 
 LOV Oracle
Download
 
Related Blitz Reports
AR Format Automatic Receipts JG Receipt Acknowledgment Letter- Not Supported: Reserved For Future Use AR Aging - 7 Buckets - By Salesperson/Agent AR Open Balances Revaluation AR Potential Reconciling Items OKL Receipt Inquiry GL Account Analysis JL Colombian Receivables Cash Receipt Report- Not Supported: Reserved For Future Use AR Transactions and Payments
Blitz Report™

Blitz Report™ provides multiple benefits: