VIEW: APPS.FLM_MMM_OPERATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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