View: INVFV_SERIAL_NUMBERS

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

View Text

SELECT MSN.SERIAL_NUMBER
, MSN.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MSN.CURRENT_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MSN.INITIALIZATION_DATE
, MSN.CURRENT_SUBINVENTORY_CODE
, MSN.CURRENT_LOCATOR_ID
, '_KF:INV:MTLL:MIL'
, /* KEYFLEX */ 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
, WIP.WIP_ENTITY_NAME
, MSN.ORIGINAL_UNIT_VENDOR_ID
, PO.VENDOR_NAME
, 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 WIP_ENTITIES WIP
, PO_VENDORS PO
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS MSI
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_ITEM_LOCATIONS MIL
, MTL_SERIAL_NUMBERS MSN WHERE MSI.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
AND MIL.ORGANIZATION_ID (+) = MSN.CURRENT_ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID (+) = MSN.CURRENT_LOCATOR_ID
AND MP.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID AND HOU.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID AND WIP.WIP_ENTITY_ID (+) = MSN.ORIGINAL_WIP_ENTITY_ID AND PO.VENDOR_ID (+) = MSN.ORIGINAL_UNIT_VENDOR_ID
AND '_SEC:MSN.CURRENT_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns