FND Design Data [Home] [Help]

View: RCV_SERIAL_CORRECTION_V

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.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