DBA Data[Home] [Help]

VIEW: APPS.ISC_MSC_BIS_COMPONENTS_V

Source

View Text - Preformatted

SELECT DISTINCT BOM.INVENTORY_ITEM_ID ID, ITEM.ITEM_NAME VALUE FROM msc_bom_components bom, msc_system_items item WHERE bom.inventory_item_id = item.inventory_item_id
View Text - HTML Formatted

SELECT DISTINCT BOM.INVENTORY_ITEM_ID ID
, ITEM.ITEM_NAME VALUE
FROM MSC_BOM_COMPONENTS BOM
, MSC_SYSTEM_ITEMS ITEM
WHERE BOM.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID