[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 |