MRP | ORACLE APPS COMMUNITY

You are browsing the archive for MRP.

by oracleguru

Oracle Material Requirements Planning Tables

ORACLE APPS COMMUNITY > Tutorial > MRP

Oracle MRP module – List of database tables

MRP_AD_BOMS
MRP_AD_CTO_ORDER_DEMAND
MRP_AD_DEMAND
MRP_AD_DEPT_RESS
MRP_AD_DSCR_JOBS
MRP_AD_FLOW_SCHDS
MRP_AD_FORECAST_DATES
MRP_AD_FORECAST_DSGN
MRP_AD_INV_COMPS
MRP_AD_MTRX_TMP
MRP_AD_OH_QTYS
MRP_AD_OPERATION_COMPONENTS
MRP_AD_OPR_NETWORKS
MRP_AD_OPR_RESS
MRP_AD_OPR_RTNS
MRP_AD_OPR_SEQS
MRP_AD_ORDER_LINES_ALL
MRP_AD_PROCESS_EFFECTIVITY
MRP_AD_REPT_ITEM_DEMANDS
MRP_AD_REPT_ITEM_SUPPLIES
MRP_AD_REPT_SCHDS
MRP_AD_RESOURCE_REQUIREMENTS
MRP_AD_RES_CHNGS
MRP_AD_SCHD_DATES
MRP_AD_SI_CAPA
MRP_AD_SUB_OPR_RESS
MRP_AD_SUPPLY
MRP_AD_U_DEMAND
MRP_AD_U_SUPPLY
MRP_AD_WIP_COMP_DEMANDS
MRP_AD_WIP_COMP_SUPPLIES
MRP_AD_WLINES
MRP_AD_WOPRS
MRP_AD_WOPR_RESS
MRP_AD_WREQ_OPRS
MRP_AGGREGATE_RATES
MRP_AMONG_VALUES
MRP_AP_APPS_INSTANCES
MRP_ASSEMBLY_OPERATIONS
MRP_ASSIGNMENT_SETS
MRP_ATP_DETAILS_TEMP
MRP_ATP_SCHEDULE_TEMP
MRP_ATP_SUPPLY_DEMAND
MRP_AUDIT_SQL_STATEMENTS
MRP_AVAILABLE_TO_PROMISE
MRP_BIS_FORECAST_WB
MRP_BIS_INV_DETAIL
MRP_BIS_PLAN_PROFIT
MRP_BIS_RES_SUMMARY
MRP_BOM_COMPONENTS
MRP_CACHE_SEQ
MRP_COMPONENT_SUBSTITUTES
MRP_CRITERIA
MRP_DERIVED_SO_DEMANDS
MRP_DESIGNATORS
MRP_END_ASSEMBLIES
MRP_EXCELS
MRP_EXCEL_COLUMNS
MRP_EXCEL_COMPONENTS
MRP_EXCEPTION_DETAILS
MRP_FILES
MRP_FLOW_DEMANDS
MRP_FORECAST_DATES
MRP_FORECAST_DESIGNATORS
MRP_FORECAST_INTERFACE
MRP_FORECAST_ITEMS
MRP_FORECAST_UPDATES
MRP_FORM_QUERY
MRP_FULL_PEGGING
MRP_GROSS_REQUIREMENTS
MRP_I2_ACTIONS
MRP_I2_ACTION_SETS
MRP_I2_AGGREGATE_RESOURCE
MRP_I2_BC_RESULTS
MRP_I2_BOM
MRP_I2_BOM_NET
MRP_I2_BOM_TEMP
MRP_I2_DEBUG_MSG
MRP_I2_FORECASTS
MRP_I2_MFG_ORDER_OUTPUT
MRP_I2_ONHAND_INVENTORY
MRP_I2_OP_RESOURCE
MRP_I2_PARAMETERS
MRP_I2_PART_MASTER
MRP_I2_PART_MASTER_NET
MRP_I2_PART_SUPPLIER
MRP_I2_PENDING_BACKFLUSH
MRP_I2_PO_EDC
MRP_I2_PROCUREMENT
MRP_I2_PROC_BY_PART
MRP_I2_PROD_SCHEDULE
MRP_I2_RESOURCE
MRP_I2_RESOURCE_CALENDAR
MRP_I2_ROUTING
MRP_I2_ROUTING_NET
MRP_I2_SAFETY_STOCK
MRP_I2_SALES_ORDER
MRP_I2_UNAVAIL_RESOURCE
MRP_I2_WIP
MRP_I2_WORK_ORDERS
MRP_I2_WO_DELTAS
MRP_I2_WO_OP_OUTPUT
MRP_INVENTORY_LOTS
MRP_ITEM_EXCEPTIONS
MRP_ITEM_PURCHASE_ORDERS
MRP_ITEM_SOURCING
MRP_ITEM_SUPPLIERS
MRP_ITEM_WIP_ENTITIES
MRP_KANBAN_DEMAND
MRP_KANBAN_PLANS
MRP_LOAD_PARAMETERS
MRP_LOAD_SELECTIONS
MRP_LOW_LEVEL_CODES
MRP_MATERIAL_PLANS
MRP_MESSAGES_TMP
MRP_NET_RESOURCE_AVAIL
MRP_ONHAND_QUANTITIES
MRP_PARAMETERS
MRP_PENDING_ENG_CHANGES
MRP_PLANNED_RESOURCE_REQS
MRP_PLANNER_TASKS
MRP_PLANNING_EXCEPTION_SETS
MRP_PLANS
MRP_PLAN_ORGANIZATIONS
MRP_PLAN_SCHEDULES
MRP_RECOMMENDATIONS
MRP_RELIEF_INTERFACE
MRP_REPETITIVE_PERIODS
MRP_REPETITIVE_SCHEDULES
MRP_RESERVATIONS
MRP_RHX_USEUP_INFO
MRP_SAFETY_STOCK
MRP_SALES_ORDER_UPDATES
MRP_SCHEDULER_MESSAGES
MRP_SCHEDULE_CONSUMPTIONS
MRP_SCHEDULE_DATES
MRP_SCHEDULE_DESIGNATORS
MRP_SCHEDULE_INTERFACE
MRP_SCHEDULE_ITEMS
MRP_SCHEDULING_RULES
MRP_SELECTION_CRITERIA
MRP_SNAPSHOT_TASKS
MRP_SOURCING_HISTORY
MRP_SOURCING_RULES
MRP_SO_LINES_TEMP
MRP_SQLLOAD_PARAMETERS
MRP_SR_ASSIGNMENTS
MRP_SR_RECEIPT_ORG
MRP_SR_SOURCE_ORG
MRP_SUB_INVENTORIES
MRP_SUGG_REP_SCHEDULES
MRP_SUPPLIER_CAPACITIES
MRP_SUPPLIER_FLEX_FENCES
MRP_SYSTEM_ITEMS
MRP_WIP_COMPONENTS
MRP_WIP_RESOURCES
MRP_WORKBENCH_BUCKET_DATES
MRP_WORKBENCH_CRITERIA
MRP_WORKBENCH_DISPLAY_OPTIONS
MRP_WORKBENCH_QUERY

