[Home] [Help]
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
Name |
PLATFORM_ID |
PLATFORM_ORG_ID |
PLATFORM_NAME |
DESCRIPTION |
CATEGORY_ID |