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.

Skip to content FND Design Data

[Home] [Help]

View: JAI_CMN_BASE_CURRENCY_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_CMN_BASE_CURRENCY_V

View Text

SELECT BASE_CURRENCY_CODE
, TO_NUMBER(NULL) ORDER_ID
FROM GL_PLCY_MST A
, SY_ORGN_MST B
WHERE A.CO_CODE=B.CO_CODE UNION ALL SELECT BILLING_CURRENCY
, ORDER_ID
FROM OP_ORDR_HDR

Columns

Name
BASE_CURRENCY_CODE
ORDER_ID