FND Design Data [Home] [Help]

View: RCV_TRX_INT_SERIALS_V

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