FND Design Data [Home] [Help]

View: MRP_BIS_ORG_PROFIT_V

Product: MRP - Master Scheduling/MRP
Description: Organization Profit view
Implementation/DBA Data: ViewAPPS.MRP_BIS_ORG_PROFIT_V
View Text

SELECT COMPILE_DESIGNATOR
, OWNING_ORG_ID
, ORGANIZATION_ID
, SUM(PLAN_COST)
, SUM(PLAN_REVENUE)
FROM MRP_BIS_PLAN_PROFIT GROUP BY COMPILE_DESIGNATOR
, OWNING_ORG_ID
, ORGANIZATION_ID

Columns

Name
COMPILE_DESIGNATOR
OWNING_ORG_ID
ORGANIZATION_ID
PLAN_COST
PLAN_REVENUE