[Home] [Help]
View: MRP_BIS_ORG_PROFIT_V
Product: | MRP - Master Scheduling/MRP |
Description: | Organization Profit view |
Implementation/DBA Data: |
APPS.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 |