APPS.WMS_WORKFLOW_WRAPPERS dependencies on MTL_ITEM_LOCATIONS

Line 707: FROM mtl_item_locations

703: IF l_source_locator IS NOT NULL THEN
704: IF p_source_locator_status IS NULL THEN
705: SELECT status_id
706: INTO l_source_locator_status
707: FROM mtl_item_locations
708: WHERE inventory_location_id = l_source_locator
709: AND organization_id = p_source_organization_id;
710: ELSE
711: l_source_locator_status := p_source_locator_status;

Line 721: FROM mtl_item_locations

717: AND l_destination_organization_id IS NOT NULL) THEN
718: IF p_destination_locator_status IS NULL THEN
719: SELECT status_id
720: INTO l_destination_locator_status
721: FROM mtl_item_locations
722: WHERE inventory_location_id = l_destination_locator
723: AND organization_id = l_destination_organization_id;
724: ELSE
725: l_destination_locator_status := p_destination_locator_status;

Line 858: from mtl_item_locations_kfv

854: -- get source locator name
855: IF (l_source_locator IS NOT NULL) THEN
856: select concatenated_segments
857: INTO l_source_locator_n
858: from mtl_item_locations_kfv
859: where inventory_location_id = l_source_locator
860: and organization_id = p_source_organization_id;
861: END IF;
862: l_error:=19;