Table: MRP_AD_SUB_OPR_RESS | Oracle EBS ETRM Search

Table: MRP_AD_SUB_OPR_RESS 12.2.2

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

MRP.MRP_AD_SUB_OPR_RESS·Explore MRP module →

Table: BOM_STD_OP_RESOURCES 12.2.2 satellite-leaning

owner BOM·BOM - Bills of Material·39 columns

Standard operation resources

BOM.BOM_STD_OP_RESOURCES·Explore BOM module →

View: BOM_STD_OP_RESOURCES_V 12.1.1

BOM - Bills of Material·43 columns

Standard operation resources

APPS.BOM_STD_OP_RESOURCES_V·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_RESOURCES·↳ BOM_STANDARD_OPERATIONS·Explore BOM module →

Table: MRP_AD_OPR_RESS 12.1.1

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

MRP.MRP_AD_OPR_RESS·Explore MRP module →

Table: BOM_SUB_OPERATION_RESOURCES 12.1.1 standalone

owner BOM·BOM - Bills of Material·44 columns

Substitue Resources

BOM.BOM_SUB_OPERATION_RESOURCES·Explore BOM module →

Table: BOM_OPERATION_RESOURCES 12.1.1 satellite-leaning

owner BOM·BOM - Bills of Material·44 columns

Resources on operations

BOM.BOM_OPERATION_RESOURCES·Explore BOM module →

Table: MRP_AD_SUB_OPR_RESS 12.1.1

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

MRP.MRP_AD_SUB_OPR_RESS·Explore MRP module →

Table: MRP_AD_OPR_RESS 12.2.2

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

MRP.MRP_AD_OPR_RESS·Explore MRP module →

Table: EAM_FORECAST_WOR 12.1.1 standalone

owner EAM·EAM - Enterprise Asset Management·71 columns

This table stores the resource requirements associated with forecasted work orders for eAM maintenance budgeting and forecasting.

EAM.EAM_FORECAST_WOR·Explore EAM module →

Table: WIP_OPERATION_RESOURCES 12.2.2 satellite-leaning

owner WIP·WIP - Work in Process·70 columns

Resources necessary for operations

WIP.WIP_OPERATION_RESOURCES·Explore WIP module →

Table: GMP_APS_OUTPUT_DTL 12.2.2 standalone

owner GMP·GMP - Process Manufacturing Process Planning·53 columns

APS Output Detail table

GMP.GMP_APS_OUTPUT_DTL·Explore GMP module →

View: EAM_CFR_RESOURCES_V 12.2.2

EAM - Enterprise Asset Management·59 columns

This view displays information on resources for work orders.This view is used for ERES at the time of Work Order Completion in the XGM

APPS.EAM_CFR_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ MFG_LOOKUPS·Explore EAM module →

Table: BOM_STD_SUB_OP_RESOURCES 12.2.2 link

owner BOM·BOM - Bills of Material·38 columns

BOM_STD_SUB_OP_RESOURCES stores Substitute Resource information for a particular operation for routing.

BOM.BOM_STD_SUB_OP_RESOURCES·Explore BOM module →

Table: BOM_SUB_OP_RESOURCES_INTERFACE 12.2.2

owner BOM·BOM - Bills of Material·66 columns

Substitute resources interface data for routing operations

BOM.BOM_SUB_OP_RESOURCES_INTERFACE·Explore BOM module →

Table: BOM_OP_RESOURCES_INTERFACE 12.2.2

owner BOM·BOM - Bills of Material·66 columns

Operation resources interface data

BOM.BOM_OP_RESOURCES_INTERFACE·Explore BOM module →

Table: BOM_OP_RESOURCES_INTERFACE 12.1.1

owner BOM·BOM - Bills of Material·66 columns

Operation resources interface data

BOM.BOM_OP_RESOURCES_INTERFACE·Explore BOM module →

Table: EAM_FORECAST_WOR 12.2.2 standalone

