VIEW: CSP.CSP_PLANNING_PARAMETERS#

Source

View Text - Preformatted

select PLANNING_PARAMETERS_ID PLANNING_PARAMETERS_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FORECAST_RULE_ID FORECAST_RULE_ID, CALCULATION_RULE_ID CALCULATION_RULE_ID, ORGANIZATION_TYPE ORGANIZATION_TYPE, ORGANIZATION_ID ORGANIZATION_ID, SECONDARY_INVENTORY SECONDARY_INVENTORY, SERVICE_LEVEL SERVICE_LEVEL, EDQ_FACTOR EDQ_FACTOR, PLANNER_CODE PLANNER_CODE, CONDITION_TYPE CONDITION_TYPE, ASL_FLAG ASL_FLAG, SAFETY_STOCK_FLAG SAFETY_STOCK_FLAG, EXCESS_RULE_ID EXCESS_RULE_ID, 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, SECURITY_GROUP_ID SECURITY_GROUP_ID, CATEGORY_SET_ID CATEGORY_SET_ID, CATEGORY_ID CATEGORY_ID, RECOMMEND_METHOD RECOMMEND_METHOD, EDQ_MULTIPLE EDQ_MULTIPLE, MINIMUM_VALUE MINIMUM_VALUE, USABLE_ASSIGNMENT_SET_ID USABLE_ASSIGNMENT_SET_ID, DEFECTIVE_ASSIGNMENT_SET_ID DEFECTIVE_ASSIGNMENT_SET_ID, PRODUCT_NORM PRODUCT_NORM, DEFAULT_FORECAST_RULE_ID DEFAULT_FORECAST_RULE_ID, DEFAULT_SERVICE_LEVEL DEFAULT_SERVICE_LEVEL, DEFAULT_EDQ_FACTOR DEFAULT_EDQ_FACTOR, DEFAULT_PLANNER_CODE DEFAULT_PLANNER_CODE, DEFAULT_CONDITION_TYPE DEFAULT_CONDITION_TYPE, DEFAULT_ASL_FLAG DEFAULT_ASL_FLAG, DEFAULT_SAFETY_STOCK_FLAG DEFAULT_SAFETY_STOCK_FLAG, DEFAULT_EXCESS_RULE_ID DEFAULT_EXCESS_RULE_ID, DEFAULT_CATEGORY_SET_ID DEFAULT_CATEGORY_SET_ID, DEFAULT_CATEGORY_ID DEFAULT_CATEGORY_ID, DEFAULT_RECOMMEND_METHOD DEFAULT_RECOMMEND_METHOD, OVERRIDE_FORECAST_RULE_ID OVERRIDE_FORECAST_RULE_ID, OVERRIDE_SERVICE_LEVEL OVERRIDE_SERVICE_LEVEL, OVERRIDE_EDQ_FACTOR OVERRIDE_EDQ_FACTOR, OVERRIDE_PLANNER_CODE OVERRIDE_PLANNER_CODE, OVERRIDE_CONDITION_TYPE OVERRIDE_CONDITION_TYPE, OVERRIDE_ASL_FLAG OVERRIDE_ASL_FLAG, OVERRIDE_SAFETY_STOCK_FLAG OVERRIDE_SAFETY_STOCK_FLAG, OVERRIDE_EXCESS_RULE_ID OVERRIDE_EXCESS_RULE_ID, OVERRIDE_CATEGORY_SET_ID OVERRIDE_CATEGORY_SET_ID, OVERRIDE_CATEGORY_ID OVERRIDE_CATEGORY_ID, OVERRIDE_RECOMMEND_METHOD OVERRIDE_RECOMMEND_METHOD, NODE_TYPE NODE_TYPE, NODE_NAME NODE_NAME, PARENT_NODE_ID PARENT_NODE_ID, LEVEL_ID LEVEL_ID, PRODUCT_NORM_NODE_ID PRODUCT_NORM_NODE_ID, USAGE_WEIGHT1 USAGE_WEIGHT1, USAGE_WEIGHT2 USAGE_WEIGHT2, USAGE_WEIGHT3 USAGE_WEIGHT3, USAGE_WEIGHT4 USAGE_WEIGHT4, DEFAULT_USAGE_WEIGHT1 DEFAULT_USAGE_WEIGHT1, DEFAULT_USAGE_WEIGHT2 DEFAULT_USAGE_WEIGHT2, DEFAULT_USAGE_WEIGHT3 DEFAULT_USAGE_WEIGHT3, DEFAULT_USAGE_WEIGHT4 DEFAULT_USAGE_WEIGHT4, OVERRIDE_USAGE_WEIGHT1 OVERRIDE_USAGE_WEIGHT1, OVERRIDE_USAGE_WEIGHT2 OVERRIDE_USAGE_WEIGHT2, OVERRIDE_USAGE_WEIGHT3 OVERRIDE_USAGE_WEIGHT3, OVERRIDE_USAGE_WEIGHT4 OVERRIDE_USAGE_WEIGHT4, DEFAULT_PRODUCT_NORM_NODE_ID DEFAULT_PRODUCT_NORM_NODE_ID, RECOMMENDATION_RULE_ID RECOMMENDATION_RULE_ID, REPAIR_ASSIGNMENT_SET_ID REPAIR_ASSIGNMENT_SET_ID, DEFAULT_REC_RULE_ID DEFAULT_REC_RULE_ID, OVERRIDE_REC_RULE_ID OVERRIDE_REC_RULE_ID, NOTIFICATION_RULE_ID NOTIFICATION_RULE_ID, EXCESS_EDQ_FACTOR EXCESS_EDQ_FACTOR, REPAIR_EDQ_FACTOR REPAIR_EDQ_FACTOR, NEWBUY_EDQ_FACTOR NEWBUY_EDQ_FACTOR, EXCESS_SERVICE_LEVEL EXCESS_SERVICE_LEVEL, REPAIR_SERVICE_LEVEL REPAIR_SERVICE_LEVEL, NEWBUY_SERVICE_LEVEL NEWBUY_SERVICE_LEVEL, RESCHEDULE_RULE_ID RESCHEDULE_RULE_ID, WRP_RULE_ID WRP_RULE_ID, STOCKING_SITE_TYPE STOCKING_SITE_TYPE, CALENDAR_ID CALENDAR_ID, TIMEZONE_ID TIMEZONE_ID, CONTACT_NAME CONTACT_NAME, CONTACT_PHONE CONTACT_PHONE, AH_CONTACT_NAME AH_CONTACT_NAME, AH_CONTACT_PHONE AH_CONTACT_PHONE, STOCKING_SITE_EXCL STOCKING_SITE_EXCL, SPECIAL_INSTRUCTIONS SPECIAL_INSTRUCTIONS, MANAGED_BY MANAGED_BY, HZ_LOCATION_ID HZ_LOCATION_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "CSP"."CSP_PLANNING_PARAMETERS"

