View: CSP_GET_SERIAL_NUMBERS_V

Product:	CSP - Spares Management
Description:	Get Serial Number associated with part-in Item number
Implementation/DBA Data:	APPS.CSP_GET_SERIAL_NUMBERS_V

View Text

SELECT MSN.CURRENT_ORGANIZATION_ID ORGANIZATION_ID
, MSN.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSN.REVISION REVISION
, MSN.SERIAL_NUMBER SERIAL_NUMBER
, MSN.CURRENT_SUBINVENTORY_CODE SUBINVENTORY_CODE
, MSN.CURRENT_LOCATOR_ID LOCATOR_ID
, MSN.LOT_NUMBER LOT_NUMBER
, MSN.CURRENT_STATUS CURRENT_STATUS
FROM MTL_SERIAL_NUMBERS MSN

Columns