VIEW: MSC.MSC_PARAMETERS#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, DEMAND_TIME_FENCE_FLAG DEMAND_TIME_FENCE_FLAG, PLANNING_TIME_FENCE_FLAG PLANNING_TIME_FENCE_FLAG, OPERATION_SCHEDULE_TYPE OPERATION_SCHEDULE_TYPE, CONSIDER_WIP CONSIDER_WIP, CONSIDER_PO CONSIDER_PO, SNAPSHOT_LOCK SNAPSHOT_LOCK, PLAN_SAFETY_STOCK PLAN_SAFETY_STOCK, CONSIDER_RESERVATIONS CONSIDER_RESERVATIONS, PART_INCLUDE_TYPE PART_INCLUDE_TYPE, DEFAULT_ABC_ASSIGNMENT_GROUP DEFAULT_ABC_ASSIGNMENT_GROUP, PERIOD_TYPE PERIOD_TYPE, RESCHED_ASSUMPTION RESCHED_ASSUMPTION, PLAN_DATE_DEFAULT_TYPE PLAN_DATE_DEFAULT_TYPE, INCLUDE_REP_SUPPLY_DAYS INCLUDE_REP_SUPPLY_DAYS, INCLUDE_MDS_DAYS INCLUDE_MDS_DAYS, 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, REPETITIVE_HORIZON1 REPETITIVE_HORIZON1, REPETITIVE_HORIZON2 REPETITIVE_HORIZON2, REPETITIVE_BUCKET_SIZE1 REPETITIVE_BUCKET_SIZE1, REPETITIVE_BUCKET_SIZE2 REPETITIVE_BUCKET_SIZE2, REPETITIVE_BUCKET_SIZE3 REPETITIVE_BUCKET_SIZE3, REPETITIVE_ANCHOR_DATE REPETITIVE_ANCHOR_DATE, COLLECTED_FLAG COLLECTED_FLAG, NETWORK_SCHEDULING_METHOD NETWORK_SCHEDULING_METHOD, INCLUDE_PAST_DUE_FORECAST INCLUDE_PAST_DUE_FORECAST, NET_ON_HAND NET_ON_HAND from "MSC"."MSC_PARAMETERS"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, DEMAND_TIME_FENCE_FLAG DEMAND_TIME_FENCE_FLAG
, PLANNING_TIME_FENCE_FLAG PLANNING_TIME_FENCE_FLAG
, OPERATION_SCHEDULE_TYPE OPERATION_SCHEDULE_TYPE
, CONSIDER_WIP CONSIDER_WIP
, CONSIDER_PO CONSIDER_PO
, SNAPSHOT_LOCK SNAPSHOT_LOCK
, PLAN_SAFETY_STOCK PLAN_SAFETY_STOCK
, CONSIDER_RESERVATIONS CONSIDER_RESERVATIONS
, PART_INCLUDE_TYPE PART_INCLUDE_TYPE
, DEFAULT_ABC_ASSIGNMENT_GROUP DEFAULT_ABC_ASSIGNMENT_GROUP
, PERIOD_TYPE PERIOD_TYPE
, RESCHED_ASSUMPTION RESCHED_ASSUMPTION
, PLAN_DATE_DEFAULT_TYPE PLAN_DATE_DEFAULT_TYPE
, INCLUDE_REP_SUPPLY_DAYS INCLUDE_REP_SUPPLY_DAYS
, INCLUDE_MDS_DAYS INCLUDE_MDS_DAYS
, 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
, REPETITIVE_HORIZON1 REPETITIVE_HORIZON1
, REPETITIVE_HORIZON2 REPETITIVE_HORIZON2
, REPETITIVE_BUCKET_SIZE1 REPETITIVE_BUCKET_SIZE1
, REPETITIVE_BUCKET_SIZE2 REPETITIVE_BUCKET_SIZE2
, REPETITIVE_BUCKET_SIZE3 REPETITIVE_BUCKET_SIZE3
, REPETITIVE_ANCHOR_DATE REPETITIVE_ANCHOR_DATE
, COLLECTED_FLAG COLLECTED_FLAG
, NETWORK_SCHEDULING_METHOD NETWORK_SCHEDULING_METHOD
, INCLUDE_PAST_DUE_FORECAST INCLUDE_PAST_DUE_FORECAST
, NET_ON_HAND NET_ON_HAND
FROM "MSC"."MSC_PARAMETERS"