VIEW: APPS.MTL_SUMMARY_TEMP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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