[Home] [Help]
View: MTL_MATERIAL_TXNS_TEMP_VIEW
Product: | INV - Inventory |
Description: | A View of MTL_MATERIAL_TRANSACTIONS_TEMP used in an Inquiry form |
Implementation/DBA Data: |
APPS.MTL_MATERIAL_TXNS_TEMP_VIEW
|
View Text
SELECT REQUEST_ID
, TRANSACTION_MODE
, COUNT(*)
, TRANSACTION_HEADER_ID
FROM MTL_MATERIAL_TRANSACTIONS_TEMP GROUP BY TRANSACTION_HEADER_ID
, REQUEST_ID
, TRANSACTION_MODE
Columns
Name |
REQUEST_ID |
TRANSACTION_MODE |
NUMBER_OF_RECORDS |
TRANSACTION_HEADER_ID |