Product: | AX - Global Accounting Engine |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT AET.ROWID
, AET.CATEGORY_CODE
, AET.SET_OF_BOOKS_ID
, AET.APPLICATION_ID
, AET.EVENT_TYPE
, AET.LAST_UPDATE_DATE
, AET.LAST_UPDATED_BY
, AET.CREATION_DATE
, AET.CREATED_BY
, AET.LAST_UPDATE_LOGIN
, AET.DESCRIPTION
, AET.ENABLED_FLAG
, AET.TRANSLATION_SCHEME
, AET.DIRECT_FLAG
, AET.USER_EXIT
, AET.INCLUDE_IN_PROGRAM_FLAG
, FA.APPLICATION_NAME APPLICATION_NAME
, GSOB.NAME SET_OF_BOOKS_NAME
, AECV.CATEGORY_NAME CATEGORY_NAME
, AET.POSTING_SET_OF_BOOKS_ID
, GSOB2.NAME SET_OF_BOOKS_NAME
FROM AX_EVENT_TYPES AET
, GL_SETS_OF_BOOKS GSOB
, GL_SETS_OF_BOOKS GSOB2
, AX_EVENT_CATEGORY_V AECV
, FND_APPLICATION_VL FA
WHERE FA.APPLICATION_ID = AET.APPLICATION_ID
AND AET.CATEGORY_CODE = AECV.CATEGORY_CODE
AND AET.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND AET.POSTING_SET_OF_BOOKS_ID = GSOB2.SET_OF_BOOKS_ID