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