APPS.WMS_WORKFLOW_WRAPPERS dependencies on MTL_SECONDARY_INVENTORIES

Line 678: FROM mtl_secondary_inventories

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

Line 692: FROM mtl_secondary_inventories

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