Results for “gross_weight”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
EGO_ITEMS_V is an APPS-owned view in the Oracle E-Business Suite Advanced Product Catalog (EGO) module. It presents a denormalized, integration-oriented projection of item attributes used for UCCNet product synchronization, the standardized data-pool exchange mechanism through which suppliers publish item content to trading partners. The view consolidates item master, cross-reference, unit-of-measure, weight, and GTIN (Global Trade Item Number) attributes into a single flattened result set, avoiding the joins that a consumer would otherwise have to perform against the underlying inventory and catalog tables.
Because UCCNet publication requires an unambiguous GTIN per item and a reliable indicator of whether publication has been attempted and succeeded, EGO_ITEMS_V is primarily used by outbound interfaces, integration extracts, and validation reports operating at the master organization level. The view is documented as VALID under schema APPS and is available in both 12.1.1 and 12.2.2, with no differences in its documented definition relevant to the columns described here.
Underlying Base Objects
The view is defined over one view and a mixture of synonyms resolving to base tables: EGO_ITEM_GTN_ATTRS_B, EGO_UCCNET_EVENTS, FND_FLEX_VALUES_VL, FND_FLEX_VALUE_SETS, MTL_CROSS_REFERENCES_B, MTL_CROSS_REFERENCES_TL, MTL_PARAMETERS, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_B_KFV, and MTL_UNITS_OF_MEASURE_TL. The principal driving objects are MTL_SYSTEM_ITEMS_B_KFV (concatenated key flexfield segments) and MTL_SYSTEM_ITEMS_B, joined on inventory_item_id and linked to MTL_PARAMETERS on organization_id to obtain the master_organization_id. GTIN values are sourced through MTL_CROSS_REFERENCES_B, with the descriptive text taken from MTL_CROSS_REFERENCES_TL filtered by the session language. GTIN and trade-item attributes such as top_gtin, gross_weight, and consumer-unit flags come from EGO_ITEM_GTN_ATTRS_B. Publication status is derived from EGO_UCCNET_EVENTS, and trade item descriptor meanings are resolved from FND_FLEX_VALUE_SETS and FND_FLEX_VALUES_VL using the TRADEITEMDESCVS value set.
Key Columns
The view exposes inventory_item_id, organization_id, and concatenated_segments as its item identifiers, alongside master_organization_id from MTL_PARAMETERS. GTIN is aliased from MTL_CROSS_REFERENCES_B.cross_reference, with cross_reference_type and a language-specific description. UOM data is represented by primary_uom_code and its description.
Trade item content includes trade_item_descriptor and trade_item_descriptor_desc (resolved through the Trade Item Descriptor value set), is_trade_item_a_consumer_unit, unit_weight, gross_weight, and top_gtin. Publication status is a computed CASE expression returning 'Y' when EGO_UCCNET_EVENTS contains a publication event with action NEW_ITEM, INITIAL_LOAD, DATA_CHANGE, or CORRECTION and where the disposition_code is either null or not equal to 'FAILED'. This makes disposition_code the pivot on which the publication_status column depends. Orderability and engineering flags are exposed through customer_order_enabled_flag and eng_item_flag.
Common Use Cases and Queries
Typical uses include identifying publishable items, auditing failed or missing publication events, and extracting GTIN-level content for data-pool feeds. A representative query listing successfully published items is:
SELECT inventory_item_id, organization_id, concatenated_segments, gtin, primary_uom_code, publication_status FROM ego_items_v WHERE publication_status = 'Y';SELECT concatenated_segments, gtin, top_gtin, gross_weight FROM ego_items_v WHERE is_trade_item_a_consumer_unit = 'Y';SELECT ie.inventory_item_id, ie.disposition_code FROM ego_uccnet_events ie WHERE ie.disposition_code = 'FAILED';
Because publication_status is filtered on disposition_code internally, users troubleshooting synchronization failures can compare view output against EGO_UCCNET_EVENTS directly. Note that the view is filtered to the master organization context and should be joined to organization-specific queries only where the underlying joins support it.
-
View: EGO_ITEMS_V 12.2.2
This view provides item attributes used for UCCNet product synchronization
APPS.EGO_ITEMS_V·↳ EGO_ITEM_GTN_ATTRS_B·↳ EGO_UCCNET_EVENTS·↳ FND_FLEX_VALUES_VL·Explore EGO module →
-
View: WSHFV_DELIVERY_LEGS 12.2.2
Full BIS Business View for Delivery Legs
APPS.WSHFV_DELIVERY_LEGS·↳ WSH_DELIVERY_LEGS·↳ WSH_LOCATIONS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSHFV_DELIVERY_LEGS 12.1.1
Full BIS Business View for Delivery Legs
APPS.WSHFV_DELIVERY_LEGS·↳ WSH_DELIVERY_LEGS·↳ WSH_LOCATIONS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSHBV_CONTAINERS 12.1.1
APPS.WSHBV_CONTAINERS·↳ MTL_ITEM_LOCATIONS·↳ MTL_SYSTEM_ITEMS·↳ WSH_DELIVERY_ASSIGNMENTS·Explore WSH module →
-
View: WSHBV_PACKED_CONTAINER 12.1.1
- Retrofitted
APPS.WSHBV_PACKED_CONTAINER·↳ MTL_SYSTEM_ITEMS·↳ WSH_PACKED_CONTAINERS·Explore OE module →
-
View: EGO_ITEMS_V 12.1.1
This view provides item attributes used for UCCNet product synchronization
APPS.EGO_ITEMS_V·↳ EGO_ITEM_GTN_ATTRS_B·↳ EGO_UCCNET_EVENTS·↳ FND_FLEX_VALUES_VL·Explore EGO module →
-
Table: EGO_UCCNET_BASELINES 12.2.2
This table records snapshots of the last set of UCC registration attributes; it is used to determine if a current registration action is a Correct or a Change
-
View: WSH_DEPARTURES_V 12.2.2
Departures for departure planning or ship confirm
APPS.WSH_DEPARTURES_V·↳ FND_GLOBAL·↳ MTL_SYSTEM_ITEMS·↳ SO_LOOKUPS·Explore OE module →
-
View: WSHFV_DEPARTURE 12.2.2
- Retrofitted
APPS.WSHFV_DEPARTURE·↳ MTL_SYSTEM_ITEMS·↳ SO_REPORT_SETS·↳ WSH_DEPARTURES·Explore OE module →
-
View: WSHBV_DELIVERIES 12.1.1
APPS.WSHBV_DELIVERIES·↳ WSH_LOCATIONS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSHFV_PACKED_CONTAINER 12.1.1
- Retrofitted
APPS.WSHFV_PACKED_CONTAINER·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·↳ WSH_DELIVERIES·Explore OE module →
-
View: WSHBV_CONTAINERS 12.2.2
APPS.WSHBV_CONTAINERS·↳ MTL_ITEM_LOCATIONS·↳ MTL_SYSTEM_ITEMS·↳ WSH_DELIVERY_ASSIGNMENTS·Explore WSH module →
-
View: WSHBV_DELIVERY_LEGS 12.1.1
APPS.WSHBV_DELIVERY_LEGS·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSHBV_DELIVERY_LEGS 12.2.2
APPS.WSHBV_DELIVERY_LEGS·↳ WSH_DELIVERY_LEGS·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSHBV_DEPARTURE 12.1.1
- Retrofitted
-
View: WSH_DEPARTURES_V 12.1.1
Departures for departure planning or ship confirm
APPS.WSH_DEPARTURES_V·↳ FND_GLOBAL·↳ MTL_SYSTEM_ITEMS·↳ SO_LOOKUPS·Explore OE module →
-
Interface table for packed containers
-
Packed containers
-
View: POS_HEADERS_V 12.1.1
APPS.POS_HEADERS_V·↳ AP_TERMS_VL·↳ HR_LOCATIONS_ALL_TL·↳ HZ_LOCATIONS·Explore PO module →
-
View: IBE_SHIP_DLVY_V 12.1.1
Stores information about Delivery header
APPS.IBE_SHIP_DLVY_V·↳ AR_LOOKUPS·↳ HZ_LOCATIONS·↳ MTL_UNITS_OF_MEASURE_TL·Explore IBE module →
-
View: POS_HEADERS_V 12.2.2
used to select the header info for Advance Shipment Notice created
APPS.POS_HEADERS_V·↳ AP_TERMS_VL·↳ FND_GLOBAL·↳ HR_LOCATIONS_ALL_TL·Explore POS module →
-
APPS.WSH_NEW_DELIVERIES_OB_GRP_V·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WMS_WP_LINES_GTMP_V 12.2.2
APPS.WMS_WP_LINES_GTMP_V·↳ WMS_WP_LINES_GTMP·Explore WMS module →
-
View: WSHBV_DELIVERY 12.2.2
- Retrofitted
-
View: EGO_GTN_ATTR_CHG_VL 12.2.2
This view stores pending changes information for GDSN single row attributes
APPS.EGO_GTN_ATTR_CHG_VL·↳ EGO_GTN_ATTR_CHG_B·↳ EGO_GTN_ATTR_CHG_TL·Explore EGO module →
-
View: WSH_SS_CONTAINERS_V 12.1.1
APPS.WSH_SS_CONTAINERS_V·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CATEGORY_SETS_VL·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: WSH_SS_SHIPMENT_V 12.2.2
APPS.WSH_SS_SHIPMENT_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore WSH module →
-
View: EGO_GTIN_ATTRS_V 12.2.2
This view contains GTINs and all GDSN attributes (Single-row only). This view is used to send RCIR messages.
APPS.EGO_GTIN_ATTRS_V·↳ EGO_ATTRS_V·↳ EGO_ITEM_GTN_ATTRS_B·↳ EGO_ITEM_GTN_ATTRS_TL·Explore EGO module →
-
- Retrofitted
APPS.RCV_SHIPMENT_HEADERS_MRC_V·↳ RCV_MC_SHIPMENT_HEADERS·↳ RCV_SHIPMENT_HEADERS·Explore PO module →
-
View: WSH_SS_SHIPMENT_V 12.1.1
APPS.WSH_SS_SHIPMENT_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore WSH module →
-
View: WSH_SS_SHIPITEMS_V 12.2.2
APPS.WSH_SS_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: WSH_ITM_SHIPMENT_V 12.2.2
APPS.WSH_ITM_SHIPMENT_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·Explore WSH module →
-
View: CLN_WSH_SS_SHIPITEMS_V 12.1.1
View of delivery line details
APPS.CLN_WSH_SS_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore CLN module →
-
View: CLN_WSH_SS_SHIPMENT_V 12.2.2
View of delivery header details
APPS.CLN_WSH_SS_SHIPMENT_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore CLN module →
-
This view contains GTINs and all GDSN attributes (Single-row only). This view is used to send CIN messages.
APPS.EGO_GTIN_UCCNET_HIER_ATTRS_V·↳ EGO_ATTRS_V·↳ EGO_ITEM_GTN_ATTRS_B·↳ EGO_ITEM_GTN_ATTRS_TL·Explore EGO module →
-
View: POS_ASN_HEADERS_V 12.1.1
APPS.POS_ASN_HEADERS_V·↳ AP_TERMS_VAL_V·↳ FND_DATE·↳ FND_GLOBAL·Explore ICX module →
-
View: WSHBV_PACKED_CONTAINER 12.2.2
- Retrofitted
APPS.WSHBV_PACKED_CONTAINER·↳ MTL_SYSTEM_ITEMS·↳ WSH_PACKED_CONTAINERS·Explore OE module →
-
View: WSH_ITM_CONTAINERS_V 12.2.2
Temporary Table to return WSH_SS_CONTAINERS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
APPS.WSH_ITM_CONTAINERS_V·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CATEGORY_SETS_VL·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: WSHFV_DELIVERIES 12.1.1
Full BIS Business View for Deliveries.
APPS.WSHFV_DELIVERIES·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore WSH module →
-
Interface table for packed containers
-
View: RCV_FTE_HEADERS_V 12.2.2
Header Lines for logistics
APPS.RCV_FTE_HEADERS_V·↳ FND_LOOKUP_VALUES·↳ ORG_FREIGHT_VL·↳ RCV_SHIPMENT_HEADERS·Explore PO module →
-
View: RCV_FTE_HEADERS_V 12.1.1
Header Lines for logistics
APPS.RCV_FTE_HEADERS_V·↳ FND_LOOKUP_VALUES·↳ ORG_FREIGHT_VL·↳ RCV_SHIPMENT_HEADERS·Explore PO module →
-
Shipping departures
-
Packed containers
-
Stores BOE header info when a BOE Invoice is created through IL
-
View: POS_HEADERS_V 12.2.2
APPS.POS_HEADERS_V·↳ AP_TERMS_VL·↳ FND_GLOBAL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
Table: EGO_UCCNET_BASELINES 12.1.1
This table records snapshots of the last set of UCC registration attributes; it is used to determine if a current registration action is a Correct or a Change
-
View: WSHFV_CONTAINERS 12.1.1
Full BIS Business View for Containers
APPS.WSHFV_CONTAINERS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·↳ MTL_PARAMETERS·Explore WSH module →
-
View: WSHFV_DEPARTURE 12.1.1
- Retrofitted
APPS.WSHFV_DEPARTURE·↳ MTL_SYSTEM_ITEMS·↳ SO_REPORT_SETS·↳ WSH_DEPARTURES·Explore OE module →