MSC_PARAMETERSRC_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

ORGANIZATION_ID ORGANIZATION_CODE DEMAND_TIME_FENCE_FLAG PLANNING_TIME_FENCE_FLAG OPERATION_SCHEDULE_TYPE CONSIDER_WIP CONSIDER_PO SNAPSHOT_LOCK PLAN_SAFETY_STOCK CONSIDER_RESERVATIONS PART_INCLUDE_TYPE DEFAULT_ABC_ASSIGNMENT_GROUP PERIOD_TYPE RESCHED_ASSUMPTION PLAN_DATE_DEFAULT_TYPE INCLUDE_REP_SUPPLY_DAYS INCLUDE_MDS_DAYS LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REPETITIVE_HORIZON1 REPETITIVE_HORIZON2 REPETITIVE_BUCKET_SIZE1 REPETITIVE_BUCKET_SIZE2 REPETITIVE_BUCKET_SIZE3 REPETITIVE_ANCHOR_DATE COLLECTED_FLAG NETWORK_SCHEDULING_METHOD INCLUDE_PAST_DUE_FORECAST NET_ON_HAND PARTNER_ID ORGANIZATION_NAME MASTER_ORGANIZATION_ID CALENDAR_CODE CALENDAR_EXCEPTION_SET_ID OPERATING_UNIT PROJECT_REFERENCE_ENABLED PROJECT_CONTROL_LEVEL SOURCE_ORG_ID DEMAND_LATENESS_COST SUPPLIER_CAP_OVERUTIL_COST RESOURCE_CAP_OVERUTIL_COST DEFAULT_DEMAND_CLASS MODELED_CUSTOMER_ID MODELED_CUSTOMER_SITE_ID MODELED_SUPPLIER_ID MODELED_SUPPLIER_SITE_ID TRANSPORT_CAP_OVER_UTIL_COST USE_PHANTOM_ROUTINGS INHERIT_PHANTOM_OP_SEQ DEFAULT_ATP_RULE_ID COMPANY_ID ORG_SUPPLIER_MAPPED ACCEPT_DEMANDS_FROM_UNMET_PO INHERIT_OC_OP_SEQ_NUM SR_BUSINESS_GROUP_ID SR_LEGAL_ENTITY SR_SET_OF_BOOKS_ID SR_CHART_OF_ACCOUNTS_ID BUSINESS_GROUP_NAME LEGAL_ENTITY_NAME OPERATING_UNIT_NAME MATERIAL_ACCOUNT EXPENSE_ACCOUNT ORGANIZATION_TYPE SERVICE_LEVEL CUSTOMER_CLASS_CODE CURRENCY_CODE WEIGHT_UOM MAXIMUM_WEIGHT VOLUME_UOM MAXIMUM_VOLUME REFRESH_NUMBER

Query

SQL_Statement

select "ORGANIZATION_ID","ORGANIZATION_CODE","DEMAND_TIME_FENCE_FLAG","PLANNING_TIME_FENCE_FLAG","OPERATION_SCHEDULE_TYPE","CONSIDER_WIP","CONSIDER_PO","SNAPSHOT_LOCK","PLAN_SAFETY_STOCK","CONSIDER_RESERVATIONS","PART_INCLUDE_TYPE","DEFAULT_ABC_ASSIGNMENT_GROUP","PERIOD_TYPE","RESCHED_ASSUMPTION","PLAN_DATE_DEFAULT_TYPE","INCLUDE_REP_SUPPLY_DAYS","INCLUDE_MDS_DAYS","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","REPETITIVE_HORIZON1","REPETITIVE_HORIZON2","REPETITIVE_BUCKET_SIZE1","REPETITIVE_BUCKET_SIZE2","REPETITIVE_BUCKET_SIZE3","REPETITIVE_ANCHOR_DATE","COLLECTED_FLAG","NETWORK_SCHEDULING_METHOD","INCLUDE_PAST_DUE_FORECAST","NET_ON_HAND","PARTNER_ID","ORGANIZATION_NAME","MASTER_ORGANIZATION_ID","CALENDAR_CODE","CALENDAR_EXCEPTION_SET_ID","OPERATING_UNIT","PROJECT_REFERENCE_ENABLED","PROJECT_CONTROL_LEVEL", to_number(NULL) SOURCE_ORG_ID ,"DEMAND_LATENESS_COST","SUPPLIER_CAP_OVERUTIL_COST","RESOURCE_CAP_OVERUTIL_COST","DEFAULT_DEMAND_CLASS","MODELED_CUSTOMER_ID","MODELED_CUSTOMER_SITE_ID","MODELED_SUPPLIER_ID","MODELED_SUPPLIER_SITE_ID","TRANSPORT_CAP_OVER_UTIL_COST","USE_PHANTOM_ROUTINGS","INHERIT_PHANTOM_OP_SEQ","DEFAULT_ATP_RULE_ID","COMPANY_ID","ORG_SUPPLIER_MAPPED","ACCEPT_DEMANDS_FROM_UNMET_PO","INHERIT_OC_OP_SEQ_NUM","SR_BUSINESS_GROUP_ID","SR_LEGAL_ENTITY","SR_SET_OF_BOOKS_ID","SR_CHART_OF_ACCOUNTS_ID","BUSINESS_GROUP_NAME","LEGAL_ENTITY_NAME","OPERATING_UNIT_NAME","MATERIAL_ACCOUNT","EXPENSE_ACCOUNT","ORGANIZATION_TYPE","SERVICE_LEVEL","CUSTOMER_CLASS_CODE","CURRENCY_CODE","WEIGHT_UOM","MAXIMUM_WEIGHT","VOLUME_UOM","MAXIMUM_VOLUME","REFRESH_NUMBER" from msc_parameters as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))