View: MRPBV_PLAN_ITEM_SUPPLIERS | 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: MRP_ITEM_SUPPLIERS 12.2.2 link

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

Stores supplier specific information for items

MRP.MRP_ITEM_SUPPLIERS·Explore MRP module →

View: INVFV_KANBAN_LOCATION_ITEMS 12.2.2

INV - Inventory·34 columns

- Retrofitted

APPS.INVFV_KANBAN_LOCATION_ITEMS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·Explore INV module →

View: MSC_ITEM_SUPPLIER_V 12.1.1

MSC - Advanced Supply Chain Planning·35 columns

APPS.MSC_ITEM_SUPPLIER_V·↳ MSC_GET_NAME·↳ MSC_ITEM_CATEGORIES·↳ MSC_ITEM_SUPPLIERS·Explore MSC module →

View: POBV_RFQ_LINES 12.2.2

PO - Purchasing·30 columns

- Retrofitted

APPS.POBV_RFQ_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →

View: MRP_KANBAN_DETAILS_V 12.2.2

MRP - Master Scheduling/MRP·41 columns

Kanban details view

APPS.MRP_KANBAN_DETAILS_V·↳ FLM_KANBAN_WORKBENCH_UTIL·↳ FND_GLOBAL·↳ MFG_LOOKUPS·Explore MRP module →

Table: MTL_ITEM_SUB_INVENTORIES 12.1.1 hub-leaning

owner INV·INV - Inventory·43 columns

Item-subinventory assignments

INV.MTL_ITEM_SUB_INVENTORIES·Explore INV module →

View: POFV_RFQ_LINES 12.1.1

PO - Purchasing·41 columns

- Retrofitted

APPS.POFV_RFQ_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_CATEGORIES·Explore PO module →

View: MRPBV_PLAN_ITEM_SUPPLIERS 12.2.2

MRP - Master Scheduling/MRP·19 columns

APPS.MRPBV_PLAN_ITEM_SUPPLIERS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·↳ MRP_PLANS·Explore MRP module →

View: MTL_ITEM_SUB_INVENTORIES_ALL_V 12.1.1

INV - Inventory·46 columns

10SC ONLY

APPS.MTL_ITEM_SUB_INVENTORIES_ALL_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →

View: POFV_QUOTATION_LINES 12.2.2

PO - Purchasing·45 columns

- Retrofitted

APPS.POFV_QUOTATION_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_CATEGORIES·Explore PO module →

View: EGO_ITEM_SYNC_OP_V 12.2.2

EGO - Advanced Product Catalog·392 columns

This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel OnPremise

APPS.EGO_ITEM_SYNC_OP_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ORGANIZATION_INFORMATION·↳ MTL_PARAMETERS·Explore EGO module →

View: EGO_ITEM_SYNC_OP_V 12.1.1

EGO - Advanced Product Catalog·392 columns

This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel OnPremise

APPS.EGO_ITEM_SYNC_OP_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ORGANIZATION_INFORMATION·↳ MTL_PARAMETERS·Explore EGO module →

View: MTL_ITEM_SUB_INVENTORIES_ALL_V 12.2.2

INV - Inventory·46 columns

10SC ONLY

APPS.MTL_ITEM_SUB_INVENTORIES_ALL_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →

View: INVFV_KANBAN_LOCATION_ITEMS 12.1.1

INV - Inventory·34 columns

- Retrofitted

APPS.INVFV_KANBAN_LOCATION_ITEMS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·↳ MTL_KANBAN_PULL_SEQUENCES·Explore INV module →

View: INVBV_KANBAN_LOCATION_ITEMS 12.1.1

INV - Inventory·24 columns

- Retrofitted

APPS.INVBV_KANBAN_LOCATION_ITEMS·↳ MTL_KANBAN_PULL_SEQUENCES·Explore INV module →

View: MRP_SYSTEM_ITEMS_SC_V 12.1.1

MRP - Master Scheduling/MRP·41 columns

MRP or MPS planned items view

