Unable to join create custom sql label field as we are unable to join wms_label_requests_hist
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