VIEW: APPS.FLM_MMM_OP_RESOURCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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