FND Design Data [Home] [Help]

View: JAI_CMN_BASE_CURRENCY_V

Product: JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data: ViewAPPS.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