APPS.WMS_WORKFLOW_WRAPPERS dependencies on MTL_ITEM_LOCATIONS

Line 705: FROM mtl_item_locations

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

Line 719: FROM mtl_item_locations

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

Line 856: from mtl_item_locations_kfv

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