View Text - HTML Formatted

SELECT PLANNING_PARAMETERS_ID PLANNING_PARAMETERS_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FORECAST_RULE_ID FORECAST_RULE_ID
, CALCULATION_RULE_ID CALCULATION_RULE_ID
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, SECONDARY_INVENTORY SECONDARY_INVENTORY
, SERVICE_LEVEL SERVICE_LEVEL
, EDQ_FACTOR EDQ_FACTOR
, PLANNER_CODE PLANNER_CODE
, CONDITION_TYPE CONDITION_TYPE
, ASL_FLAG ASL_FLAG
, SAFETY_STOCK_FLAG SAFETY_STOCK_FLAG
, EXCESS_RULE_ID EXCESS_RULE_ID
, 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
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, CATEGORY_ID CATEGORY_ID
, RECOMMEND_METHOD RECOMMEND_METHOD
, EDQ_MULTIPLE EDQ_MULTIPLE
, MINIMUM_VALUE MINIMUM_VALUE
, USABLE_ASSIGNMENT_SET_ID USABLE_ASSIGNMENT_SET_ID
, DEFECTIVE_ASSIGNMENT_SET_ID DEFECTIVE_ASSIGNMENT_SET_ID
, PRODUCT_NORM PRODUCT_NORM
, DEFAULT_FORECAST_RULE_ID DEFAULT_FORECAST_RULE_ID
, DEFAULT_SERVICE_LEVEL DEFAULT_SERVICE_LEVEL
, DEFAULT_EDQ_FACTOR DEFAULT_EDQ_FACTOR
, DEFAULT_PLANNER_CODE DEFAULT_PLANNER_CODE
, DEFAULT_CONDITION_TYPE DEFAULT_CONDITION_TYPE
, DEFAULT_ASL_FLAG DEFAULT_ASL_FLAG
, DEFAULT_SAFETY_STOCK_FLAG DEFAULT_SAFETY_STOCK_FLAG
, DEFAULT_EXCESS_RULE_ID DEFAULT_EXCESS_RULE_ID
, DEFAULT_CATEGORY_SET_ID DEFAULT_CATEGORY_SET_ID
, DEFAULT_CATEGORY_ID DEFAULT_CATEGORY_ID
, DEFAULT_RECOMMEND_METHOD DEFAULT_RECOMMEND_METHOD
, OVERRIDE_FORECAST_RULE_ID OVERRIDE_FORECAST_RULE_ID
, OVERRIDE_SERVICE_LEVEL OVERRIDE_SERVICE_LEVEL
, OVERRIDE_EDQ_FACTOR OVERRIDE_EDQ_FACTOR
, OVERRIDE_PLANNER_CODE OVERRIDE_PLANNER_CODE
, OVERRIDE_CONDITION_TYPE OVERRIDE_CONDITION_TYPE
, OVERRIDE_ASL_FLAG OVERRIDE_ASL_FLAG
, OVERRIDE_SAFETY_STOCK_FLAG OVERRIDE_SAFETY_STOCK_FLAG
, OVERRIDE_EXCESS_RULE_ID OVERRIDE_EXCESS_RULE_ID
, OVERRIDE_CATEGORY_SET_ID OVERRIDE_CATEGORY_SET_ID
, OVERRIDE_CATEGORY_ID OVERRIDE_CATEGORY_ID
, OVERRIDE_RECOMMEND_METHOD OVERRIDE_RECOMMEND_METHOD
, NODE_TYPE NODE_TYPE
, NODE_NAME NODE_NAME
, PARENT_NODE_ID PARENT_NODE_ID
, LEVEL_ID LEVEL_ID
, PRODUCT_NORM_NODE_ID PRODUCT_NORM_NODE_ID
, USAGE_WEIGHT1 USAGE_WEIGHT1
, USAGE_WEIGHT2 USAGE_WEIGHT2
, USAGE_WEIGHT3 USAGE_WEIGHT3
, USAGE_WEIGHT4 USAGE_WEIGHT4
, DEFAULT_USAGE_WEIGHT1 DEFAULT_USAGE_WEIGHT1
, DEFAULT_USAGE_WEIGHT2 DEFAULT_USAGE_WEIGHT2
, DEFAULT_USAGE_WEIGHT3 DEFAULT_USAGE_WEIGHT3
, DEFAULT_USAGE_WEIGHT4 DEFAULT_USAGE_WEIGHT4
, OVERRIDE_USAGE_WEIGHT1 OVERRIDE_USAGE_WEIGHT1
, OVERRIDE_USAGE_WEIGHT2 OVERRIDE_USAGE_WEIGHT2
, OVERRIDE_USAGE_WEIGHT3 OVERRIDE_USAGE_WEIGHT3
, OVERRIDE_USAGE_WEIGHT4 OVERRIDE_USAGE_WEIGHT4
, DEFAULT_PRODUCT_NORM_NODE_ID DEFAULT_PRODUCT_NORM_NODE_ID
, RECOMMENDATION_RULE_ID RECOMMENDATION_RULE_ID
, REPAIR_ASSIGNMENT_SET_ID REPAIR_ASSIGNMENT_SET_ID
, DEFAULT_REC_RULE_ID DEFAULT_REC_RULE_ID
, OVERRIDE_REC_RULE_ID OVERRIDE_REC_RULE_ID
, NOTIFICATION_RULE_ID NOTIFICATION_RULE_ID
, EXCESS_EDQ_FACTOR EXCESS_EDQ_FACTOR
, REPAIR_EDQ_FACTOR REPAIR_EDQ_FACTOR
, NEWBUY_EDQ_FACTOR NEWBUY_EDQ_FACTOR
, EXCESS_SERVICE_LEVEL EXCESS_SERVICE_LEVEL
, REPAIR_SERVICE_LEVEL REPAIR_SERVICE_LEVEL
, NEWBUY_SERVICE_LEVEL NEWBUY_SERVICE_LEVEL
, RESCHEDULE_RULE_ID RESCHEDULE_RULE_ID
, WRP_RULE_ID WRP_RULE_ID
, STOCKING_SITE_TYPE STOCKING_SITE_TYPE
, CALENDAR_ID CALENDAR_ID
, TIMEZONE_ID TIMEZONE_ID
, CONTACT_NAME CONTACT_NAME
, CONTACT_PHONE CONTACT_PHONE
, AH_CONTACT_NAME AH_CONTACT_NAME
, AH_CONTACT_PHONE AH_CONTACT_PHONE
, STOCKING_SITE_EXCL STOCKING_SITE_EXCL
, SPECIAL_INSTRUCTIONS SPECIAL_INSTRUCTIONS
, MANAGED_BY MANAGED_BY
, HZ_LOCATION_ID HZ_LOCATION_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "CSP"."CSP_PLANNING_PARAMETERS"