[Home] [Help]
VIEW: APPS.MSC_SERVICE_ITEMS_V
Source
View Text - Preformatted
SELECT DISTINCT CAT.INVENTORY_ITEM_ID ,CAT.ORGANIZATION_ID ,CAT.SR_INSTANCE_ID FROM MSC_ITEM_CATEGORIES CAT WHERE CAT.CATEGORY_SET_ID= MSC_UTIL.GET_SERVICE_ITEMS_CATSET_ID
View Text - HTML Formatted
SELECT DISTINCT CAT.INVENTORY_ITEM_ID
, CAT.ORGANIZATION_ID
, CAT.SR_INSTANCE_ID
FROM MSC_ITEM_CATEGORIES CAT
WHERE CAT.CATEGORY_SET_ID= MSC_UTIL.GET_SERVICE_ITEMS_CATSET_ID