DBA Data[Home] [Help]

APPS.WMS_WORKFLOW_WRAPPERS dependencies on MTL_SECONDARY_INVENTORIES

Line 680: FROM mtl_secondary_inventories

676: IF l_source_subinventory IS NOT NULL THEN
677: IF p_source_subinventory_status IS NULL THEN
678: SELECT status_id
679: INTO l_source_subinventory_status
680: FROM mtl_secondary_inventories
681: WHERE secondary_inventory_name = l_source_subinventory
682: AND organization_id = p_source_organization_id;
683: ELSE
684: l_source_subinventory_status := p_source_subinventory_status;

Line 694: FROM mtl_secondary_inventories

690: l_destination_organization_id IS NOT NULL) THEN
691: IF p_destination_subinventory_st IS NULL THEN
692: SELECT status_id
693: INTO l_destination_subinventory_st
694: FROM mtl_secondary_inventories
695: WHERE secondary_inventory_name = l_destination_subinventory
696: AND organization_id = l_destination_organization_id;
697: ELSE
698: l_destination_subinventory_st := p_destination_subinventory_st;