VIEW: MSC.MSC_COLL_PARAMETERS#

Source

View Text - Preformatted

select INSTANCE_ID INSTANCE_ID, DELETE_ODS_DATA DELETE_ODS_DATA, SUPPLIER_CAPACITY SUPPLIER_CAPACITY, ATP_RULES ATP_RULES, BOM BOM, BOR BOR, CALENDAR_CHECK CALENDAR_CHECK, DEMAND_CLASS DEMAND_CLASS, FORECAST FORECAST, ITEM ITEM, KPI_TARGETS_BIS KPI_TARGETS_BIS, MDS MDS, MPS MPS, OH OH, PARAMETER PARAMETER, PLANNERS PLANNERS, PROJECTS PROJECTS, PO PO, RESERVATIONS RESERVATIONS, NRA NRA, SAFETY_STOCK SAFETY_STOCK, SALES_ORDER SALES_ORDER, SOURCING_HISTORY SOURCING_HISTORY, SOURCING SOURCING, SUB_INVENTORIES SUB_INVENTORIES, CUSTOMER CUSTOMER, SUPPLIER SUPPLIER, UNIT_NUMBERS UNIT_NUMBERS, UOM UOM, USER_SUPPLY_DEMAND USER_SUPPLY_DEMAND, WIP WIP, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ITEM_SUBSTITUTES ITEM_SUBSTITUTES, USER_COMP_ASSOCIATION USER_COMP_ASSOCIATION, BOM_SN_FLAG BOM_SN_FLAG, BOR_SN_FLAG BOR_SN_FLAG, ITEM_SN_FLAG ITEM_SN_FLAG, OH_SN_FLAG OH_SN_FLAG, USUP_SN_FLAG USUP_SN_FLAG, UDMD_SN_FLAG UDMD_SN_FLAG, SO_SN_FLAG SO_SN_FLAG, FCST_SN_FLAG FCST_SN_FLAG, WIP_SN_FLAG WIP_SN_FLAG, SUPCAP_SN_FLAG SUPCAP_SN_FLAG, PO_SN_FLAG PO_SN_FLAG, MDS_SN_FLAG MDS_SN_FLAG, MPS_SN_FLAG MPS_SN_FLAG, NOSNAP_FLAG NOSNAP_FLAG, SUPPLIER_RESPONSE SUPPLIER_RESPONSE, SUPREP_SN_FLAG SUPREP_SN_FLAG, ORG_GROUP ORG_GROUP, THRESHOLD THRESHOLD, TRIP TRIP, TRIP_SN_FLAG TRIP_SN_FLAG, DS_MODE DS_MODE, PO_RECEIPTS PO_RECEIPTS, SALES_CHANNEL SALES_CHANNEL, FISCAL_CALENDAR FISCAL_CALENDAR, INTERNAL_REPAIR INTERNAL_REPAIR, EXTERNAL_REPAIR EXTERNAL_REPAIR, PULL_WRKR_START_TIME PULL_WRKR_START_TIME, COLLECTIONS_START_TIME COLLECTIONS_START_TIME, PAYBACK_DEMAND_SUPPLY PAYBACK_DEMAND_SUPPLY, CURRENCY_CONVERSION CURRENCY_CONVERSION, DELIVERY_DETAILS DELIVERY_DETAILS, DELIVERY_DTL_SWAP_FLAG DELIVERY_DTL_SWAP_FLAG, SOURCING_DTL_SWAP_FLAG SOURCING_DTL_SWAP_FLAG, CMRO CMRO, IBUC_HISTORY IBUC_HISTORY, NOTES_ATTACH NOTES_ATTACH, CMRO_FC_END_DATE CMRO_FC_END_DATE, CMRO_FC_ST_DATE CMRO_FC_ST_DATE, CMRO_FORECASTS CMRO_FORECASTS, EAM_FC_END_DATE EAM_FC_END_DATE, EAM_FC_ST_DATE EAM_FC_ST_DATE, EAM_FORECASTS EAM_FORECASTS, EAM_INFO EAM_INFO, CMRO_CLOSED_WO CMRO_CLOSED_WO, RET_FCST RET_FCST, OSP_SUPPLY OSP_SUPPLY from "MSC"."MSC_COLL_PARAMETERS"

View Text - HTML Formatted

