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

TABLE: MSC.MSC_COLL_PARAMETERS

Object Details
Object Name: MSC_COLL_PARAMETERS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_COLL_PARAMETERS
Subobject Name:
Status: VALID


Stores the parameters that were selected for a particular
collection run by instance_id. This is used as a communication
tool between Snapshot Refresh, Data Pull and ODS Load modules.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_COLL_PARAMETERS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
INSTANCE_ID NUMBER
Yes Instance Id of the source of collection.
DELETE_ODS_DATA NUMBER
Yes FLAG DELETION of ODS DATA.
SUPPLIER_CAPACITY NUMBER
Yes Supplier Capacity Flag
ATP_RULES NUMBER
Yes ATP_RULES LOAD FLAG
BOM NUMBER
Yes BOM Flag
BOR NUMBER
Yes BOR Flag
CALENDAR_CHECK NUMBER
Yes Calendar Flag
DEMAND_CLASS NUMBER
Yes Demand_Class Flag
FORECAST NUMBER
Yes Forecast Flag
ITEM NUMBER
Yes Item Flag
KPI_TARGETS_BIS NUMBER
Yes Business Key Performance Indicator (KPI) Flag
MDS NUMBER
Yes MDS Flag
MPS NUMBER
Yes MPS Flag
OH NUMBER
Yes On Hand Flag
PARAMETER NUMBER
Yes Parameters Load Flag
PLANNERS NUMBER
Yes Planners Load Flag
PROJECTS NUMBER
Yes Projects Flag
PO NUMBER
Yes Purchase Order (PO) Flag
RESERVATIONS NUMBER
Yes Hard Reservations Flag
NRA NUMBER
Yes NRA Flag
SAFETY_STOCK NUMBER
Yes Safety Stock Flag
SALES_ORDER NUMBER
Yes Sales Orders Flag
SOURCING_HISTORY NUMBER
Yes Sourcing History Flag
SOURCING NUMBER
Yes Sourcing Flag
SUB_INVENTORIES NUMBER
Yes Sub Inventories Flag
CUSTOMER NUMBER
Yes Customer Flag
SUPPLIER NUMBER
Yes Vendor/Supplier Flag
UNIT_NUMBERS NUMBER
Yes Unit Numbers Flag
UOM NUMBER
Yes Unit of Measure (UOM) Flag
USER_SUPPLY_DEMAND NUMBER
Yes User Supply & Demand Flag
WIP NUMBER
Yes Work In Process (WIP) Flag
LAST_UPDATE_DATE DATE
Yes Last Update Timestamp for Record
LAST_UPDATED_BY NUMBER
Yes Last Update user
CREATION_DATE DATE
Yes Creation Timestamp for Record
CREATED_BY NUMBER
Yes Record creation User
ITEM_SUBSTITUTES NUMBER

Item Substitution Flag
USER_COMP_ASSOCIATION NUMBER

User Company Association
BOM_SN_FLAG NUMBER

BOM Snapshot Collection Status
BOR_SN_FLAG NUMBER

BOR Snapshot Collection Status
ITEM_SN_FLAG NUMBER

Item Snapshot Collection Status
OH_SN_FLAG NUMBER

Onhand Snapshot Collection Status
USUP_SN_FLAG NUMBER

User Supply Snapshot Collection Status
UDMD_SN_FLAG NUMBER

User Demand Snapshot Collection Status
SO_SN_FLAG NUMBER

Sales Orders Snapshot Collection Status
FCST_SN_FLAG NUMBER

Forecast Snapshot Collection Status
WIP_SN_FLAG NUMBER

WIP Snapshot Collection Status
SUPCAP_SN_FLAG NUMBER

Supplier Capacity Snapshot Collection Status
PO_SN_FLAG NUMBER

PO Snapshot Collection Status
MDS_SN_FLAG NUMBER

MDS Snapshot Collection Status
MPS_SN_FLAG NUMBER

MPS Snapshot Collection Status
NOSNAP_FLAG NUMBER

Collection status for entities with no Snapshot
SUPPLIER_RESPONSE NUMBER

Indicator for refreshing Supplier responses Data.
SUPREP_SN_FLAG NUMBER

Supplier responses related Snapshot Collection Status (2= No, 3 = Incremental Collection, 4= Targeted Collection)
ORG_GROUP VARCHAR2 (30)
Org Group Identifier
THRESHOLD NUMBER

Threshold for the continious Collection
TRIP NUMBER

Indicator for refreshing Trips data.
TRIP_SN_FLAG NUMBER

Trips Snapshot Status (2= No, 3=incremental Collection ,4=targetted Collection)
DS_MODE NUMBER

1 running in ds collection mode
PO_RECEIPTS NUMBER

Puchase Order reciepts flag
SALES_CHANNEL NUMBER

SALES CHANNEL flag
FISCAL_CALENDAR NUMBER

FISCAL CALENDAR collection flag
INTERNAL_REPAIR NUMBER

Internal repair order collect flag
EXTERNAL_REPAIR NUMBER

External repair order collect flag
PULL_WRKR_START_TIME DATE

Approximate start time stamp (per source database) of first pull worker of this collection request
COLLECTIONS_START_TIME DATE

Approximate start time stamp (per destination db) of this collection request set
PAYBACK_DEMAND_SUPPLY NUMBER

borro payback collect flag
CURRENCY_CONVERSION NUMBER

Currency conversion collection flag
DELIVERY_DETAILS NUMBER

Delivery Details Flag.
DELIVERY_DTL_SWAP_FLAG NUMBER

Flag Indicating Status of Exchange Partn Between ODS and Staging Table for delivary details
SOURCING_DTL_SWAP_FLAG NUMBER

Flag Indicating Status of Exchange Partn Between ODS and Staging Table for sourcing rules
CMRO NUMBER

CMRO flag
IBUC_HISTORY NUMBER

Install Base under Contracts history coll flag
NOTES_ATTACH NUMBER

Notes attachments coll flag
CMRO_FC_END_DATE DATE

CMRO Forecast end date
CMRO_FC_ST_DATE DATE

CMRO Forecast start date
CMRO_FORECASTS NUMBER

CMRO Forecast
EAM_FC_END_DATE DATE

EAM Forecast end date
EAM_FC_ST_DATE DATE

EAM Forecast start date
EAM_FORECASTS NUMBER

EAM Forecasts
EAM_INFO NUMBER

EAM Info
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 does not reference any database object

MSC.MSC_COLL_PARAMETERS is referenced by following:

SchemaMSC
ViewMSC_COLL_PARAMETERS#