FND Design Data [Home] [Help]

View: GMP_PDR_BUYER_V

Product: GMP - Process Manufacturing Process Planning
Description: Unique list of buyers from msc_system_items in each organization for an instance and plan
Implementation/DBA Data: ViewAPPS.GMP_PDR_BUYER_V
View Text

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

Columns

Name
BUYER_NAME
BUYER_ID
ORGANIZATION_ID
SR_INSTANCE_ID
PLAN_ID