View: JTF_RS_PLATFORMS_V

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

View Text

SELECT ITEM.INVENTORY_ITEM_ID PLATFORM_ID
, ITEM.ORGANIZATION_ID PLATFORM_ORG_ID
, ITEM.CONCATENATED_SEGMENTS PLATFORM_NAME
, ITEM.DESCRIPTION DESCRIPTION
, ASGN.CATEGORY_ID
FROM MTL_SYSTEM_ITEMS_VL ITEM
, MTL_ITEM_CATEGORIES ASGN
WHERE ITEM.ORGANIZATION_ID = ASGN.ORGANIZATION_ID
AND ITEM.INVENTORY_ITEM_ID = ASGN.INVENTORY_ITEM_ID
AND ASGN.CATEGORY_SET_ID = FND_PROFILE.VALUE('CS_SR_PLATFORM_CATEGORY_SET')

Columns