This view gives the detail of the Service Item like Name, Unit of Measure etc.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT INVENTORY_ITEM_ID , SEGMENT1 , DESCRIPTION , ORGANIZATION_ID , PRIMARY_UNIT_OF_MEASURE FROM MTL_SYSTEM_ITEMS_B WHERE ENABLED_FLAG ='Y' AND NVL(START_DATE_ACTIVE , SYSDATE) <= SYSDATE AND NVL(END_DATE_ACTIVE , SYSDATE) >= SYSDATE AND CUSTOMER_ORDER_FLAG ='Y' AND CUSTOMER_ORDER_ENABLED_FLAG ='Y' AND INVENTORY_ITEM_STATUS_CODE ='ACTIVE' AND ORDERABLE_ON_WEB_FLAG ='Y' AND SERVICEABLE_PRODUCT_FLAG = 'Y' AND CONTRACT_ITEM_TYPE_CODE ='SUBSCRIPTION'