Product: | INV - Inventory |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.MTL_SUMMARY_TEMP_V |
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