DBA Data[Home] [Help]

VIEW: APPS.GMP_PDR_CATEGORY_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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