APPS.MRP_SYSTEM_ITEMS_SC_V·↳ MFG_LOOKUPS·↳ MRP_PLANS·↳ MRP_PLAN_ORGANIZATIONS·Explore MRP module →

View: MRP_SYSTEM_ITEMS_SC_V 12.2.2

MRP - Master Scheduling/MRP·41 columns

MRP or MPS planned items view

APPS.MRP_SYSTEM_ITEMS_SC_V·↳ MFG_LOOKUPS·↳ MRP_PLANS·↳ MRP_PLAN_ORGANIZATIONS·Explore MRP module →

Table: MTL_KANBAN_PULL_SEQUENCES 12.1.1 satellite-leaning

owner INV·INV - Inventory·56 columns

Kanban Pull Sequences

INV.MTL_KANBAN_PULL_SEQUENCES·Explore INV module →

View: ICX_CHV_SCHEDULE_LINES_V 12.2.2

ICX - Oracle iProcurement·59 columns

Obsolete

APPS.ICX_CHV_SCHEDULE_LINES_V·↳ CHV_INQ_SV·↳ CHV_SCHEDULE_HEADERS·↳ CHV_SCHEDULE_ITEMS·Explore ICX module →

View: CSP_ASL_ITEMS_V 12.1.1

CSP - Spares Management·43 columns

This view lists all items on a stocklist

APPS.CSP_ASL_ITEMS_V·↳ CSP_STOCK_LISTS·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore CSP module →

Table: MTL_ITEM_SUB_INVS_INTERFACE 12.1.1

owner INV·INV - Inventory·56 columns

(currently not used)

INV.MTL_ITEM_SUB_INVS_INTERFACE·Explore INV module →

Table: MSC_ST_ITEM_SUPPLIERS 12.2.2 standalone

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

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

MSC.MSC_ST_ITEM_SUPPLIERS·Explore MSC module →

Table: MSC_ST_ITEM_SUPPLIERS 12.1.1 standalone

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

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

MSC.MSC_ST_ITEM_SUPPLIERS·Explore MSC module →

View: MRPBV_PLAN_ORG_ITEMS 12.1.1

MRP - Master Scheduling/MRP·68 columns

APPS.MRPBV_PLAN_ORG_ITEMS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MRP_PLANS·↳ MRP_PLAN_ORGANIZATIONS·Explore MRP module →

View: MRPBV_PLAN_ORG_ITEMS 12.2.2

MRP - Master Scheduling/MRP·68 columns

APPS.MRPBV_PLAN_ORG_ITEMS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MRP_PLANS·↳ MRP_PLAN_ORGANIZATIONS·Explore MRP module →

View: CLN_ITEMMST_ITEMHEADER_V 12.1.1

CLN - Supply Chain Trading Connector for RosettaNet·44 columns

View for the Header section of the Sync Item XML message

APPS.CLN_ITEMMST_ITEMHEADER_V·↳ ARP_ADDR_PKG·↳ CLN_SYNCITEM_PKG·↳ FND_PROFILE·Explore CLN module →

Table: MSC_APCC_ITEM_D 12.2.2

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

MSC.MSC_APCC_ITEM_D·Explore MSC module →

View: MTL_ITEM_FLEXFIELDS 12.1.1

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 →

Table: MTL_KANBAN_TEMPLATES 12.1.1 standalone

owner INV·INV - Inventory·47 columns

Kanban Template

INV.MTL_KANBAN_TEMPLATES·Explore INV module →

View: MRPFV_PLAN_ORG_ITEMS 12.2.2

MRP - Master Scheduling/MRP·72 columns

APPS.MRPFV_PLAN_ORG_ITEMS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MRP_PLANS·↳ MRP_PLAN_ORGANIZATIONS·Explore MRP module →

View: CSP_ITEM_SUB_INVENTORIES_ALL_V 12.1.1

CSP - Spares Management·51 columns

Shows authorized stocklist for the subinventories.

APPS.CSP_ITEM_SUB_INVENTORIES_ALL_V·↳ CSP_STOCK_LISTS·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore CSP module →