PACKAGE BODY: APPS.INV_ITEM_VALIDATION

BOM_BILL_OF_MATERIALS stores information of BOM_STRUCTURES_B which further stores information about manufacturing and engineering bills of material. Each row in this table represents a unique manufacturing or engineering bill and is identif

APPS.BOM_BILL_OF_MATERIALS·↳ BOM_STRUCTURES_B·↳ FND_GLOBAL·Explore BOM module →

View: MRP_SCHEDULE_ITEMS_V 12.1.1

MRP - Master Scheduling/MRP·46 columns

Master schedule items view

APPS.MRP_SCHEDULE_ITEMS_V·↳ BOM_CALENDAR_DATES·↳ MFG_LOOKUPS·↳ MRP_ORGANIZATIONS_V·Explore MRP module →

View: EDW_ITEM_ITEMORG_LCV 12.1.1

ENG - Engineering·51 columns

This view holds item - organization level information

APPS.EDW_ITEM_ITEMORG_LCV·↳ EDWBV_ITEM_ITEMORG_LCV·↳ EDW_ITEMS_PKG·Explore ENG module →

Table: BOM_SMALL_IMPL_TEMP 12.1.1 standalone

owner BOM·BOM - Bills of Material·70 columns

Temporary data for item usage (View Item Usage window)

BOM.BOM_SMALL_IMPL_TEMP·Explore BOM 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: BOM_BILL_OF_MATERIALS_ARCHIVE 12.2.2 standalone

owner BOM·BOM - Bills of Material·50 columns

Bills of material archive

BOM.BOM_BILL_OF_MATERIALS_ARCHIVE·Explore BOM module →

View: BOM_IMPLOSIONS_V 12.2.2

BOM - Bills of Material·64 columns

View for displaying BOM implosions

APPS.BOM_IMPLOSIONS_V·↳ BOM_ALTERNATE_DESIGNATORS_TL·↳ BOM_GLOBALS·↳ BOM_SMALL_IMPL_TEMP·Explore BOM module →

View: EAM_DIRECT_ITEM_RECS_V 12.2.2

EAM - Enterprise Asset Management·55 columns

View to select both the description based direct items as well as non-stockable inventory items

APPS.EAM_DIRECT_ITEM_RECS_V·↳ EAM_WORK_ORDER_DIRECT_ITEMS_V·↳ EAM_WORK_ORDER_REQ_PO_V·↳ FND_GLOBAL·Explore EAM module →

View: BOM_EXPL_INQUIRY_VIEW 12.1.1

BOM - Bills of Material·81 columns

Indented bill of material for window

APPS.BOM_EXPL_INQUIRY_VIEW·↳ BOM_BILL_OF_MATERIALS·↳ BOM_GLOBALS·↳ BOM_SMALL_EXPL_TEMP·Explore BOM 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 →

Table: BOM_BILL_OF_MTLS_INTERFACE 12.1.1 standalone

owner BOM·BOM - Bills of Material·76 columns

Bills of material interface table

BOM.BOM_BILL_OF_MTLS_INTERFACE·Explore BOM 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: EDW_ITEM_ONETIME_ITEMORG_LCV 12.1.1

ENG - Engineering·47 columns

This view holds item organization level onetime item information

APPS.EDW_ITEM_ONETIME_ITEMORG_LCV·↳ MTL_CATEGORIES_KFV·↳ PO_LINES_ALL·↳ PO_REQUISITION_LINES_ALL·Explore ENG 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 →

View: BOM_PLM_EXPLOSION_TEMP 12.1.1

BOM - Bills of Material·93 columns

APPS.BOM_PLM_EXPLOSION_TEMP·↳ BOM_EXPLOSION_TEMP·Explore BOM module →

View: MSC_SYSTEM_ITEMS_SC_V 12.1.1

MSC - Advanced Supply Chain Planning·121 columns

This view shows all the items

APPS.MSC_SYSTEM_ITEMS_SC_V·↳ MSC_GET_NAME·↳ MSC_ITEMS·↳ MSC_ITEM_CATEGORIES·Explore MSC module →

