[Home] [Help] [Dependency Information]
Object Name: | MSC_COLL_PARAMETERS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_COLL_PARAMETERS_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INSTANCE_ID |
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 |
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;
MSC.MSC_COLL_PARAMETERS does not reference any database object
MSC.MSC_COLL_PARAMETERS is referenced by following:
|
|
|