VIEW: APPS.GMP_PDR_BUYER_V

Source

View Text - Preformatted

SELECT buyer_name, buyer_id, organization_id, sr_instance_id, plan_id FROM msc_system_items WHERE buyer_id IS NOT NULL GROUP BY organization_id, sr_instance_id, plan_id, buyer_name, buyer_id

View Text - HTML Formatted

SELECT BUYER_NAME
, BUYER_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, PLAN_ID
FROM MSC_SYSTEM_ITEMS
WHERE BUYER_ID IS NOT NULL GROUP BY ORGANIZATION_ID
, SR_INSTANCE_ID
, PLAN_ID
, BUYER_NAME
, BUYER_ID