View: MTL_OBJECT_NUMBERS_V

Product:	INV - Inventory
Description:	View of the genealogy object numbers
Implementation/DBA Data:	APPS.MTL_OBJECT_NUMBERS_V

View Text

SELECT LOT.GEN_OBJECT_ID
, 1
, LOT.LOT_NUMBER
, LOT.ORGANIZATION_ID
, LOT.INVENTORY_ITEM_ID
FROM MTL_LOT_NUMBERS LOT UNION ALL SELECT SER.GEN_OBJECT_ID
, 2
, SER.SERIAL_NUMBER
, SER.CURRENT_ORGANIZATION_ID
, SER.INVENTORY_ITEM_ID
FROM MTL_SERIAL_NUMBERS SER UNION ALL SELECT MEO.OBJECT_ID
, 3
, MEO.OBJECT_NUMBER
, -1
, -1
FROM MTL_EXT_OBJECTS MEO

Columns