VIEW: FLM.FLM_MMM_PLANS#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, PLAN_CODE PLAN_CODE, DESCRIPTION DESCRIPTION, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PRODUCT_FAMILY_ID PRODUCT_FAMILY_ID, LINE_ID LINE_ID, DEMAND_TYPE DEMAND_TYPE, DEMAND_CODE DEMAND_CODE, START_DATE START_DATE, END_DATE END_DATE, DEMAND_DAYS DEMAND_DAYS, HOURS_PER_DAY HOURS_PER_DAY, BOOST_PERCENT BOOST_PERCENT, CALCULATION_OPTION CALCULATION_OPTION, TIME_UOM TIME_UOM, VIEW_BY VIEW_BY, PRECISION PRECISION from "FLM"."FLM_MMM_PLANS"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PLAN_CODE PLAN_CODE
, DESCRIPTION DESCRIPTION
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PRODUCT_FAMILY_ID PRODUCT_FAMILY_ID
, LINE_ID LINE_ID
, DEMAND_TYPE DEMAND_TYPE
, DEMAND_CODE DEMAND_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, DEMAND_DAYS DEMAND_DAYS
, HOURS_PER_DAY HOURS_PER_DAY
, BOOST_PERCENT BOOST_PERCENT
, CALCULATION_OPTION CALCULATION_OPTION
, TIME_UOM TIME_UOM
, VIEW_BY VIEW_BY
, PRECISION PRECISION
FROM "FLM"."FLM_MMM_PLANS"