FND Design Data [Home] [Help]

View: AX_TRANS_SCHEMES_V

Product: AX - Global Accounting Engine
Description:
Implementation/DBA Data: Not implemented in this database
View Text

SELECT SET_OF_BOOKS_ID
, APPLICATION_ID
, TRANSLATION_SCHEME USER_SCHEME
, TRANSLATION_SCHEME
, ENABLED_FLAG
FROM AX_TRANS_SCHEMES UNION SELECT DISTINCT TS.SET_OF_BOOKS_ID
, TS.APPLICATION_ID
, L.MEANING
, L.LOOKUP_CODE
, L.ENABLED_FLAG
FROM AX_TRANS_SCHEMES TS
, AX_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'AX_FIXED_SCHEMES'
AND L.LOOKUP_CODE = 'NOOP_SCHEME'

Columns

Name
SET_OF_BOOKS_ID
APPLICATION_ID
USER_SCHEME
TRANSLATION_SCHEME
ENABLED_FLAG