View: WMS_ZONE_LPN_FOR_RULE | Oracle EBS ETRM Search

Foreign Key View for the Locator level in the Inventory Location Dimension. The view will return the DataWarehouse Foreign key corresponding to the OLTP locator. You can also use the get_locator_fk API to do the same.

APPS.EDW_MTL_LOCATOR_FKV·↳ EDW_LOCAL_INSTANCE·↳ MTL_ITEM_LOCATIONS_KFV·↳ MTL_PARAMETERS·Explore OPI module →

View: WMS_ZONE_LPN_FOR_RULE 12.2.2

WMS - Warehouse Management·6 columns

APPS.WMS_ZONE_LPN_FOR_RULE·↳ WMS_LICENSE_PLATE_NUMBERS·↳ WMS_ZONES_VL·↳ WMS_ZONE_LOCATORS·Explore WMS module →

View: CST_XLA_INV_ITEM_LOCS_REF_V 12.2.2

BOM - Bills of Material·22 columns

APPS.CST_XLA_INV_ITEM_LOCS_REF_V·↳ MTL_ITEM_LOCATIONS·Explore BOM module →

Table: WMS_ZONE_LOCATORS 12.1.1 standalone

owner WMS·WMS - Warehouse Management·10 columns

WMS.WMS_ZONE_LOCATORS·Explore WMS module →

Table: WMS_ZONE_LOCATORS 12.2.2 standalone

owner WMS·WMS - Warehouse Management·10 columns

WMS.WMS_ZONE_LOCATORS·Explore WMS module →

View: WSHBV_PACKED_CONTAINER 12.2.2

OE - Order Entry·27 columns

- Retrofitted

APPS.WSHBV_PACKED_CONTAINER·↳ MTL_SYSTEM_ITEMS·↳ WSH_PACKED_CONTAINERS·Explore OE module →

View: WSHFV_PACKED_CONTAINER 12.2.2

OE - Order Entry·39 columns

- Retrofitted

APPS.WSHFV_PACKED_CONTAINER·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·↳ WSH_DELIVERIES·Explore OE module →

View: WSHBV_PICK_LINE_DETAIL 12.2.2

OE - Order Entry·40 columns

- Retrofitted

APPS.WSHBV_PICK_LINE_DETAIL·↳ SO_PICKING_LINE_DETAILS·Explore OE module →

Table: IC_LOCT_MST 12.1.1 satellite-leaning

owner GMI·GMI - Process Manufacturing Inventory·46 columns

This table contains location information for location controlled warehouses.

GMI.IC_LOCT_MST·Explore GMI module →

View: WMS_ZONE_LOCATORS_TEMP 12.2.2

WMS - Warehouse Management·18 columns

View built on temporary table wms_zone_locators_gtmp

APPS.WMS_ZONE_LOCATORS_TEMP·↳ WMS_ZONE_LOCATORS_GTMP·Explore WMS module →

View: WMS_ZONE_LOCATORS_TEMP 12.1.1

WMS - Warehouse Management·18 columns

View built on temporary table wms_zone_locators_gtmp

APPS.WMS_ZONE_LOCATORS_TEMP·↳ WMS_ZONE_LOCATORS_GTMP·Explore WMS module →

Table: WSH_PACKED_CONTAINER_INTERFACE 12.1.1 satellite-leaning

owner OE·OE - Order Entry·49 columns

Interface table for packed containers

OE.WSH_PACKED_CONTAINER_INTERFACE·Explore OE module →

Table: WMS_EXCEPTIONS 12.2.2 link

owner WMS·WMS - Warehouse Management·39 columns

Table to capture task exceptions

WMS.WMS_EXCEPTIONS·Explore WMS module →

View: CST_XLA_INV_ITEM_LOCS_REF_V 12.1.1

BOM - Bills of Material·22 columns

APPS.CST_XLA_INV_ITEM_LOCS_REF_V·↳ MTL_ITEM_LOCATIONS·Explore BOM module →

Table: IC_LOCT_MST 12.2.2 satellite-leaning

owner GMI·GMI - Process Manufacturing Inventory·46 columns

This table contains location information for location controlled warehouses.

GMI.IC_LOCT_MST·Explore GMI module →

View: WMS_ITEM_LOCATIONS_KFV 12.2.2

WMS - Warehouse Management·74 columns

Dummy view for Mobile Locator KFF

APPS.WMS_ITEM_LOCATIONS_KFV·↳ MTL_ITEM_LOCATIONS·Explore WMS module →

View: MTL_ITEM_LOCATIONS_KFV 12.1.1

INV - Inventory·74 columns

Item Locations Key Flexfield View

APPS.MTL_ITEM_LOCATIONS_KFV·↳ MTL_ITEM_LOCATIONS·Explore INV module →

Table: OE_UPGRADE_WSH_IFACE 12.1.1 standalone

owner ONT·ONT - Order Management·55 columns

Sales Order upgrade table - Shipping integration.

ONT.OE_UPGRADE_WSH_IFACE·Explore ONT module →

View: SO_PICKING_LINE_DETAIL_VO_V 12.2.2

OE - Order Entry·60 columns

APPS.SO_PICKING_LINE_DETAIL_VO_V·↳ FND_PROFILE·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_VL·Explore OE module →

View: WSHBV_PACKED_CONTAINER 12.1.1

OE - Order Entry·27 columns

- Retrofitted

