View: MRP_PF_ATP_ITEMS_ALL_V | Oracle EBS ETRM Search

This view is based on the key flexfield view MTL_SYSTEM_ITEMS_B_KFV. It contains columns with padded and unpadded concatenated segments of an item number.

APPS.MTL_ITEM_FLEXFIELDS·↳ MTL_SYSTEM_ITEMS_B_KFV·Explore INV module →

Table: WIP_LINES 12.2.2 hub

owner WIP·WIP - Work in Process·41 columns

Production lines

WIP.WIP_LINES·Explore WIP module →

View: WIP_RES_INST_EQUIPMENTS_V 12.1.1

WIP - Work in Process·32 columns

Equipment resource instances

APPS.WIP_RES_INST_EQUIPMENTS_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →

View: MRP_ATP_BASE_V 12.1.1

MRP - Master Scheduling/MRP·89 columns

ATP/CTP View

APPS.MRP_ATP_BASE_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ MTL_DEMAND_INTERFACE·Explore MRP module →

View: WIP_RES_INST_EMPLOYEES_V 12.2.2

WIP - Work in Process·31 columns

Employee resource instances

APPS.WIP_RES_INST_EMPLOYEES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →

View: WIP_RES_INST_EMPLOYEES_V 12.1.1

WIP - Work in Process·31 columns

Employee resource instances

APPS.WIP_RES_INST_EMPLOYEES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →

View: BOM_DEPARTMENT_RESOURCES_V 12.1.1

BOM - Bills of Material·51 columns

Resources associated with departments

APPS.BOM_DEPARTMENT_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_RESOURCES·Explore BOM module →

View: MTL_GROUP_ATPS_VIEW 12.2.2

INV - Inventory·70 columns

This view is used for ATP and derived from MTL_DEMAND_INTERFACE

APPS.MTL_GROUP_ATPS_VIEW·↳ MTL_DEMAND_INTERFACE·Explore INV module →

Table: WIP_LINES 12.1.1 hub

owner WIP·WIP - Work in Process·41 columns

Production lines

WIP.WIP_LINES·Explore WIP module →

Table: MSC_ST_DEPARTMENT_RESOURCES 12.2.2 standalone

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

The staging table used by the collection program to validate and process data for table MSC_DEPARTMENT_RESOURCES.

MSC.MSC_ST_DEPARTMENT_RESOURCES·Explore MSC module →

View: OE_MTL_SYSTEM_ITEMS_V 12.1.1

ONT - Order Management·244 columns

No longer used

APPS.OE_MTL_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS·Explore ONT module →

View: WIP_RES_INST_EQUIPMENTS_V 12.2.2

WIP - Work in Process·32 columns

Equipment resource instances

APPS.WIP_RES_INST_EQUIPMENTS_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →

View: MTL_GROUP_ATPS_VIEW 12.1.1

INV - Inventory·70 columns

This view is used for ATP and derived from MTL_DEMAND_INTERFACE

APPS.MTL_GROUP_ATPS_VIEW·↳ MTL_DEMAND_INTERFACE·Explore INV module →

Table: BOM_DEPARTMENT_RESOURCES 12.1.1 hub-leaning

owner BOM·BOM - Bills of Material·40 columns

Resources associated with departments

BOM.BOM_DEPARTMENT_RESOURCES·Explore BOM module →

View: MRP_PF_ATP_V 12.1.1

MRP - Master Scheduling/MRP·71 columns

This view is used for ATP and derived from MTL_DEMAND_INTERFACE

APPS.MRP_PF_ATP_V·↳ MTL_DEMAND_INTERFACE·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·Explore MRP module →

Table: BOM_DEPARTMENT_RESOURCES 12.2.2 hub-leaning

owner BOM·BOM - Bills of Material·40 columns

Resources associated with departments

BOM.BOM_DEPARTMENT_RESOURCES·Explore BOM module →

View: MTL_CLIENT_ITEMS_VL 12.2.2

INV - Inventory·403 columns

APPS.MTL_CLIENT_ITEMS_VL·↳ MTL_CLIENT_PARAMETERS_V·↳ MTL_SYSTEM_ITEMS_VL·Explore INV module →

View: BOM_DEPARTMENT_RESOURCES_V 12.2.2

BOM - Bills of Material·51 columns

Resources associated with departments

APPS.BOM_DEPARTMENT_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_RESOURCES·Explore BOM module →

View: MTL_SYSTEM_ITEMS_VL 12.2.2

INV - Inventory·405 columns

System Items multilingual view with concatenated segments column

APPS.MTL_SYSTEM_ITEMS_VL·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →

View: MTL_SYSTEM_ITEMS_B_KFV 12.1.1

INV - Inventory·403 columns

System Items Key Flexfield View

APPS.MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_B·Explore INV module →

View: OE_MTL_SYSTEM_ITEMS_V 12.2.2

ONT - Order Management·244 columns

No longer used

APPS.OE_MTL_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS·Explore ONT module →

View: MRP_ATP_V 12.2.2

MRP - Master Scheduling/MRP·96 columns

ATP/CTP view

APPS.MRP_ATP_V·↳ BOM_BILL_OF_MATERIALS·↳ BOM_CALENDAR_DATES·↳ BOM_DEPARTMENTS·Explore MRP module →

View: MTL_ITEM_FLEXFIELDS 12.2.2

INV - Inventory·377 columns

This view is based on the key flexfield view MTL_SYSTEM_ITEMS_B_KFV. It contains columns with padded and unpadded concatenated segments of an item number.

APPS.MTL_ITEM_FLEXFIELDS·↳ MTL_SYSTEM_ITEMS_B_KFV·Explore INV module →

View: INVFV_ORGANIZATION_ITEMS 12.2.2

INV - Inventory·201 columns

APPS.INVFV_ORGANIZATION_ITEMS·↳ CS_COVERAGES_ACTIVE_V·↳ FA_CATEGORIES·↳ FND_COMMON_LOOKUPS·Explore INV module →

View: MRP_ATP_V 12.1.1

MRP - Master Scheduling/MRP·96 columns

ATP/CTP view

APPS.MRP_ATP_V·↳ BOM_BILL_OF_MATERIALS·↳ BOM_CALENDAR_DATES·↳ BOM_DEPARTMENTS·Explore MRP module →

View: MTL_SYSTEM_ITEMS_B_KFV 12.2.2

INV - Inventory·404 columns

System Items Key Flexfield View

APPS.MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_B·Explore INV module →