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