Table: MSC_ST_WO_SUB_COMP | Oracle EBS ETRM Search

Table: MSC_ST_WO_SUB_COMP 12.2.2

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

MSC.MSC_ST_WO_SUB_COMP·Explore MSC module →

PACKAGE BODY: APPS.WIP_JOB_DTLS_VALIDATIONS 12.1.1

used by 1

View: EAM_BILL_BY_REQUIREMENTS_V 12.1.1

EAM - Enterprise Asset Management·13 columns

A view used to simplify forms coding. Used to display the bill by requirments block for the work order billing form.

APPS.EAM_BILL_BY_REQUIREMENTS_V·↳ BOM_RESOURCES·↳ EAM_WORK_ORDER_BILLS·↳ MTL_SYSTEM_ITEMS·Explore EAM module →

View: EAM_BILL_BY_REQUIREMENTS_V 12.2.2

EAM - Enterprise Asset Management·13 columns

A view used to simplify forms coding. Used to display the bill by requirements block for the work order billing form.

APPS.EAM_BILL_BY_REQUIREMENTS_V·↳ BOM_RESOURCES·↳ EAM_WORK_ORDER_BILLS·↳ MTL_SYSTEM_ITEMS·Explore EAM module →

View: EAM_CAPT_BILL_BY_REQ_V 12.2.2

EAM - Enterprise Asset Management·13 columns

This view will be used to display the materials, direct items and resources of a work order. It is essentially a union of eam_bill_by_requirements_v and direct items view.Note that for direct items, we are fetching only those records from e

APPS.EAM_CAPT_BILL_BY_REQ_V·↳ BOM_RESOURCES·↳ EAM_DIRECT_ITEM_RECS_V·↳ EAM_WORK_ORDER_BILLS·Explore EAM module →

PACKAGE: APPS.WIP_JOB_DTLS_VALIDATIONS 12.1.1

used by 1

PACKAGE: APPS.WIP_JOB_DTLS_VALIDATIONS 12.2.2

used by 1

Table: MSC_WO_SUB_COMP 12.2.2

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

MSC.MSC_WO_SUB_COMP·Explore MSC module →

Table: EAM_CE_WORK_ORDER_LINES 12.2.2 standalone

owner EAM·EAM - Enterprise Asset Management·72 columns

This table contains consolidated work order lines for the estimate. The work order line can be a resource or material line depending upon the values populated in res_id or mat_inventory_item_id.

EAM.EAM_CE_WORK_ORDER_LINES·Explore EAM module →

Table: MSC_GANTT_QUERY 12.2.2 standalone

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

MSC.MSC_GANTT_QUERY·Explore MSC module →

Table: MSC_GANTT_QUERY 12.1.1 standalone

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

MSC.MSC_GANTT_QUERY·Explore MSC module →

View: CST_XLA_WIP_OPERATION_REF_V 12.2.2

BOM - Bills of Material·24 columns

APPS.CST_XLA_WIP_OPERATION_REF_V·↳ WIP_OPERATIONS·Explore BOM module →

View: CST_XLA_WIP_OPERATION_REF_V 12.1.1

BOM - Bills of Material·24 columns

APPS.CST_XLA_WIP_OPERATION_REF_V·↳ WIP_OPERATIONS·Explore BOM module →

PACKAGE BODY: APPS.WIP_JOB_DTLS_VALIDATIONS 12.2.2

used by 1

View: CRP_RESOURCE_HOURS_V 12.2.2

CRP - Capacity·49 columns

View of required resource hours to build an assembly

APPS.CRP_RESOURCE_HOURS_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CRP_RESOURCE_HOURS·Explore CRP module →

View: CRP_RESOURCE_HOURS_V 12.1.1

CRP - Capacity·49 columns

View of required resource hours to build an assembly

APPS.CRP_RESOURCE_HOURS_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CRP_RESOURCE_HOURS·Explore CRP module →

