Select /*+ PARRALLEL(ai,16) */ invoice_num,invoice_amount,
DECODE(ai.invoice_currency_code,
'USD',
ai.invoice_amount,
NVL(gdr.conversion_rate, 1) * ai.invoice_amount) USD_Amnt
from apps.ap_invoices_all ai,
apps.gl_daily_rates gdr
where gdr.from_currency = ai.invoice_currency_code
AND gdr.to_currency = 'USD'
AND gdr.conversion_type = ai.exchange_rate_type
and trunc(gdr.conversion_date) = trunc(ai.invoice_date)
and =1
A Language is not worth knowing unless it teaches you to think differently.
Subscribe to:
Post Comments (Atom)
Price List Query for Item
SELECT qph.list_header_id, qph.name, qph.description, qphh.start_date_active, qphh.currency_code, q...
-
1. To download Ldt file for a Concurent Program FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_nam...
-
Here the article will describe about how to register WebADI to Responsibility menu Go to System Administrator --> Security --> Respo...
-
using the below query can check the invoice status. SELECT DECODE(AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS(AIA.INVOICE_...
No comments:
Post a Comment