2 Ответы Последний ответ: 14.12.2017 10:07, автор: LPNO

    Where to find decoding list for TRANSACTION_ACTION

    LPNO

      I have to do some analysis von MTL_MATERIAL_TRANSACTION to determine selections and exclusion of certain TRANSACTION_TYPE_ID. (My histogram query on MTL_MATERIAL_TRANSACTIONS is quite big  - 2.5 mio entries) as it groups over  the columns

       

        ORGANIZATION_ID,

        INVENTORY_ITEM_ID,

        TRANSACTION_TYPE_ID,

        decode(TRANSACTION_SOURCE_ID, NULL, -1,TRANSACTION_SOURCE_ID ),

        TRANSACTION_ACTION_ID,

        TRANSACTION_SOURCE_TYPE_ID.

       

      As I read the transaction_types are unique combinations of a transaction_action (Massnahmen)  and a transaction_source_type (DE Herkunftsart).

       

      Transaction_types.PNG

       

      While grouping my statistical query for further analysis and selection I'd like to decode   TRANSACTION_ACTION_ID,  TRANSACTION_SOURCE_TYPE_ID to make the ID's human readable. The latter is happily decoded by MTL_TXN_SOURCE_TYPES, but I can't find any decoding aid for TRANSACTION_ACTION_ID.

       

      How can I get such translation/Decoding in OEBS R12?

      (eg. some speific decoding table or FND-Access)

       

      Thanks for your hints.