VIEW: MSD.MSD_DP_FORMULAS#

Source

View Text - Preformatted

select DEMAND_PLAN_ID DEMAND_PLAN_ID, FORMULA_ID FORMULA_ID, CREATION_SEQUENCE CREATION_SEQUENCE, FORMULA_NAME FORMULA_NAME, FORMULA_DESC FORMULA_DESC, CUSTOM_FIELD1 CUSTOM_FIELD1, CUSTOM_FIELD2 CUSTOM_FIELD2, CUSTOM_TYPE CUSTOM_TYPE, CUSTOM_SUBTYPE CUSTOM_SUBTYPE, CUSTOM_ADDTLCALC CUSTOM_ADDTLCALC, EQUATION EQUATION, ISBY ISBY, SUPPLY_PLAN_FLAG SUPPLY_PLAN_FLAG, SUPPLY_PLAN_NAME SUPPLY_PLAN_NAME, VALID_FLAG VALID_FLAG, NUMERATOR NUMERATOR, DENOMINATOR DENOMINATOR, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, FORMAT FORMAT, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, UPLOAD_FORMULA_ID UPLOAD_FORMULA_ID, START_PERIOD START_PERIOD from "MSD"."MSD_DP_FORMULAS"

View Text - HTML Formatted

SELECT DEMAND_PLAN_ID DEMAND_PLAN_ID
, FORMULA_ID FORMULA_ID
, CREATION_SEQUENCE CREATION_SEQUENCE
, FORMULA_NAME FORMULA_NAME
, FORMULA_DESC FORMULA_DESC
, CUSTOM_FIELD1 CUSTOM_FIELD1
, CUSTOM_FIELD2 CUSTOM_FIELD2
, CUSTOM_TYPE CUSTOM_TYPE
, CUSTOM_SUBTYPE CUSTOM_SUBTYPE
, CUSTOM_ADDTLCALC CUSTOM_ADDTLCALC
, EQUATION EQUATION
, ISBY ISBY
, SUPPLY_PLAN_FLAG SUPPLY_PLAN_FLAG
, SUPPLY_PLAN_NAME SUPPLY_PLAN_NAME
, VALID_FLAG VALID_FLAG
, NUMERATOR NUMERATOR
, DENOMINATOR DENOMINATOR
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, FORMAT FORMAT
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, UPLOAD_FORMULA_ID UPLOAD_FORMULA_ID
, START_PERIOD START_PERIOD
FROM "MSD"."MSD_DP_FORMULAS"