[Home] [Help]
| Product: | FLM - Flow Manufacturing |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.FLM_MMM_LINES_V
|
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