Product: | FLM - Flow Manufacturing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FLM_MMM_OPERATIONS_V |
SELECT FMO.ROWID
, FMO.PLAN_ID
, FMO.ORGANIZATION_ID
, FMO.STANDARD_OPERATION_ID
, BSO.OPERATION_CODE
, BSO.SEQUENCE_NUM
, BSO.OPERATION_DESCRIPTION
, FMO.LAST_UPDATE_DATE
, FMO.LAST_UPDATED_BY
, FMO.CREATION_DATE
, FMO.CREATED_BY
, FMO.LAST_UPDATE_LOGIN
, FMO.LINE_ID
, WL.LINE_CODE
, FMO.OPERATION_TYPE
, FMO.OPERATION_TAKT
, FMO.MACHINE_WEIGHTED_TIME
, FMO.LABOR_WEIGHTED_TIME
, FMO.ELAPSED_WEIGHTED_TIME
, FMO.IPK_NEEDED
, FMO.IPK_ASSIGNED
, FMO.OP_TAKT_AS_ASSIGNED
, FMO.BOTTLENECK_RESOURCE_PERCENT
, FMO.PROCESS_EFFICIENCY
, FMO.RESOURCE_UNDERCAPACITY
FROM FLM_MMM_OPERATIONS FMO
, BOM_STANDARD_OPERATIONS BSO
, WIP_LINES WL
WHERE WL.LINE_ID(+) = FMO.LINE_ID
AND BSO.STANDARD_OPERATION_ID(+) = FMO.STANDARD_OPERATION_ID