View: INVBV_SERIAL_NUMBERS

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

View Text

SELECT MSN.SERIAL_NUMBER
, MSN.INVENTORY_ITEM_ID
, MSN.CURRENT_ORGANIZATION_ID
, MSN.INITIALIZATION_DATE
, MSN.CURRENT_SUBINVENTORY_CODE
, MSN.CURRENT_LOCATOR_ID
, MSN.REVISION
, MSN.LOT_NUMBER
, '_LA:MSN.CURRENT_STATUS:MFG_LOOKUPS:SERIAL_NUM_STATUS:MEANING' /* LOOKUP */
, MSN.COMPLETION_DATE
, MSN.SHIP_DATE
, MSN.ORIGINAL_WIP_ENTITY_ID
, MSN.ORIGINAL_UNIT_VENDOR_ID
, MSN.VENDOR_SERIAL_NUMBER
, MSN.VENDOR_LOT_NUMBER
, MSN.LAST_TRANSACTION_ID
, MSN.LAST_RECEIPT_ISSUE_TYPE
, MSN.CREATED_BY
, MSN.CREATION_DATE
, MSN.LAST_UPDATED_BY
, MSN.LAST_UPDATE_DATE
, MSN.END_ITEM_UNIT_NUMBER
FROM MTL_SERIAL_NUMBERS MSN
WHERE '_SEC:MSN.CURRENT_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns