[Home] [Help]
View: FLM_MMM_LINES_V
View Text
SELECT FML.ROWID
, FML.PLAN_ID
, FML.ORGANIZATION_ID
, FML.LINE_ID
, WL.LINE_CODE
, WL.DESCRIPTION
, FML.CALCULATION_OPERATION_TYPE
, FML.LAST_UPDATE_DATE
, FML.LAST_UPDATED_BY
, FML.CREATION_DATE
, FML.CREATED_BY
, FML.LAST_UPDATE_LOGIN
, FML.LINE_TAKT
, FML.HOURS_PER_DAY
, FML.LINE_TAKT_AS_ASSIGNED
, FML.BOTTLENECK_RESOURCE_PERCENT
, FML.BOTTLENECK_IPK_PERCENT
, FML.RESOURCE_UNDERCAPACITY
, FML.IPK_UNDERCAPACITY
FROM FLM_MMM_LINES FML
, WIP_LINES WL
WHERE WL.LINE_ID(+) = FML.LINE_ID
Columns
Name |
ROW_ID |
PLAN_ID |
ORGANIZATION_ID |
LINE_ID |
LINE_CODE |
LINE_DESCRIPTION |
CALCULATION_OPERATION_TYPE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LINE_TAKT |
HOURS_PER_DAY |
LINE_TAKT_AS_ASSIGNED |
BOTTLENECK_RESOURCE_PERCENT |
BOTTLENECK_IPK_PERCENT |
RESOURCE_UNDERCAPACITY |
IPK_UNDERCAPACITY |