[Home] [Help]
View: FLM_MMM_SUM_RESOURCES_V
View Text
SELECT FMOR.PLAN_ID
, FMOR.ORGANIZATION_ID
, FMOR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.RESOURCE_TYPE
, ML.MEANING
, FMOR.OPERATION_TYPE
, SUM(FMOR.WEIGHTED_RESOURCE_USAGE)
, SUM(FMOR.RESOURCE_NEEDED)
, SUM(FMOR.RESOURCE_ASSIGNED)
FROM FLM_MMM_OP_RESOURCES FMOR
, BOM_RESOURCES BR
, MFG_LOOKUPS ML
WHERE BR.RESOURCE_ID(+) = FMOR.RESOURCE_ID
AND ML.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
AND ML.LOOKUP_CODE(+) = BR.RESOURCE_TYPE GROUP BY FMOR.PLAN_ID
, FMOR.ORGANIZATION_ID
, FMOR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.RESOURCE_TYPE
, ML.MEANING
, FMOR.OPERATION_TYPE
Columns
Name |
PLAN_ID |
ORGANIZATION_ID |
RESOURCE_ID |
RESOURCE_CODE |
RESOURCE_TYPE |
RESOURCE_TYPE_DISP |
OPERATION_TYPE |
WEIGHTED_RESOURCE_USAGE |
RESOURCE_NEEDED |
RESOURCE_ASSIGNED |