Tags: CRP, MPS, MRP, SCP No Comments »

by oracleguru

Oracle MRP Forms

ORACLE APPS COMMUNITY > Tutorial > MRP

Oracle Master Scheduling / MRP Forms:

FORM SHORT CODE	ORACLE FORM NAME
MRPATPRS	Resource Supply for ATP
MRPCHORG	Change Organization – MRP
MRPFDDSR	Define Sourcing Rules
MRPFDSRA	Define Bills of Distribution
MRPFFCFN	Define Forecast Sets
MRPFFDIF	Enter Forecast Entries
MRPFFLIF	Load Forecast
MRPFPCMN	Define MRP Names
MRPFPDES	Define Planning Exception Sets
MRPFPDKD	Define Kanban Plans
MRPFPDPN	Define Planner Names
MRPFPKWB	Kanban Workbench
MRPFPPMR	Launch Planning Process
MRPFPVPS	Define Plan Parameters
MRPFSDMS	Enter Master Schedule Entries
MRPFSLMS	Load Master Schedule
MRPFUDAY	View Work Dates
MRPFUDPP	Define Planning Parameters
MRPFUSSM	Start Planning Manager
MRPFVSAH	View Sourcing Assignment Hiearchy
MRPFVSCB	View Supply Chain Bill
MRPSCHRS	Define Scheduling Rules
MRPSCPWB	Supply Chain Planner Workbench
MRPSLSWB	Line Scheduling Workbench
MRPSQLDR	Sql*Loader Parameters

Tags: DRP, MRP, SCP No Comments »

by oracleguru

MRP Profile Options

ORACLE APPS COMMUNITY > Tutorial > MRP

Oracle MRP/Master Scheduling Profile Options:

