eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MTL_TRX_TYPES_VIEW

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_TRX_TYPES_VIEW

View Text

SELECT TP.TRANSACTION_TYPE_NAME
, TP.TRANSACTION_TYPE_ID
, TP.TRANSACTION_SOURCE_TYPE_ID
, TP.TRANSACTION_ACTION_ID
, TP.DESCRIPTION
, SRC.DESCRIPTIVE_FLEX_CONTEXT_CODE
, SRC.TRANSACTION_SOURCE_TYPE_NAME
, TP.TYPE_CLASS
, LOCATION_REQUIRED_FLAG
FROM MTL_TRANSACTION_TYPES TP
, MTL_TXN_SOURCE_TYPES SRC
WHERE TP.TRANSACTION_SOURCE_TYPE_ID = SRC.TRANSACTION_SOURCE_TYPE_ID
AND NVL(TP.DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND NVL(SRC.DISABLE_DATE
, SYSDATE+1) > SYSDATE

Columns

Name
TRANSACTION_TYPE_NAME
TRANSACTION_TYPE_ID
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_ACTION_ID
DESCRIPTION
DESCRIPTIVE_FLEX_CONTEXT_CODE
TRANSACTION_SOURCE_TYPE_NAME
TYPE_CLASS
LOCATION_REQUIRED_FLAG