eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FLM_MMM_LINE_RESOURCES_V

Product:	FLM - Flow Manufacturing
Description:
Implementation/DBA Data:	APPS.FLM_MMM_LINE_RESOURCES_V

View Text

SELECT FMOR.PLAN_ID
, FMOR.ORGANIZATION_ID
, FMOR.LINE_ID
, FMOR.OPERATION_TYPE
, FMOR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.RESOURCE_TYPE
, ML.MEANING
, 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.LINE_ID
, FMOR.OPERATION_TYPE
, FMOR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.RESOURCE_TYPE
, ML.MEANING

Columns

Name
PLAN_ID
ORGANIZATION_ID
LINE_ID
OPERATION_TYPE
RESOURCE_ID
RESOURCE_CODE
RESOURCE_TYPE
RESOURCE_TYPE_DISP
WEIGHTED_RESOURCE_USAGE
RESOURCE_NEEDED
RESOURCE_ASSIGNED