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
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
|
|
|