[Home] [Help]
View: INVFV_INVENTORY_TXN_TYPES
View Text
SELECT MTT.TRANSACTION_TYPE_ID
, MTT.TRANSACTION_TYPE_NAME
, MTT.DESCRIPTION
, '_LA:MTT.TRANSACTION_ACTION_ID:MFG_LOOKUPS:MTL_TRANSACTION_ACTION:MEANING'
, MTT.TRANSACTION_SOURCE_TYPE_ID
, MTS.TRANSACTION_SOURCE_TYPE_NAME
, MTT.DISABLE_DATE
, MTT.USER_DEFINED_FLAG
, MTT.TYPE_CLASS
FROM MTL_TXN_SOURCE_TYPES MTS
, MTL_TRANSACTION_TYPES MTT
WHERE MTS.TRANSACTION_SOURCE_TYPE_ID = MTT.TRANSACTION_SOURCE_TYPE_ID WITH READ ONLY
Columns
Name |
TRANSACTION_TYPE_ID |
TRANSACTION_TYPE_NAME |
DESCRIPTION |
"_LA:TRANSACTION_ACTION" |
TRANSACTION_SOURCE_TYPE_ID |
TRANSACTION_SOURCE_TYPE_NAME |
INACTIVE_DATE |
USER_DEFINED_FLAG |
TYPE_CLASS |