[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 |