APPS.WSHBV_PACKED_CONTAINER·↳ MTL_SYSTEM_ITEMS·↳ WSH_PACKED_CONTAINERS·Explore OE module →

View: SO_PICKING_LINE_DETAIL_VO_V 12.1.1

OE - Order Entry·60 columns

APPS.SO_PICKING_LINE_DETAIL_VO_V·↳ FND_PROFILE·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_VL·Explore OE module →

View: WSH_PACKED_CONTAINERS_V 12.1.1

OE - Order Entry·64 columns

APPS.WSH_PACKED_CONTAINERS_V·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·↳ WSH_PACKED_CONTAINERS·Explore OE module →

Table: WMS_SKIP_TASK_EXCEPTIONS 12.1.1 link

owner WMS·WMS - Warehouse Management·37 columns

Table to capture task exceptions for skipping task

WMS.WMS_SKIP_TASK_EXCEPTIONS·Explore WMS module →

Table: WMS_EXCEPTIONS 12.1.1 link

owner WMS·WMS - Warehouse Management·39 columns

Table to capture task exceptions

WMS.WMS_EXCEPTIONS·Explore WMS module →

View: WSHBV_PICK_LINE_DETAIL 12.1.1

OE - Order Entry·40 columns

- Retrofitted

APPS.WSHBV_PICK_LINE_DETAIL·↳ SO_PICKING_LINE_DETAILS·Explore OE module →

Table: WSH_UPGRADE_PLD_TMP 12.2.2 standalone

owner WSH·WSH - Shipping Execution·74 columns

Table to store picking line details information during upgrade from 11 to 11i

WSH.WSH_UPGRADE_PLD_TMP·Explore WSH module →

Table: WSH_UPGRADE_PLD_TMP 12.1.1 standalone

owner WSH·WSH - Shipping Execution·74 columns

Table to store picking line details information during upgrade from 11 to 11i

WSH.WSH_UPGRADE_PLD_TMP·Explore WSH module →

Table: SO_LINE_DETAILS 12.2.2 link

owner OE·OE - Order Entry·73 columns

Order line schedule details

OE.SO_LINE_DETAILS·Explore OE module →

Table: WMS_SKIP_TASK_EXCEPTIONS 12.2.2 link

owner WMS·WMS - Warehouse Management·37 columns

Table to capture task exceptions for skipping task

WMS.WMS_SKIP_TASK_EXCEPTIONS·Explore WMS module →

View: WSHFV_PACKED_CONTAINER 12.1.1

OE - Order Entry·39 columns

- Retrofitted

APPS.WSHFV_PACKED_CONTAINER·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·↳ WSH_DELIVERIES·Explore OE module →

View: SO_LINE_DETAILS_V 12.2.2

OE - Order Entry·82 columns

APPS.SO_LINE_DETAILS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ MTL_PARAMETERS·Explore OE module →

View: MTL_ITEM_LOCATIONS_KFV 12.2.2

INV - Inventory·74 columns

Item Locations Key Flexfield View

APPS.MTL_ITEM_LOCATIONS_KFV·↳ MTL_ITEM_LOCATIONS·Explore INV module →

Table: WSH_PACKED_CONTAINERS 12.2.2 satellite-leaning

owner OE·OE - Order Entry·48 columns

Packed containers

OE.WSH_PACKED_CONTAINERS·Explore OE module →

View: WMS_ITEM_LOCATIONS_KFV 12.1.1

WMS - Warehouse Management·74 columns

Dummy view for Mobile Locator KFF

APPS.WMS_ITEM_LOCATIONS_KFV·↳ MTL_ITEM_LOCATIONS·Explore WMS module →

View: HZ_SITE_USES_V 12.1.1

AR - Receivables·118 columns

APPS.HZ_SITE_USES_V·↳ AR_RECEIVABLES_TRX·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore AR module →

Table: WSH_PACKED_CONTAINER_INTERFACE 12.2.2 satellite-leaning

owner OE·OE - Order Entry·49 columns

Interface table for packed containers

OE.WSH_PACKED_CONTAINER_INTERFACE·Explore OE module →

Table: WSH_PACKED_CONTAINERS 12.1.1 satellite-leaning

owner OE·OE - Order Entry·48 columns

Packed containers

OE.WSH_PACKED_CONTAINERS·Explore OE module →

Table: OE_UPGRADE_WSH_IFACE 12.2.2 standalone

owner ONT·ONT - Order Management·55 columns

Sales Order upgrade table - Shipping integration.

ONT.OE_UPGRADE_WSH_IFACE·Explore ONT module →

View: AR_SITE_USES_V 12.2.2

AR - Receivables·121 columns

(Release 11.5 Only)

APPS.AR_SITE_USES_V·↳ AR_LOOKUPS·↳ AR_RECEIVABLES_TRX·↳ FND_COMMON_LOOKUPS·Explore AR module →

View: HZ_SITE_USES_V 12.2.2

AR - Receivables·118 columns

APPS.HZ_SITE_USES_V·↳ AR_RECEIVABLES_TRX·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore AR module →

View: WSH_PACKED_CONTAINERS_V 12.2.2

OE - Order Entry·64 columns

APPS.WSH_PACKED_CONTAINERS_V·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·↳ WSH_PACKED_CONTAINERS·Explore OE module →

Table: MTL_ITEM_LOCATIONS 12.2.2 hub-leaning

owner INV·INV - Inventory·94 columns

Definitions for stock locators

INV.MTL_ITEM_LOCATIONS·Explore INV module →

Results for “inventory_location_id”