DBA Data[Home] [Help] [Dependency Information]

VIEW: MSC.MSC_COLL_PARAMETERS#

Object Details
Object Name: MSC_COLL_PARAMETERS#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTANCE_ID NUMBER
Yes
DELETE_ODS_DATA NUMBER
Yes
SUPPLIER_CAPACITY NUMBER
Yes
ATP_RULES NUMBER
Yes
BOM NUMBER
Yes
BOR NUMBER
Yes
CALENDAR_CHECK NUMBER
Yes
DEMAND_CLASS NUMBER
Yes
FORECAST NUMBER
Yes
ITEM NUMBER
Yes
KPI_TARGETS_BIS NUMBER
Yes
MDS NUMBER
Yes
MPS NUMBER
Yes
OH NUMBER
Yes
PARAMETER NUMBER
Yes
PLANNERS NUMBER
Yes
PROJECTS NUMBER
Yes
PO NUMBER
Yes
RESERVATIONS NUMBER
Yes
NRA NUMBER
Yes
SAFETY_STOCK NUMBER
Yes
SALES_ORDER NUMBER
Yes
SOURCING_HISTORY NUMBER
Yes
SOURCING NUMBER
Yes
SUB_INVENTORIES NUMBER
Yes
CUSTOMER NUMBER
Yes
SUPPLIER NUMBER
Yes
UNIT_NUMBERS NUMBER
Yes
UOM NUMBER
Yes
USER_SUPPLY_DEMAND NUMBER
Yes
WIP NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
ITEM_SUBSTITUTES NUMBER

USER_COMP_ASSOCIATION NUMBER

BOM_SN_FLAG NUMBER

BOR_SN_FLAG NUMBER

ITEM_SN_FLAG NUMBER

OH_SN_FLAG NUMBER

USUP_SN_FLAG NUMBER

UDMD_SN_FLAG NUMBER

SO_SN_FLAG NUMBER

FCST_SN_FLAG NUMBER

WIP_SN_FLAG NUMBER

SUPCAP_SN_FLAG NUMBER

PO_SN_FLAG NUMBER

MDS_SN_FLAG NUMBER

MPS_SN_FLAG NUMBER

NOSNAP_FLAG NUMBER

SUPPLIER_RESPONSE NUMBER

SUPREP_SN_FLAG NUMBER

ORG_GROUP VARCHAR2 (30)
THRESHOLD NUMBER

TRIP NUMBER

TRIP_SN_FLAG NUMBER

DS_MODE NUMBER

PO_RECEIPTS NUMBER

SALES_CHANNEL NUMBER

FISCAL_CALENDAR NUMBER

INTERNAL_REPAIR NUMBER

EXTERNAL_REPAIR NUMBER

PULL_WRKR_START_TIME DATE

COLLECTIONS_START_TIME DATE

PAYBACK_DEMAND_SUPPLY NUMBER

CURRENCY_CONVERSION NUMBER

DELIVERY_DETAILS NUMBER

DELIVERY_DTL_SWAP_FLAG NUMBER

SOURCING_DTL_SWAP_FLAG NUMBER

CMRO NUMBER

IBUC_HISTORY NUMBER

NOTES_ATTACH NUMBER

CMRO_FC_END_DATE DATE

CMRO_FC_ST_DATE DATE

CMRO_FORECASTS NUMBER

EAM_FC_END_DATE DATE

EAM_FC_ST_DATE DATE

EAM_FORECASTS NUMBER

EAM_INFO NUMBER

CMRO_CLOSED_WO NUMBER

RET_FCST NUMBER

OSP_SUPPLY NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

MSC.MSC_COLL_PARAMETERS# references the following:

SchemaMSC
TableMSC_COLL_PARAMETERS
MSC.MSC_COLL_PARAMETERS# is referenced by following:

SchemaAPPS
SynonymMSC_COLL_PARAMETERS