[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 |