[Home] [Help]
View: RCV_TRX_INT_SERIALS_V
View Text
SELECT RSS.SERIAL_NUM SERIAL_NUMBER
, RSS.SHIPMENT_LINE_ID
, RSL.TO_ORGANIZATION_ID
, RSL.ITEM_ID
, RSS.LOT_NUM LOT_NUMBER
FROM RCV_SERIALS_SUPPLY RSS
, RCV_SHIPMENT_LINES RSL
WHERE RSS.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID
Columns
Name |
SERIAL_NUMBER |
SHIPMENT_LINE_ID |
TO_ORGANIZATION_ID |
ITEM_ID |
LOT_NUMBER |