View: MSC_FLP_SUPPLY_DEMAND_V 12.1.1

MSC - Advanced Supply Chain Planning·76 columns

APPS.MSC_FLP_SUPPLY_DEMAND_V·↳ MSC_DEMANDS·↳ MSC_FULL_PEGGING·↳ MSC_GET_NAME·Explore MSC module →

View: MSC_FLP_SUPPLY_DEMAND_V 12.2.2

MSC - Advanced Supply Chain Planning·76 columns

APPS.MSC_FLP_SUPPLY_DEMAND_V·↳ MSC_DEMANDS·↳ MSC_FULL_PEGGING·↳ MSC_GET_NAME·Explore MSC module →

Table: MSC_DEMANDS 12.2.2 satellite-leaning

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

This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID.

MSC.MSC_DEMANDS·Explore MSC module →

Table: MSC_DEMANDS 12.1.1 satellite-leaning

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

This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID.

MSC.MSC_DEMANDS·Explore MSC module →

PACKAGE: APPS.MSC_GET_NAME 12.1.1

used by 158

PACKAGE BODY: APPS.MSC_GET_NAME 12.2.2

used by 169

PACKAGE: APPS.MSC_GET_NAME 12.2.2

used by 169

PACKAGE BODY: APPS.MSC_GET_NAME 12.1.1

used by 158

VIEW: MSC.MSC_ST_WO_SUB_COMP# 12.2.2

PACKAGE BODY: APPS.EAM_WO_SCHEDULE_PVT 12.2.2 PVT API

used by 3

APPS.MSC_CL_RPO_ODS_LOAD SQL Statements 12.2.2

VIEW: MRP.MRP_WO_SUB_COMP# 12.2.2

VIEW: MSC.MSC_WO_SUB_COMP# 12.2.2

APPS.MSC_CL_RPO_ODS_LOAD SQL Statements 12.1.1

TABLE: MSC.MSC_WO_SUB_COMP 12.2.2

owner MSC

PACKAGE: APPS.EAM_WO_SCHEDULE_PVT 12.1.1 PVT API

used by 3

PACKAGE BODY: APPS.MSC_CL_RPO_ODS_LOAD 12.2.2

used by 1

PACKAGE: APPS.EAM_WO_SCHEDULE_PVT 12.2.2 PVT API

used by 3

PACKAGE BODY: APPS.EAM_WO_SCHEDULE_PVT 12.1.1 PVT API

used by 3

APPS.EAM_WO_SCHEDULE_PVT SQL Statements 12.1.1

APPS.EAM_WO_SCHEDULE_PVT SQL Statements 12.2.2

VIEW: APPS.EAM_CAPT_BILL_BY_REQ_V 12.2.2

TABLE: MSC.MSC_GANTT_QUERY 12.2.2

owner MSC

PACKAGE: APPS.MSC_CL_RPO_ODS_LOAD 12.1.1

used by 1

VIEW: APPS.EAM_CAPT_BILL_BY_REQ_V 12.1.1

VIEW: EAM.EAM_CE_WORK_ORDER_LINES# 12.2.2

VIEW: MSC.MSC_ST_WO_SUB_COMP# 12.2.2

owner MSC

VIEW: MRP.MRP_WO_SUB_COMP# 12.2.2

owner MRP

PACKAGE BODY: APPS.MSC_CL_RPO_ODS_LOAD 12.1.1

used by 1

PACKAGE: APPS.MSC_CL_RPO_ODS_LOAD 12.2.2

used by 1

VIEW: MSC.MSC_WO_SUB_COMP# 12.2.2

owner MSC

TABLE: MSC.MSC_ST_WO_SUB_COMP 12.2.2

owner MSC

VIEW: APPS.EAM_BILL_BY_REQUIREMENTS_V 12.2.2

TABLE: MRP.MRP_WO_SUB_COMP 12.2.2

owner MRP

Results for “op_seq_num”