owner EAM·EAM - Enterprise Asset Management·71 columns

This table stores the resource requirements associated with forecasted work orders for eAM maintenance budgeting and forecasting.

EAM.EAM_FORECAST_WOR·Explore EAM module →

Table: BOM_OP_RESOURCES_ARCHIVE 12.1.1 standalone

owner BOM·BOM - Bills of Material·44 columns

Archive of deleted resources on operations

BOM.BOM_OP_RESOURCES_ARCHIVE·Explore BOM module →

View: BOM_STD_SUB_OP_RESOURCES_V 12.1.1

BOM - Bills of Material·44 columns

This view is for the alternate resources on standard operations

APPS.BOM_STD_SUB_OP_RESOURCES_V·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_RESOURCES·↳ BOM_STANDARD_OPERATIONS·Explore BOM module →

Table: BOM_OPERATION_RESOURCES 12.2.2 satellite-leaning

owner BOM·BOM - Bills of Material·44 columns

Resources on operations

BOM.BOM_OPERATION_RESOURCES·Explore BOM module →

View: BOM_STD_OP_RESOURCES_V 12.2.2

BOM - Bills of Material·45 columns

Standard operation resources

APPS.BOM_STD_OP_RESOURCES_V·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_RESOURCES·↳ BOM_STANDARD_OPERATIONS·Explore BOM module →

View: BOM_STD_SUB_OP_RESOURCES_V 12.2.2

BOM - Bills of Material·44 columns

This view is for the alternate resources on standard operations

APPS.BOM_STD_SUB_OP_RESOURCES_V·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_RESOURCES·↳ BOM_STANDARD_OPERATIONS·Explore BOM module →

Table: BOM_STD_SUB_OP_RESOURCES 12.1.1 link

owner BOM·BOM - Bills of Material·38 columns

BOM.BOM_STD_SUB_OP_RESOURCES·Explore BOM module →

Table: BOM_STD_OP_RESOURCES 12.1.1 satellite-leaning

owner BOM·BOM - Bills of Material·37 columns

Standard operation resources

BOM.BOM_STD_OP_RESOURCES·Explore BOM module →

Table: BOM_SUB_OPERATION_RESOURCES 12.2.2 standalone

owner BOM·BOM - Bills of Material·44 columns

Substitue Resources

BOM.BOM_SUB_OPERATION_RESOURCES·Explore BOM module →

View: BOM_OPERATION_RESOURCES_V 12.2.2

BOM - Bills of Material·50 columns

Operation resources

APPS.BOM_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_OPERATION_RESOURCES·↳ BOM_OPERATION_SEQUENCES·Explore BOM module →

Table: BOM_OP_RESOURCES_ARCHIVE 12.2.2 standalone

owner BOM·BOM - Bills of Material·44 columns

Archive of deleted resources on operations

BOM.BOM_OP_RESOURCES_ARCHIVE·Explore BOM module →

Table: EAM_RESOURCE_IMPORT 12.2.2 standalone

owner EAM·EAM - Enterprise Asset Management·49 columns

Work Order Resource

EAM.EAM_RESOURCE_IMPORT·Explore EAM module →

Table: EAM_RESOURCE_IMPORT 12.1.1 standalone

owner EAM·EAM - Enterprise Asset Management·49 columns

Work Order Resource

EAM.EAM_RESOURCE_IMPORT·Explore EAM module →

View: BOM_SUB_OPERATION_RESOURCES_V 12.1.1

BOM - Bills of Material·49 columns

View for substitue resources

APPS.BOM_SUB_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_OPERATION_SEQUENCES·↳ BOM_RESOURCES·Explore BOM module →

View: BOM_SUB_OPERATION_RESOURCES_V 12.2.2

BOM - Bills of Material·49 columns

View for substitue resources

APPS.BOM_SUB_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_OPERATION_SEQUENCES·↳ BOM_RESOURCES·Explore BOM module →

Table: GMP_APS_OUTPUT_DTL 12.1.1 standalone