SELECT INSTANCE_ID INSTANCE_ID
, DELETE_ODS_DATA DELETE_ODS_DATA
, SUPPLIER_CAPACITY SUPPLIER_CAPACITY
, ATP_RULES ATP_RULES
, BOM BOM
, BOR BOR
, CALENDAR_CHECK CALENDAR_CHECK
, DEMAND_CLASS DEMAND_CLASS
, FORECAST FORECAST
, ITEM ITEM
, KPI_TARGETS_BIS KPI_TARGETS_BIS
, MDS MDS
, MPS MPS
, OH OH
, PARAMETER PARAMETER
, PLANNERS PLANNERS
, PROJECTS PROJECTS
, PO PO
, RESERVATIONS RESERVATIONS
, NRA NRA
, SAFETY_STOCK SAFETY_STOCK
, SALES_ORDER SALES_ORDER
, SOURCING_HISTORY SOURCING_HISTORY
, SOURCING SOURCING
, SUB_INVENTORIES SUB_INVENTORIES
, CUSTOMER CUSTOMER
, SUPPLIER SUPPLIER
, UNIT_NUMBERS UNIT_NUMBERS
, UOM UOM
, USER_SUPPLY_DEMAND USER_SUPPLY_DEMAND
, WIP WIP
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ITEM_SUBSTITUTES ITEM_SUBSTITUTES
, USER_COMP_ASSOCIATION USER_COMP_ASSOCIATION
, BOM_SN_FLAG BOM_SN_FLAG
, BOR_SN_FLAG BOR_SN_FLAG
, ITEM_SN_FLAG ITEM_SN_FLAG
, OH_SN_FLAG OH_SN_FLAG
, USUP_SN_FLAG USUP_SN_FLAG
, UDMD_SN_FLAG UDMD_SN_FLAG
, SO_SN_FLAG SO_SN_FLAG
, FCST_SN_FLAG FCST_SN_FLAG
, WIP_SN_FLAG WIP_SN_FLAG
, SUPCAP_SN_FLAG SUPCAP_SN_FLAG
, PO_SN_FLAG PO_SN_FLAG
, MDS_SN_FLAG MDS_SN_FLAG
, MPS_SN_FLAG MPS_SN_FLAG
, NOSNAP_FLAG NOSNAP_FLAG
, SUPPLIER_RESPONSE SUPPLIER_RESPONSE
, SUPREP_SN_FLAG SUPREP_SN_FLAG
, ORG_GROUP ORG_GROUP
, THRESHOLD THRESHOLD
, TRIP TRIP
, TRIP_SN_FLAG TRIP_SN_FLAG
, DS_MODE DS_MODE
, PO_RECEIPTS PO_RECEIPTS
, SALES_CHANNEL SALES_CHANNEL
, FISCAL_CALENDAR FISCAL_CALENDAR
, INTERNAL_REPAIR INTERNAL_REPAIR
, EXTERNAL_REPAIR EXTERNAL_REPAIR
, PULL_WRKR_START_TIME PULL_WRKR_START_TIME
, COLLECTIONS_START_TIME COLLECTIONS_START_TIME
, PAYBACK_DEMAND_SUPPLY PAYBACK_DEMAND_SUPPLY
, CURRENCY_CONVERSION CURRENCY_CONVERSION
, DELIVERY_DETAILS DELIVERY_DETAILS
, DELIVERY_DTL_SWAP_FLAG DELIVERY_DTL_SWAP_FLAG
, SOURCING_DTL_SWAP_FLAG SOURCING_DTL_SWAP_FLAG
, CMRO CMRO
, IBUC_HISTORY IBUC_HISTORY
, NOTES_ATTACH NOTES_ATTACH
, CMRO_FC_END_DATE CMRO_FC_END_DATE
, CMRO_FC_ST_DATE CMRO_FC_ST_DATE
, CMRO_FORECASTS CMRO_FORECASTS
, EAM_FC_END_DATE EAM_FC_END_DATE
, EAM_FC_ST_DATE EAM_FC_ST_DATE
, EAM_FORECASTS EAM_FORECASTS
, EAM_INFO EAM_INFO
, CMRO_CLOSED_WO CMRO_CLOSED_WO
, RET_FCST RET_FCST
, OSP_SUPPLY OSP_SUPPLY
FROM "MSC"."MSC_COLL_PARAMETERS"