View: MTL_SERIAL_NUMBER_GEN_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_SERIAL_NUMBER_GEN_V

View Text

SELECT MSN.INVENTORY_ITEM_ID
, MSIV.CONCATENATED_SEGMENTS
, MSN.SERIAL_NUMBER
, MSN.CURRENT_ORGANIZATION_ID
FROM MTL_SYSTEM_ITEMS_KFV MSIV
, MTL_SERIAL_NUMBERS MSN
WHERE MSIV.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
AND MSIV.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID
AND MSN.CURRENT_STATUS = 3

Columns