VIEW: MSD.MSD_DEMAND_PLANS#

Source

View Text - Preformatted

select DEMAND_PLAN_ID DEMAND_PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, DEMAND_PLAN_NAME DEMAND_PLAN_NAME, DESCRIPTION DESCRIPTION, CALENDAR_TYPE CALENDAR_TYPE, CALENDAR_CODE CALENDAR_CODE, PERIOD_SET_NAME PERIOD_SET_NAME, BASE_UOM BASE_UOM, AVERAGE_DISCOUNT AVERAGE_DISCOUNT, CATEGORY_SET_ID CATEGORY_SET_ID, LOWEST_PERIOD_TYPE LOWEST_PERIOD_TYPE, HISTORY_START_DATE HISTORY_START_DATE, 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, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SR_INSTANCE_ID SR_INSTANCE_ID, VALID_FLAG VALID_FLAG, ENABLE_FCST_EXPLOSION ENABLE_FCST_EXPLOSION, DELETE_PLAN_FLAG DELETE_PLAN_FLAG, ROUNDOFF_THREASHOLD ROUNDOFF_THREASHOLD, ROUNDOFF_DECIMAL_PLACES ROUNDOFF_DECIMAL_PLACES, AMT_THRESHOLD AMT_THRESHOLD, AMT_DECIMAL_PLACES AMT_DECIMAL_PLACES, DP_BUILD_ERROR_FLAG DP_BUILD_ERROR_FLAG, DP_BUILD_REFRESH_NUM DP_BUILD_REFRESH_NUM, G_MIN_TIM_LVL_ID G_MIN_TIM_LVL_ID, M_MIN_TIM_LVL_ID M_MIN_TIM_LVL_ID, F_MIN_TIM_LVL_ID F_MIN_TIM_LVL_ID, C_MIN_TIM_LVL_ID C_MIN_TIM_LVL_ID, STRIPE_INSTANCE STRIPE_INSTANCE, STRIPE_LEVEL_ID STRIPE_LEVEL_ID, STRIPE_SR_LEVEL_PK STRIPE_SR_LEVEL_PK, BUILD_STRIPE_LEVEL_PK BUILD_STRIPE_LEVEL_PK, ROUNDING_LEVEL_ID ROUNDING_LEVEL_ID, STRIPE_STREAM_NAME STRIPE_STREAM_NAME, STRIPE_STREAM_DESIG STRIPE_STREAM_DESIG, BUILD_STRIPE_STREAM_NAME BUILD_STRIPE_STREAM_NAME, BUILD_STRIPE_STREAM_DESIG BUILD_STRIPE_STREAM_DESIG, BUILD_STRIPE_STREAM_REF_NUM BUILD_STRIPE_STREAM_REF_NUM, USE_ORG_SPECIFIC_BOM_FLAG USE_ORG_SPECIFIC_BOM_FLAG, DELETE_REQUEST_ID DELETE_REQUEST_ID, TEMPLATE_FLAG TEMPLATE_FLAG, TEMPLATE_ID TEMPLATE_ID, DEFAULT_TEMPLATE DEFAULT_TEMPLATE, PLAN_TYPE PLAN_TYPE, LIAB_PLAN_ID LIAB_PLAN_ID, LIAB_PLAN_NAME LIAB_PLAN_NAME, PLAN_START_DATE PLAN_START_DATE, PLAN_END_DATE PLAN_END_DATE, PREV_LIAB_PUB_PLAN_START_DATE PREV_LIAB_PUB_PLAN_START_DATE, PREVIOUS_PLAN_START_DATE PREVIOUS_PLAN_START_DATE, LIABILITY_REVISION_NUM LIABILITY_REVISION_NUM, ZD_EDITION_NAME ZD_EDITION_NAME from "MSD"."MSD_DEMAND_PLANS"

View Text - HTML Formatted

SELECT DEMAND_PLAN_ID DEMAND_PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DEMAND_PLAN_NAME DEMAND_PLAN_NAME
, DESCRIPTION DESCRIPTION
, CALENDAR_TYPE CALENDAR_TYPE
, CALENDAR_CODE CALENDAR_CODE
, PERIOD_SET_NAME PERIOD_SET_NAME
, BASE_UOM BASE_UOM
, AVERAGE_DISCOUNT AVERAGE_DISCOUNT
, CATEGORY_SET_ID CATEGORY_SET_ID
, LOWEST_PERIOD_TYPE LOWEST_PERIOD_TYPE
, HISTORY_START_DATE HISTORY_START_DATE
, 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
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SR_INSTANCE_ID SR_INSTANCE_ID
, VALID_FLAG VALID_FLAG
, ENABLE_FCST_EXPLOSION ENABLE_FCST_EXPLOSION
, DELETE_PLAN_FLAG DELETE_PLAN_FLAG
, ROUNDOFF_THREASHOLD ROUNDOFF_THREASHOLD
, ROUNDOFF_DECIMAL_PLACES ROUNDOFF_DECIMAL_PLACES
, AMT_THRESHOLD AMT_THRESHOLD
, AMT_DECIMAL_PLACES AMT_DECIMAL_PLACES
, DP_BUILD_ERROR_FLAG DP_BUILD_ERROR_FLAG
, DP_BUILD_REFRESH_NUM DP_BUILD_REFRESH_NUM
, G_MIN_TIM_LVL_ID G_MIN_TIM_LVL_ID
, M_MIN_TIM_LVL_ID M_MIN_TIM_LVL_ID
, F_MIN_TIM_LVL_ID F_MIN_TIM_LVL_ID
, C_MIN_TIM_LVL_ID C_MIN_TIM_LVL_ID
, STRIPE_INSTANCE STRIPE_INSTANCE
, STRIPE_LEVEL_ID STRIPE_LEVEL_ID
, STRIPE_SR_LEVEL_PK STRIPE_SR_LEVEL_PK
, BUILD_STRIPE_LEVEL_PK BUILD_STRIPE_LEVEL_PK
, ROUNDING_LEVEL_ID ROUNDING_LEVEL_ID
, STRIPE_STREAM_NAME STRIPE_STREAM_NAME
, STRIPE_STREAM_DESIG STRIPE_STREAM_DESIG
, BUILD_STRIPE_STREAM_NAME BUILD_STRIPE_STREAM_NAME
, BUILD_STRIPE_STREAM_DESIG BUILD_STRIPE_STREAM_DESIG
, BUILD_STRIPE_STREAM_REF_NUM BUILD_STRIPE_STREAM_REF_NUM
, USE_ORG_SPECIFIC_BOM_FLAG USE_ORG_SPECIFIC_BOM_FLAG
, DELETE_REQUEST_ID DELETE_REQUEST_ID
, TEMPLATE_FLAG TEMPLATE_FLAG
, TEMPLATE_ID TEMPLATE_ID
, DEFAULT_TEMPLATE DEFAULT_TEMPLATE
, PLAN_TYPE PLAN_TYPE
, LIAB_PLAN_ID LIAB_PLAN_ID
, LIAB_PLAN_NAME LIAB_PLAN_NAME
, PLAN_START_DATE PLAN_START_DATE
, PLAN_END_DATE PLAN_END_DATE
, PREV_LIAB_PUB_PLAN_START_DATE PREV_LIAB_PUB_PLAN_START_DATE
, PREVIOUS_PLAN_START_DATE PREVIOUS_PLAN_START_DATE
, LIABILITY_REVISION_NUM LIABILITY_REVISION_NUM
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "MSD"."MSD_DEMAND_PLANS"