View: MTL_SYSTEM_ITEMS_ER1_V 12.1.1

INV - Inventory·159 columns

ERES : View to support ERES framework for Items

APPS.MTL_SYSTEM_ITEMS_ER1_V·↳ FA_CATEGORIES_B_KFV·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore INV module →

View: EAM_WO_DIRECT_ITEMS_LITE_V 12.2.2

EAM - Enterprise Asset Management·46 columns

This is a light weight version of the view EAM_WORK_ORDER_DIRECT_ITEMS_V.

APPS.EAM_WO_DIRECT_ITEMS_LITE_V·↳ MFG_LOOKUPS·↳ MTL_DEFAULT_CATEGORY_SETS·↳ MTL_ITEM_CATEGORIES·Explore EAM module →

View: MRP_SCHEDULE_ITEMS_V 12.2.2

MRP - Master Scheduling/MRP·46 columns

Master schedule items view

APPS.MRP_SCHEDULE_ITEMS_V·↳ BOM_CALENDAR_DATES·↳ MFG_LOOKUPS·↳ MRP_ORGANIZATIONS_V·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 →

Table: BOM_BILL_OF_MATERIALS_ARCHIVE 12.1.1 standalone

owner BOM·BOM - Bills of Material·50 columns

Bills of material archive

BOM.BOM_BILL_OF_MATERIALS_ARCHIVE·Explore BOM module →

View: EDWBV_ITEM_ITEMORG_LCV 12.1.1

ENG - Engineering·48 columns

This view contains items at the item/organization level.

APPS.EDWBV_ITEM_ITEMORG_LCV·↳ EDW_ITEMS_PKG·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_B_KFV·Explore ENG 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_INVENTORY_COMPONENTS_ERV 12.1.1

BOM - Bills of Material·90 columns

APPS.BOM_INVENTORY_COMPONENTS_ERV·↳ BOM_BILL_OF_MATERIALS·↳ BOM_INVENTORY_COMPONENTS·↳ FND_COMMON_LOOKUPS·Explore BOM module →

View: EGO_ITEM_SYNC_V 12.1.1

EGO - Advanced Product Catalog·391 columns

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

APPS.EGO_ITEM_SYNC_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ORGANIZATION_INFORMATION·↳ MTL_PARAMETERS·Explore EGO module →

View: EAM_WORK_ORDER_DIRECT_ITEMS_V 12.2.2

EAM - Enterprise Asset Management·53 columns

View shows direct item details of a work order.

APPS.EAM_WORK_ORDER_DIRECT_ITEMS_V·↳ FND_GLOBAL·↳ MFG_LOOKUPS·↳ MTL_DEFAULT_CATEGORY_SETS·Explore EAM module →

View: BOM_BILL_OF_MATERIALS_V 12.2.2

BOM - Bills of Material·56 columns

Bills of material

APPS.BOM_BILL_OF_MATERIALS_V·↳ BOM_BILL_OF_MATERIALS·↳ BOM_STRUCTURE_TYPES_B·↳ FND_COMMON_LOOKUPS·Explore BOM module →

View: BOM_COPY_EXPLOSIONS_V 12.2.2

BOM - Bills of Material·71 columns

View for Multi level copy structure

APPS.BOM_COPY_EXPLOSIONS_V·↳ BOM_EXPLODER_PUB·↳ BOM_EXPLOSIONS_ALL·↳ BOM_GLOBALS·Explore BOM module →

View: BOM_COPY_EXPLOSIONS_V 12.1.1

BOM - Bills of Material·71 columns

View for Multi level copy structure

APPS.BOM_COPY_EXPLOSIONS_V·↳ BOM_EXPLODER_PUB·↳ BOM_EXPLOSIONS_ALL·↳ BOM_GLOBALS·Explore BOM 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: MTL_SYSTEM_ITEMS_VL 12.1.1

INV - Inventory·402 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_FVL 12.1.1

INV - Inventory·400 columns

Base view for the Define System Items (INVIDITM) form MTL_SYSTEM_ITEMS block. This view is MLS enabled.

APPS.MTL_SYSTEM_ITEMS_FVL·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →

Results for “effectivity_control”