Inventory Management - EBS (MOSC)

MOSC Banner

Unable to join create custom sql label field as we are unable to join wms_label_requests_hist

edited Oct 14, 2024 4:18PM in Inventory Management - EBS (MOSC) 6 commentsAnswered

Since we are planning on creating a new label for KANBAN replenishment drop - material label type for replenishment drop flow we need few custom SQL query to capture KANBAN CARD NUMBER , SOURCE SUB INVENTORY AND SOURCE LOCATOR

And we are not able to create custom SQL as wms_label_requests table does not have any related fields to join the KANBAN CARD table -mtl_kanban_cards and the wms label request history - wms_label_requests_hist

As the

And we are not able to create custom SQL as wms_label_requests table does not have any related fields to join the KANBAN CARD table -mtl_kanban_cards and the wms label request history - wms_label_requests_hist

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center