owner GMP·GMP - Process Manufacturing Process Planning·53 columns

APS Output Detail table

GMP.GMP_APS_OUTPUT_DTL·Explore GMP module →

Table: BOM_SUB_OP_RESOURCES_INTERFACE 12.1.1

owner BOM·BOM - Bills of Material·65 columns

Substitute resources interface data for routing operations

BOM.BOM_SUB_OP_RESOURCES_INTERFACE·Explore BOM module →

View: BOM_OPERATION_RESOURCES_V 12.1.1

BOM - Bills of Material·50 columns

Operation resources

APPS.BOM_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_OPERATION_RESOURCES·↳ BOM_OPERATION_SEQUENCES·Explore BOM module →

Table: WIP_SUB_OPERATION_RESOURCES 12.1.1 link

owner WIP·WIP - Work in Process·60 columns

Resources necessary for operations

WIP.WIP_SUB_OPERATION_RESOURCES·Explore WIP module →

Table: WIP_SUB_OPERATION_RESOURCES 12.2.2 link

owner WIP·WIP - Work in Process·60 columns

Resources necessary for operations

WIP.WIP_SUB_OPERATION_RESOURCES·Explore WIP module →

View: WIP_SUB_OPERATION_RESOURCES_V 12.1.1

WIP - Work in Process·65 columns

Foreign-key data for WIP_OPERATION_RESOURCES

APPS.WIP_SUB_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore WIP module →

Table: WIP_OPERATION_RESOURCES 12.1.1 satellite-leaning

owner WIP·WIP - Work in Process·70 columns

Resources necessary for operations

WIP.WIP_OPERATION_RESOURCES·Explore WIP module →

View: WIP_SUB_OPERATION_RESOURCES_V 12.2.2

WIP - Work in Process·65 columns

Foreign-key data for WIP_OPERATION_RESOURCES

APPS.WIP_SUB_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore WIP module →

Table: WIP_JOB_DTLS_INTERFACE 12.2.2 standalone

owner WIP·WIP - Work in Process·92 columns

Requests to add/delete/ modify material/resource requirements for jobs and schedules

WIP.WIP_JOB_DTLS_INTERFACE·Explore WIP module →

View: WIP_OPERATION_RESOURCES_INQ_V 12.2.2

WIP - Work in Process·74 columns

Additional data for WIP_OPERATION_RESOURCES

APPS.WIP_OPERATION_RESOURCES_INQ_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore WIP module →

View: WIP_OPERATION_RESOURCES_V 12.2.2

WIP - Work in Process·72 columns

Foreign-key data for WIP_OPERATION_RESOURCES

APPS.WIP_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore WIP module →

View: WIP_OPERATION_RESOURCES_V 12.1.1

WIP - Work in Process·72 columns

Foreign-key data for WIP_OPERATION_RESOURCES

APPS.WIP_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore WIP module →

View: WIP_OPERATION_RESOURCES_INQ_V 12.1.1

WIP - Work in Process·74 columns

Additional data for WIP_OPERATION_RESOURCES

APPS.WIP_OPERATION_RESOURCES_INQ_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore WIP module →

Table: WIP_JOB_DTLS_INTERFACE 12.1.1 standalone

owner WIP·WIP - Work in Process·92 columns

Requests to add/delete/ modify material/resource requirements for jobs and schedules

WIP.WIP_JOB_DTLS_INTERFACE·Explore WIP module →

VIEW: MRP.MRP_AD_SUB_OPR_RESS# 12.2.2

VIEW: MRP.MRP_AD_OPR_RESS# 12.2.2

APPS.BOM_VALIDATE_SUB_OP_RES SQL Statements 12.2.2

VIEW: MSC.MSC_ST_STD_OP_RESOURCES# 12.2.2

APPS.BOM_VALIDATE_SUB_OP_RES SQL Statements 12.1.1

Results for “substitute_group_num”