Results for “invfv_organization_items”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
INVFV_ORGANIZATION_ITEMS is a public Oracle EBS view owned by the APPS schema in the Inventory (INV) module. It presents organization-level item attribute data by joining organization code information from HR/MTL parameter structures to the system-item master held in MTL_SYSTEM_ITEMS. The view exposes the full complement of planning, costing, receiving, and physical-attribute columns associated with an inventory item within a specific inventory organization, together with a set of descriptive flexfield and key flexfield context markers (the "_KF:INV:MSTK:SY", "_KF:INV:MTLL:IT", and "_KF:SQLGL:GL#:CO
Because it carries both ORGANIZATION_CODE and the item's segment attributes, the view is frequently the target of ad-hoc queries for the "inventory_item_segment1" style lookup — users search for it when they want to identify or join on a single key flexfield segment (typically segment1, the item number) alongside its owning organization. It is a reporting and integration convenience layer rather than a transaction table.
Underlying Base Objects
The view is defined primarily over MTL_SYSTEM_ITEMS (aliased SY in the view text), which supplies all the item-level attributes, and over organization/parameter objects that supply ORGANIZATION_CODE and organizational context. Documented referenced objects include:
- MTL_SYSTEM_ITEMS — master item attributes (planning, sizing, costing, receiving, UOM).
- MTL_PARAMETERS and HR_ALL_ORGANIZATION_UNITS — provide organization definition and code.
- MTL_ITEM_LOCATIONS, MTL_PICKING_RULES, MTL_ATP_RULES — item/location and sourcing rules referenced in the flexfield joins.
- FND_COMMON_LOOKUPS, FND_GLOBAL — lookup translation and session context (org_id, language).
- GL_CODE_COMBINATIONS — GL account flexfield validation for the accounting segments.
- PO_HAZARD_CLASSES, PO_UN_NUMBERS, RCV_ROUTING_HEADERS — purchasing/receiving defaults.
- RA_RULES, RA_TERMS — receivable rules and payment terms.
- FA_CATEGORIES — asset category for capitalized items.
- PER_PEOPLE_X, HR_PERSON_NAME, HR_SECURITY, HR_GENERAL, CS_COVERAGES_ACTIVE_V — buyer/planner person and security context.
Note the enumerated list of "referenced base objects" reflects the metadata footprint; the actual view text shown drives the projection from MTL_SYSTEM_ITEMS.
Key Columns
ORGANIZATION_CODE— inventory organization short code (from organization parameters), used to scope the item to a warehouse/org.NAME— organization or item display name depending on the join context.- Item planning/sizing columns:
MIN_MINMAX_QUANTITY,MAX_MINMAX_QUANTITY,MINIMUM_ORDER_QUANTITY,FIXED_ORDER_QUANTITY,FIXED_LOT_MULTIPLIER,FIXED_DAYS_SUPPLY,MAXIMUM_ORDER_QUANTITY. - Lead-time columns:
FIXED_LEAD_TIME,VARIABLE_LEAD_TIME,FULL_LEAD_TIME,CUM_MANUFACTURING_LEAD_TIME,CUMULATIVE_TOTAL_LEAD_TIME, plus preprocessing/postprocessing lead time. - Costing columns:
CARRYING_COST,ORDER_COST,UNIT_WEIGHT,UNIT_VOLUME,SHRINKAGE_RATE. - Receiving/UOM columns:
UNIT_OF_ISSUE,PRIMARY_UOM_CODE,PRIMARY_UNIT_OF_MEASURE,QTY_RCV_TOLERANCE,DAYS_EARLY_RECEIPT_ALLOWED,DAYS_LATE_RECEIPT_ALLOWED,INVOICE_CLOSE_TOLERANCE,RECEIVE_CLOSE_TOLERANCE. - Control columns:
INVENTORY_ITEM_STATUS_CODE,PLANNER_CODE,PLANNING_EXCEPTION_SET,ENGINEERING_ECN_CODE, and tax columnsTAX_CODE/PURCHASING_TAX_CODE. - Flexfield context markers (
_KF:...) that instruct EBS to expand key flexfields, including segment1 of the item key flexfield — the target of the "inventory_item_segment1" search.
Common Use Cases and Queries
Typical uses include item master reporting, planning-parameter extraction, and integration extracts that need organization-scoped item attributes.
SELECT organization_code,
name,
primary_uom_code,
inventory_item_status_code,
planner_code,
min_minmax_quantity,
max_minmax_quantity
FROM apps.invfv_organization_items
WHERE organization_code = :org_code;
To isolate the item number segment (segment1) the search implied, join to the underlying item flexfield:
SELECT o.organization_code,
o.name,
msi.segment1 inventory_item_segment1,
o.primary_uom_code,
o.inventory_item_status_code
FROM apps.invfv_organization_items o,
apps.mtl_system_items msi
WHERE msi.organization_id = ...
AND msi.inventory_item_id = ...;
The view is best treated as a read-only reporting object; updates to item attributes must go through the Item Master (MTL_SYSTEM_ITEMS) APIs or the Inventory item form.
-
APPS.INVFV_ORGANIZATION_ITEMS·↳ CS_COVERAGES_ACTIVE_V·↳ FA_CATEGORIES·↳ FND_COMMON_LOOKUPS·Explore INV module →
-
APPS.INVFV_ORGANIZATION_ITEMS·↳ CS_COVERAGES_ACTIVE_V·↳ FA_CATEGORIES·↳ FND_COMMON_LOOKUPS·Explore INV module →
-
SYNONYM: APPS.MTL_ATP_RULES 12.1.1
-
SYNONYM: APPS.MTL_ATP_RULES 12.2.2
-
SYNONYM: APPS.PO_UN_NUMBERS 12.1.1
-
SYNONYM: APPS.PO_UN_NUMBERS 12.2.2
-
SYNONYM: APPS.FA_CATEGORIES 12.1.1
-
SYNONYM: APPS.RA_RULES 12.1.1
-
SYNONYM: APPS.FA_CATEGORIES 12.2.2
-
SYNONYM: APPS.RA_RULES 12.2.2
-
SYNONYM: APPS.RA_TERMS 12.1.1
-
SYNONYM: APPS.RA_TERMS 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
VIEW: APPS.PER_PEOPLE_X 12.2.2
-
VIEW: APPS.PER_PEOPLE_X 12.1.1
-
SYNONYM: APPS.MTL_PARAMETERS 12.1.1
-
SYNONYM: APPS.MTL_PARAMETERS 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PO Tables and Views 12.1.1
Temporary table for tracking a receiving upgrade from Release 9 to Release 10
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - FND Tables and Views 12.2.2
No longer used
-
eTRM - FND Tables and Views 12.1.1
No longer used
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - FND Tables and Views 12.2.2
No longer used
-
eTRM - PO Tables and Views 12.1.1
Temporary table for tracking a receiving upgrade from Release 9 to Release 10