[Home] [Help]
View: RCV_SERIAL_CORRECTION_V
View Text
SELECT SERIAL_TRANSACTION_TYPE
, SERIAL_NUM SERIAL_NUMBER
, USAGE_STATUS_CODE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SHIPMENT_LINE_ID
, TRANSACTION_ID
, LOT_NUM
, TRANSACTION_DATE
, SOURCE_TRANSACTION_ID
, CORRECTION_TRANSACTION_ID
, VENDOR_SERIAL_NUM
, VENDOR_LOT_NUM
FROM RCV_SERIAL_TRANSACTIONS
Columns
| Name |
| SERIAL_TRANSACTION_TYPE |
| SERIAL_NUMBER |
| USAGE_STATUS_CODE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |
| REQUEST_ID |
| PROGRAM_APPLICATION_ID |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| SHIPMENT_LINE_ID |
| TRANSACTION_ID |
| LOT_NUM |
| TRANSACTION_DATE |
| SOURCE_TRANSACTION_ID |
| CORRECTION_TRANSACTION_ID |
| VENDOR_SERIAL_NUM |
| VENDOR_LOT_NUM |