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_SUMMARY_TEMP_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_SUMMARY_TEMP_V

View Text

SELECT MST.SESSION_ID
, MST.SUMMARY_TYPE
, MST.SUBINVENTORY
, MST.LOCATOR_ID
, MST.TRANSACTION_SOURCE_TYPE_NAME
, MST.TRANSACTION_TYPE_NAME
, MST.TRANSACTION_ACTION_NAME
, MST.INVENTORY_ITEM_ID
, MST.ORGANIZATION_ID
, MSIK.PADDED_CONCATENATED_SEGMENTS
, MST.NET_QTY
, MST.NET_VAL
, MST.NUM_TXNS
, MST.ABS_QTY
, MST.ABS_VAL
FROM MTL_SUMMARY_TEMP MST
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE MST.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MST.ORGANIZATION_ID = MSIK.ORGANIZATION_ID

Columns

Name
SESSION_ID
SUMMARY_TYPE
SUBINVENTORY
LOCATOR_ID
TRANSACTION_SOURCE_TYPE_NAME
TRANSACTION_TYPE_NAME
TRANSACTION_ACTION_NAME
INVENTORY_ITEM_ID
ORGANIZATION_ID
PADDED_CONCATENATED_SEGMENTS
NET_QTY
NET_VAL
NUM_TXNS
ABS_QTY
ABS_VAL