[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: |
APPS.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 |