Table: AS_MRP_FCT_DETAIL | Oracle EBS ETRM Search

MSC_SYSTEM_ITEMS stores the organization items defined at source applications. It also stores a copy of items planned by the planning process. Most of the columns in MSC_SYSTEM_ITEMS correspond to columns from the Oracle Inventory Item mast

MSC.MSC_SYSTEM_ITEMS·Explore MSC module →

Table: MRP_PLANNING_EXCEPTION_SETS 12.2.2 hub-leaning

owner MRP·MRP - Master Scheduling/MRP·38 columns

Controls for a set of exception messages

MRP.MRP_PLANNING_EXCEPTION_SETS·Explore MRP module →

Table: MSC_ST_SYSTEM_ITEMS 12.2.2 standalone

owner MSC·MSC - Advanced Supply Chain Planning·171 columns

The staging table used by the collection program to valid and process data for table MSC_SYSTEM_ITEMS.

MSC.MSC_ST_SYSTEM_ITEMS·Explore MSC module →

Table: CSP_CURR_SUP_DEM_SUMS 12.2.2 link

owner CSP·CSP - Spares Management·45 columns

Summarized supply and demand information.

CSP.CSP_CURR_SUP_DEM_SUMS·Explore CSP module →

View: CSP_CURR_SUP_DEM_SUMS_V 12.2.2

CSP - Spares Management·49 columns

Supply and demand summary created by batchprogram

APPS.CSP_CURR_SUP_DEM_SUMS_V·↳ CSP_CURR_SUP_DEM_SUMS·↳ CSP_PLANNING_PARAMETERS·↳ CSP_REP_HIERARCHIES·Explore CSP module →

View: CSP_CURR_SUP_DEM_SUMS_V 12.1.1

CSP - Spares Management·49 columns

Supply and demand summary created by batchprogram

APPS.CSP_CURR_SUP_DEM_SUMS_V·↳ CSP_CURR_SUP_DEM_SUMS·↳ CSP_PLANNING_PARAMETERS·↳ CSP_REP_HIERARCHIES·Explore CSP module →

Table: MRP_SYSTEM_ITEMS 12.2.2 hub-leaning

owner MRP·MRP - Master Scheduling/MRP·84 columns

MRP item master

MRP.MRP_SYSTEM_ITEMS·Explore MRP module →

View: MSC_EXCEPTION_DETAILS_V 12.2.2

MSC - Advanced Supply Chain Planning·309 columns

this view picks up all the valid exception details

APPS.MSC_EXCEPTION_DETAILS_V·↳ MSC_DEMANDS·↳ MSC_EXCEPTION_DETAILS·↳ MSC_FULL_PEGGING·Explore MSC module →

View: MSC_EXCEPTION_DETAILS_V 12.1.1

MSC - Advanced Supply Chain Planning·305 columns

this view picks up all the valid exception details

APPS.MSC_EXCEPTION_DETAILS_V·↳ MSC_DEMANDS·↳ MSC_EXCEPTION_DETAILS·↳ MSC_FULL_PEGGING·Explore MSC module →

Table: MRP_SYSTEM_ITEMS 12.1.1 hub-leaning

owner MRP·MRP - Master Scheduling/MRP·84 columns

MRP item master

MRP.MRP_SYSTEM_ITEMS·Explore MRP module →

Table: MSC_ST_SYSTEM_ITEMS 12.1.1 standalone

owner MSC·MSC - Advanced Supply Chain Planning·168 columns

The staging table used by the collection program to valid and process data for table MSC_SYSTEM_ITEMS.

MSC.MSC_ST_SYSTEM_ITEMS·Explore MSC module →

Table: MSC_SYSTEM_ITEMS 12.1.1 hub

owner MSC·MSC - Advanced Supply Chain Planning·218 columns

MSC_SYSTEM_ITEMS stores the organization items defined at source applications. It also stores a copy of items planned by the planning process. Most of the columns in MSC_SYSTEM_ITEMS correspond to columns from the Oracle Inventory Item mast

MSC.MSC_SYSTEM_ITEMS·Explore MSC module →

VIEW: OSM.AS_MRP_FCT_DETAIL# 12.2.2

VIEW: CSP.CSP_SUP_DEM_SUBS# 12.2.2

VIEW: CSP.CSP_SUP_DEM_PNS# 12.2.2

VIEW: CSP.CSP_PLAN_DETAILS# 12.2.2

VIEW: CSP.CSP_PLAN_HISTORIES# 12.2.2

MATERIALIZED VIEW: APPS.CSP_SUP_DEM_SUB_MV 12.1.1

VIEW: CSP.CSP_CURR_SUP_DEM_SUMS# 12.2.2

VIEW: MRP.MRP_PLANNING_EXCEPTION_SETS# 12.2.2

VIEW: CSP.CSP_EXCESS_LISTS# 12.2.2

VIEW: OSM.AS_MRP_FCT_DETAIL# 12.2.2

owner OSM

VIEW: CSP.CSP_PLAN_DETAILS# 12.2.2

owner CSP

VIEW: CSP.CSP_SUP_DEM_PNS# 12.2.2

owner CSP

VIEW: CSP.CSP_SUP_DEM_SUBS# 12.2.2

owner CSP

MATERIALIZED VIEW: APPS.CSP_SUP_DEM_SUB_MV 12.1.1

TABLE: APPS.CSP_SUP_DEM_SUB_MV 12.1.1

MATERIALIZED VIEW: APPS.CSP_SUP_DEM_PN_MV 12.1.1

VIEW: CSP.CSP_PLAN_HISTORIES# 12.2.2

owner CSP

TABLE: CSP.CSP_SUP_DEM_SUB_TEMP 12.2.2

owner CSP

TABLE: APPS.CSP_SUP_DEM_PN_MV 12.1.1

TABLE: OSM.AS_MRP_FCT_DETAIL 12.2.2

owner OSM

TABLE: OSM.AS_MRP_FCT_DETAIL 12.1.1

owner OSM

TABLE: CSP.CSP_SUP_DEM_SUB_TEMP 12.1.1

owner CSP

Results for “excess_quantity”