FND Design Data [Home] [Help]

View: JAI_PO_CURRENCY_CODE_V

Product: JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data: ViewAPPS.JAI_PO_CURRENCY_CODE_V
View Text

SELECT CURRENCY_CODE
, PO_HEADER_ID
, TO_NUMBER(NULL) ORGANIZATION_ID
FROM PO_HEADERS_ALL UNION ALL SELECT CURRENCY_CODE
, TO_NUMBER(NULL)
, ORGANIZATION_ID
FROM GL_SETS_OF_BOOKS GSB
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE GSB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID

Columns

Name
CURRENCY_CODE
PO_HEADER_ID
ORGANIZATION_ID