FND Design Data [Home] [Help]

View: GMP_PDR_CATEGORY_V

Product: GMP - Process Manufacturing Process Planning
Description: Unique list of categories from msc_item_categories in each organization for an instance.
Implementation/DBA Data: ViewAPPS.GMP_PDR_CATEGORY_V
View Text

SELECT CATEGORY_NAME
, DESCRIPTION
, ORGANIZATION_ID
, SR_INSTANCE_ID
, CATEGORY_SET_ID
FROM MSC_ITEM_CATEGORIES GROUP BY ORGANIZATION_ID
, SR_INSTANCE_ID
, CATEGORY_SET_ID
, CATEGORY_NAME
, DESCRIPTION

Columns

Name
CATEGORY_NAME
DESCRIPTION
ORGANIZATION_ID
SR_INSTANCE_ID
CATEGORY_SET_ID