DBA Data[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