Product: | FLM - Flow Manufacturing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FLM_MMM_PLANS_V |
SELECT FMP.ROWID
, FMP.PLAN_ID
, FMP.ORGANIZATION_ID
, FMP.PLAN_CODE
, FMP.DESCRIPTION
, FMP.LAST_UPDATE_DATE
, FMP.LAST_UPDATED_BY
, FMP.CREATION_DATE
, FMP.CREATED_BY
, FMP.LAST_UPDATE_LOGIN
, FMP.PRODUCT_FAMILY_ID
, FMP.LINE_ID
, WL.LINE_CODE
, WL.DESCRIPTION
, FMP.DEMAND_TYPE
, FMP.DEMAND_CODE
, FMP.START_DATE
, FMP.END_DATE
, FMP.DEMAND_DAYS
, FMP.HOURS_PER_DAY
, FMP.BOOST_PERCENT
, FMP.CALCULATION_OPTION
, FMP.TIME_UOM
, FMP.VIEW_BY
, FMP.PRECISION
FROM FLM_MMM_PLANS FMP
, WIP_LINES WL
WHERE WL.LINE_ID(+) = FMP.LINE_ID