Product: | FLM - Flow Manufacturing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FLM_MMM_OP_RESOURCES_V |
SELECT FMOR.ROWID
, FMOR.PLAN_ID
, FMOR.ORGANIZATION_ID
, FMOR.LINE_ID
, WL.LINE_CODE
, FMOR.STANDARD_OPERATION_ID
, BSO.OPERATION_CODE
, BSO.OPERATION_TYPE
, BSO.OPERATION_DESCRIPTION
, BSO.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, FMOR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.RESOURCE_TYPE
, ML.MEANING
, FMOR.LAST_UPDATE_DATE
, FMOR.LAST_UPDATED_BY
, FMOR.CREATION_DATE
, FMOR.CREATED_BY
, FMOR.LAST_UPDATE_LOGIN
, FMOR.WEIGHTED_RESOURCE_USAGE
, FMOR.RESOURCE_NEEDED
, FMOR.RESOURCE_ASSIGNED
, FMO.IPK_NEEDED
, FMO.IPK_ASSIGNED
FROM FLM_MMM_OP_RESOURCES FMOR
, FLM_MMM_OPERATIONS FMO
, BOM_RESOURCES BR
, WIP_LINES WL
, BOM_STANDARD_OPERATIONS BSO
, BOM_DEPARTMENTS BD
, MFG_LOOKUPS ML
WHERE FMO.ORGANIZATION_ID(+) = FMOR.ORGANIZATION_ID
AND FMO.PLAN_ID(+) = FMOR.PLAN_ID
AND FMO.STANDARD_OPERATION_ID(+) = FMOR.STANDARD_OPERATION_ID AND BR.RESOURCE_ID(+) = FMOR.RESOURCE_ID
AND WL.LINE_ID(+) = FMOR.LINE_ID
AND BSO.STANDARD_OPERATION_ID = FMOR.STANDARD_OPERATION_ID
AND BSO.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND ML.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
AND ML.LOOKUP_CODE(+) = BR.RESOURCE_TYPE