Planning Data Collection - Purge Staging Tables

1. 'Planning Data Collection - Purge Staging Tables' :

MSCPDCP module: Planning Data Collection - Purge Staging Tables
File name is: MSCCLBAB.pls
This concurrent program deletes records from the following tables:

---------------- BOM --------------------
MSC_ST_BOM_COMPONENTS
MSC_ST_BOMS
MSC_ST_COMPONENT_SUBSTITUTES
MSC_ST_ROUTINGS
MSC_ST_ROUTING_OPERATIONS
MSC_ST_OPERATION_RESOURCES
MSC_ST_OPERATION_RESOURCE_SEQS
MSC_ST_PROCESS_EFFECTIVITY
MSC_ST_OPERATION_COMPONENTS
---------------- BOR -------------------
MSC_ST_BILL_OF_RESOURCES
MSC_ST_BOR_REQUIREMENTS
---------------- CALENDAR_DATE -------------
MSC_ST_CALENDAR_DATES
MSC_ST_PERIOD_START_DATES
MSC_ST_CAL_YEAR_START_DATES
MSC_ST_CAL_WEEK_START_DATES
MSC_ST_RESOURCE_SHIFTS
MSC_ST_CALENDAR_SHIFTS
MSC_ST_SHIFT_DATES
MSC_ST_RESOURCE_CHANGES
MSC_ST_SHIFT_TIMES
MSC_ST_SHIFT_EXCEPTIONS
MSC_ST_NET_RESOURCE_AVAIL
---------------- CATEGORY -------------
MSC_ST_ITEM_CATEGORIES
MSC_ST_CATEGORY_SETS
---------------- DEMAND -------------
MSC_ST_DEMANDS
---------------- SALES ORDER -------------
MSC_ST_SALES_ORDERS
---------------- HARD RESERVATION -------------
MSC_ST_RESERVATIONS
---------------- ITEM -------------
MSC_ST_SYSTEM_ITEMS
---------------- RESOURCE -------------
MSC_ST_DEPARTMENT_RESOURCES
MSC_ST_SIMULATION_SETS
MSC_ST_RESOURCE_GROUPS
---------------- SAFETY STOCK-------------
MSC_ST_SAFETY_STOCKS
---------------- SCHEDULE DESIGNATOR -------------
MSC_ST_DESIGNATORS
---------------- SOURCING -------------
MSC_ST_ASSIGNMENT_SETS
MSC_ST_SOURCING_RULES
MSC_ST_SR_ASSIGNMENTS
MSC_ST_SR_RECEIPT_ORG
MSC_ST_SR_SOURCE_ORG
MSC_ST_INTERORG_SHIP_METHODS
---------------- SUB INVENTORY -------------
MSC_ST_SUB_INVENTORIES
---------------- SUPPLIER CAPACITY -------------
MSC_ST_ITEM_SUPPLIERS
MSC_ST_SUPPLIER_CAPACITIES
MSC_ST_SUPPLIER_FLEX_FENCES
---------------- SUPPLY -------------
MSC_ST_SUPPLIES
--------------- RESOURCE REQUIREMENT -------------
MSC_ST_RESOURCE_REQUIREMENTS
---------------- TRADING PARTNER -------------
MSC_ST_TRADING_PARTNERS
MSC_ST_TRADING_PARTNER_SITES
MSC_ST_LOCATION_ASSOCIATIONS
---------------- UNIT NUMBER -------------
MSC_ST_UNIT_NUMBERS
---------------- PROJECT -------------
MSC_ST_PROJECTS
MSC_ST_PROJECT_TASKS
---------------- PARAMETER -------------
MSC_ST_PARAMETERS
---------------- UOM -------------
MSC_ST_UNITS_OF_MEASURE
MSC_ST_UOM_CLASS_CONVERSIONS
MSC_ST_UOM_CONVERSIONS
---------------- BIS -------------
MSC_ST_BIS_PFMC_MEASURES
MSC_ST_BIS_TARGET_LEVELS
MSC_ST_BIS_TARGETS
MSC_ST_BIS_BUSINESS_PLANS
MSC_ST_BIS_PERIODS
---------------- ATP RULES -------------
MSC_ST_ATP_RULES
--------------- PLANNERS -------------
MSC_ST_PLANNERS
---------------- DEMAND CLASS -------------
MSC_ST_DEMAND_CLASSES
---------------- PARTNER CONTACTS -----------
MSC_ST_PARTNER_CONTACTS