PROFILE OPTION SHORT CODE	PROFILE OPTION NAME
MRP_SNAP_SUBSTITUTES	MRP:Snapshot Substitute Parts
MRP_RHX_CHECK_PROFILE_FP	MRP: RHX Check Profile
MRP_REC_ACTION_IN_PTF	MRP:Recommend action within PTF
MRP_IGNORE_ALTERNATES	MRP: Ignore Alternate BOM/Routing
MRP_ALTERNATE_SQL	MRP: Use Alternate SQL for Daily Cleanup
MRP_CALC_SUPDT_FROM_NBDT	MRP:Derive PO supply date from need by date
MRP_UPD_REQ_DATE_REL	MRP: Update Requested Completion Date when Releasing Reschedules
MRP_IGNORE_ZERO_QTY_DEMANDS	MRP: Ignore Zero Quantity Demands in Calculating First Bucket for Statistical Forecasting
MRP_EXPLODE_ATO	MRP: Compute Standard Mandatory Components for ATO Models
MRP_ROUND_SOURCE_ENTRIES	MRP: Round Source Entries
MRP_NEW_PLANNER_BACK_COMPATIBILITY	MRP_NEW_PLANNER_BACK_COMPATIBILITY
MRP_EXPL_DEM_THROUGH_PHANTOM	MRP: Explode Demand Through Phantom Component
MRP_ATP_PROGRESS_BAR	MRP: Use Progress Bar for Backlog Workbench
MRP_PLNG_MGR_FIRST_TIME	MRP: Planning Manager Run First Time
MRP_OLD_SO_CUTOFF_DAYS	MRP: Old Sales Orders Cutoff Days
MRP_CUTOFF_HISTORY_DAYS	MRP: Cutoff History Days
MRP_FIRM_OE_XFERRED_INTERNAL_REQ	MRP: Firm Internal Req Transferred to OE
MRP_CALCULATE_PLAN_PERFORMANCE	MRP: Calculate Plan Performance
MRP_SCHED_MGR_BATCH_SIZE	MRP:Planning Manager Batch Size
MRP_SCHED_MGR_MAX_WORKERS	MRP:Planning Manager Max Workers
MRP_SCH_RCP_USEUP	MRP:Include Schd Rcpts in Use-up
MRP_SHIP_ARRIVE_FLAG	MRP:Use Ship Arrived Flag
MRP_SNAPSHOT_PAUSE_FOR_LOCK	MRP:Snapshot Pause for Lock (Minutes)
MRP_SNAPSHOT_WORKERS	MRP:Snapshot Workers
MRP_SRA_CATEGORY_SET	MRP:Sourcing Rule Category Set
MRP_TRACE	MRP:Trace Mode
MRP_DMD_PRIORITY_FLEX_NUM	MSC: Demand Priority Flexfield Attribute
MRP_FIRM_ORDER_TF	MRP:Create Time fence
MRP_ATP_CALC_SD	MRP: Calculate Supply Demand
MRP_ATP_SUB_COMP	MRP:Include Substitute Components
MRP_BALWB_CATEGORY_SET	MRP: Category Set for Backlog Form
MRP_BALWB_TIMEOUT	MRP:Backlog Progress Timeout
MRP_ATP_ASSIGN_SET	MRP:ATP Assignment Set
MRP_ATP_DATABASE_LINK	MRP:ATP Database Link
MRP_BIS_AV_DISCOUNT	MRP: Plan Revenue Discount Percent
MRP_BIS_PRICE_LIST	MRP: Plan Revenue Price List
MRP_CALC_EXCESS_EXCEPT	MRP:Calculate Excess Exceptions on Time Fence
MRP_COMPUTE_SO_CHANGES	MRP:Compute Sales Order Changes
MRP_CONSUME_FC_SET_SUMMARY	MRP:Consume Fcst Set Summary
MRP_CUTOFF_DATE_OFFSET	MRP:Cutoff Date Offset Months
MRP_DEBUG	MRP:Debug Mode
MRP_DEFAULT_ASSIGNMENT_SET	MRP:Default Sourcing Assignment Set
MRP_DEFAULT_DRP_NAME	MRP:Default DRP Plan Name
MRP_DEFAULT_FORECAST	MRP:Default Forecast Name
MRP_DEFAULT_FORECAST_DATE	MRP:Default Forecast Date
MRP_DEFAULT_PLAN	MRP:Default Plan Name
MRP_DEFAULT_SCHEDULE	MRP:Default Schedule Name
MRP_DEMAND_TF	MRP:Demand Time Fence Days
MRP_DIRECT_LOAD	MRP:Use Direct Load Option
MRP_FILES_PATH_ENV_VAR	MRP:Environment variable to set path for MRP files
MRP_FIRM_PO_TF	MRP:Firm Planned Order Time Fence
MRP_FIRM_REQS_WITHIN_TF	MRP: Net All Purchase Orders Prior To Requisitions
MRP_FORECAST_CONSUMPTION	MRP:Consume Forecast
MRP_INTERFACE_HISTORY_DAYS	MRP:Interface Table History Days
MRP_LOAD_REQ_GROUP_BY	MRP:Requisition Load Group Option
MRP_MDS_CONSUMPTION	MRP:Consume MDS
MRP_MPS_CONSUMPTION	MRP:Consume MPS
MRP_MPS_RELIEF_DIRECTION_CONTROL	MRP:MPS Relief Direction
MRP_MPS_TIME_FENCE_WARNING	MRP:Time Fence Warning
MRP_ORIGINAL_SCHEDULE_VERSION	MRP:Maintain Original Schedule Version
MRP_PLANNING_MANAGER_IN_LOADS	MRP:Perform Planning Manager Functions in Loads
MRP_PURGE_BATCH_SIZE	MRP:Purge Batch Size
MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY	MRP:Retain Dates Within Calendar Boundary
MRP_PURCHASING_BY_REVISION	MRP:Purchasing By Revision

Tags: MRP, SCP No Comments »

You are browsing the archive for MRP.

Oracle Material Requirements Planning Tables

Oracle MRP Forms

MRP Profile Options

Sponsor

Tags