[Home] [Help]
VIEW: APPS.POA_BIS_SUPPERF_ITEM_LOV_V
Source
View Text - Preformatted
SELECT distinct msi.inventory_item_id, msi.concatenated_segments, substr(msi.description,0,55) from mtl_system_items_kfv msi
View Text - HTML Formatted
SELECT DISTINCT MSI.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, SUBSTR(MSI.DESCRIPTION
, 0
, 55)
FROM MTL_SYSTEM_ITEMS_KFV MSI