View: JTF_RS_PRODUCTS_V

Product:	JTF - CRM Foundation
Description:	Stores all valid products for which resource skills can be assigned.
Implementation/DBA Data:	APPS.JTF_RS_PRODUCTS_V

View Text

SELECT MSIK.INVENTORY_ITEM_ID PRODUCT_ID
, MSIK.ORGANIZATION_ID PRODUCT_ORG_ID
, MSIK.CONCATENATED_SEGMENTS PRODUCT_NAME
, MSIK.DESCRIPTION
, MSIK.ENABLED_FLAG
FROM MTL_SYSTEM_ITEMS_KFV MSIK
WHERE NVL(MSIK.SERVICE_ITEM_FLAG
, 'N') = 'N'

Columns