FND Design Data [Home] [Help]

View: FLM_MMM_LINES_V

Product: FLM - Flow Manufacturing
Description:
Implementation/DBA Data: ViewAPPS.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